关于java.sql.SQLException,虚心求教。 把你的代码贴出来看看也许更容易帮你 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public String getRsString(String sField) { try { String s = rs.getString(sField); if (s==null) { //System.out.println("*****"); return ""; } else { //System.out.println(s); return s; } } catch(Exception e) { System.out.println(sField+" getRsString err"+e.toString()); return ""; } } public String getRsDate(String sField) { try { Date d = rs.getDate(sField); if (d==null) { //System.out.println("*****"); return ""; } else { //System.out.println(d.toString()); return d.toString(); } } catch(Exception e) { System.out.println(sField+" getRsDate err:"+e.toString()); return ""; } }public boolean setSql(String Sql) //执行Sql语句,并将ResultSet存入Rs变量中 { try { conn = DriverManager.getConnection(dbUrl, "", ""); state = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs = state.executeQuery(Sql); rs.last(); recordCount = rs.getRow(); pageCount = (int)Math.ceil((float)recordCount/(float)pageSize); if(absolutePage<1) absolutePage=1; if(absolutePage>pageCount) absolutePage=pageCount; rs.absolute((absolutePage-1)*pageSize+1); listCount=1; return true; } catch(SQLException e) { System.out.println("defect setSql error:"+e.toString()); return false; }}public boolean next() //返回下一条查询结果,同时控制分页显示 { try { if(recordCount>0 && listCount++<=pageSize && !rs.isAfterLast()) { defectID = rs.getInt("recordno"); projectID = rs.getInt("pid"); productType=getRsString("cpxh"); defectSN = getRsString("wtbh"); defectShow=getRsString("wtms"); occurOS=getRsString("ospt"); biosver=getRsString("biosver"); kbcver=getRsString("kbcver"); cmsver=getRsString("cmsver"); occurRate=getRsString("fsgl"); occurWide=getRsString("pbx"); snSample=getRsString("snlj"); isOpen=getRsString("wtzt"); processPhase=getRsString("cljd"); dutyMan=getRsString("zrr"); belongTo=getRsString("wtlx"); importantRank=getRsString("yzjb"); priority=getRsString("yxjb"); alterTime=getRsDate("xgrq"); alterMan=getRsString("xgr"); recordTime=getRsDate("bgrq"); recordMan=getRsString("bgr"); occurObject=getRsString("fxdx"); producePhase=getRsString("scjd"); defectFrom=getRsString("qxly"); discoverWay=getRsString("fxtj"); checkTime=getRsDate("qrrq"); checkMan=getRsString("qrr"); planSolveWay=getRsString("jhjjfa"); planSolveStep=getRsString("jhjjbz"); planSolveTime=getRsDate("jhjjrq"); solveWay=getRsString("sjjjfa"); solveStep=getRsString("sjjjbz"); reason=getRsString("yy"); solveTime=getRsDate("jjrq"); solveMan=getRsString("jjr"); solveShow=getRsString("jjjg"); confirmTime=getRsDate("jjqrrq"); confirmMan=getRsString("jjqrr"); closeTime=getRsDate("gbrq"); closeMan=getRsString("gbr"); rs.next(); return true; } else { rs.close(); //defectConn.close(); return false; } } catch(SQLException e) { System.out.println("defect next error:"+e.toString()); return false; } } 如何界面啊?哪里有好的资料啊? Cache问题 一个mysql连接错误 jsp的时间显示问题 大家来看看吧 请教个问题做一个新闻发布系统 生成的静态HTML怎么实现分页 js怎么添加hover事件的触发条件? 自己做一个登录系统,必须要用到数据库吗? 诚心求助,关于Tomcat4.1.12无法启动的问题 如何在javabean中调用另外一个javabean 关于SERVLET问题,急急,一定给分。 急,怎么样用jsp实现文件下载? 如何将dbf数据库导入到oracle中?
{
try
{
String s = rs.getString(sField);
if (s==null)
{
//System.out.println("*****");
return "";
}
else
{
//System.out.println(s);
return s;
}
}
catch(Exception e)
{
System.out.println(sField+" getRsString err"+e.toString());
return "";
}
}
public String getRsDate(String sField)
{
try
{
Date d = rs.getDate(sField);
if (d==null)
{
//System.out.println("*****");
return "";
}
else
{
//System.out.println(d.toString());
return d.toString();
}
}
catch(Exception e)
{
System.out.println(sField+" getRsDate err:"+e.toString());
return "";
}
}public boolean setSql(String Sql) //执行Sql语句,并将ResultSet存入Rs变量中
{
try
{
conn = DriverManager.getConnection(dbUrl, "", "");
state = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = state.executeQuery(Sql);
rs.last();
recordCount = rs.getRow();
pageCount = (int)Math.ceil((float)recordCount/(float)pageSize);
if(absolutePage<1) absolutePage=1;
if(absolutePage>pageCount) absolutePage=pageCount;
rs.absolute((absolutePage-1)*pageSize+1);
listCount=1;
return true;
}
catch(SQLException e)
{
System.out.println("defect setSql error:"+e.toString());
return false;
}
}public boolean next() //返回下一条查询结果,同时控制分页显示
{
try
{
if(recordCount>0 && listCount++<=pageSize && !rs.isAfterLast())
{
defectID = rs.getInt("recordno");
projectID = rs.getInt("pid");
productType=getRsString("cpxh");
defectSN = getRsString("wtbh");
defectShow=getRsString("wtms");
occurOS=getRsString("ospt");
biosver=getRsString("biosver");
kbcver=getRsString("kbcver");
cmsver=getRsString("cmsver");
occurRate=getRsString("fsgl");
occurWide=getRsString("pbx");
snSample=getRsString("snlj");
isOpen=getRsString("wtzt");
processPhase=getRsString("cljd");
dutyMan=getRsString("zrr");
belongTo=getRsString("wtlx");
importantRank=getRsString("yzjb");
priority=getRsString("yxjb");
alterTime=getRsDate("xgrq");
alterMan=getRsString("xgr");
recordTime=getRsDate("bgrq");
recordMan=getRsString("bgr");
occurObject=getRsString("fxdx");
producePhase=getRsString("scjd");
defectFrom=getRsString("qxly");
discoverWay=getRsString("fxtj");
checkTime=getRsDate("qrrq");
checkMan=getRsString("qrr");
planSolveWay=getRsString("jhjjfa");
planSolveStep=getRsString("jhjjbz");
planSolveTime=getRsDate("jhjjrq");
solveWay=getRsString("sjjjfa");
solveStep=getRsString("sjjjbz");
reason=getRsString("yy");
solveTime=getRsDate("jjrq");
solveMan=getRsString("jjr");
solveShow=getRsString("jjjg");
confirmTime=getRsDate("jjqrrq");
confirmMan=getRsString("jjqrr");
closeTime=getRsDate("gbrq");
closeMan=getRsString("gbr");
rs.next();
return true;
}
else
{
rs.close();
//defectConn.close();
return false;
}
}
catch(SQLException e)
{
System.out.println("defect next error:"+e.toString());
return false;
}
}