public int executeUpdate(String sql){
int result = 0;
try{
conn=DriverManager.getConnection(sConnStr,"yljxd","3200467");
Statement stmt = conn.createStatement();
result = stmt.executeUpdate(sql);
}catch(SQLException ex){
System.out.println(ex.getMessage());
}
return result;
}
有错,返回类型不一样
int result = 0;
try{
conn=DriverManager.getConnection(sConnStr,"yljxd","3200467");
Statement stmt = conn.createStatement();
result = stmt.executeUpdate(sql);
}catch(SQLException ex){
System.out.println(ex.getMessage());
}
return result;
}
有错,返回类型不一样
if (request.getParameter("Page") == null || request.getParameter("Page").equals(""))
page_count = 1;
else
page_count = Integer.parseInt(request.getParameter("Page"));
}
catch (java.lang.NumberFormatException e) {
page_count = 1;
}
if (page_count < 1) page_count = 1;
totalPage = messageBean.getTotal();
if (totalPage % pageSize == 0) {
totalPage = totalPage / pageSize;
}
else {
totalPage = (int) Math.floor(totalPage / pageSize) + 1;
}
if (totalPage == 0) {
totalPage = 1;
}
if (page_count > totalPage) page_count = totalPage;Collection messages = messageBean.getMessage(page_count, pageSize, totalPage);
Iterator it = messages.iterator();
while (it.hasNext()) {
int result = 0;
try{
conn=DriverManager.getConnection(sConnStr,"yljxd","3200467");
Statement stmt = conn.createStatement();
result = stmt.executeUpdate(sql);
}catch(SQLException ex){
System.out.println(ex.getMessage());
}
return result;
}executeUpdate(String sql) 这个return int,不是返回ResulstSet
这个换成 Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
就OK了..唉!~~~~