javabean这样写错在哪里? 报错内容为:onlineconn1.java:40: incompatible typesfound : intrequired: java.sql.ResultSet rs1 = stmt.executeUpdate(sql1); ^ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 /*数据库查询方法*/ public ResultSet executeQuery(String sql) throws Exception{ try { stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(sql); return rs; } catch (Exception e) { throw new Exception(e); // return rs; } } public ResultSet Query(String sql) { try { Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(sql); return rs; } catch (Exception e) { System.out.print(e);//抛出异常 return rs; } } /*数据库更新(删除、插入、更改等)*/ public String executeUpdate(String sql){ try{ stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //得到Statement对象 stmt.executeUpdate(sql); //进行数据库更新 return "succeed"; } catch (Exception e) { System.out.print(e);//抛出异常 return "sorry,you are failed"; } } 之前要加/*数据库连接BEAN*/public class conn {Connection conn = null; Statement stmt = null; ResultSet rs = null; 楼主老大,执行数据库更新操作是不可能返回一个数据集对象的,只能返回操作是否成功的一个整型值。。把你的executeUpdate()方法改写成如下:public void executeUpdate(String sql1) { try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); stmt.executeUpdate(sql1); } catch(SQLException ex1) { System.err.println("aq.executeUpdate: " + ex1.getMessage()); } } public ResultSet executeUpdate(String sql1) { rs1 = null; try { conn = DriverManager.getConnection(sConnStr); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); rs1 = stmt.executeUpdate(sql1); } catch(SQLException ex1) { System.err.println("aq.executeUpdate: " + ex1.getMessage()); } return rs1;这个方法写错了public ResultSet executeUpdate(String sql1) 改为 public void ....不返回或是public int 它只返回你成功update了多少条记录返回int型 文件级联删除 Structs+Hibernate整合时出错!高手来帮忙啊! request.getParameter()的问题 javascript操作input file,提交当时参数被删除 如何找到被iframe嵌套页面的来源地址 求struct jar文件 如何在jsp列表中是某一列显示的内容为超级链接呀?并且应再怎么把参数传递到下一页中? 关于数据库连接池的一个问题,请大家帮忙 关于“页面过期”的问题 jsp连接access那个方法效率高? 奇怪的jsp异常!大家看看! 怎样实现对weblogic7.0提供的connection pool的调用?哪位大大进来指点一二?有实例最好!
public ResultSet executeQuery(String sql) throws Exception{
try { stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
return rs;
}
catch (Exception e) { throw new Exception(e); // return rs;
} }
public ResultSet Query(String sql) {
try {
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
return rs;
} catch (Exception e) {
System.out.print(e);//抛出异常
return rs;
}
} /*数据库更新(删除、插入、更改等)*/
public String executeUpdate(String sql){
try{
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //得到Statement对象
stmt.executeUpdate(sql); //进行数据库更新
return "succeed";
} catch (Exception e) {
System.out.print(e);//抛出异常
return "sorry,you are failed";
}
}
/*数据库连接BEAN*/
public class conn {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
把你的executeUpdate()方法改写成如下:
public void executeUpdate(String sql1)
{
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.executeUpdate(sql1);
}
catch(SQLException ex1)
{
System.err.println("aq.executeUpdate: " + ex1.getMessage());
}
}
{
rs1 = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs1 = stmt.executeUpdate(sql1);
}
catch(SQLException ex1)
{
System.err.println("aq.executeUpdate: " + ex1.getMessage());
}
return rs1;这个方法写错了
public ResultSet executeUpdate(String sql1)
改为 public void ....不返回或是
public int 它只返回你成功update了多少条记录返回int型