莫明其妙:servlet数据库操作问题

[cky417]

我做的一个手机移动书店,注册用户时,在数据库添加成功了,但服务器有出错提示,大家帮我看看

dataSource = (DataSource) ic.lookup("bookstoreSource");

String s1 = accinfo.getUserid(); //这是从手机传送过来的数据,测试没问题
String s2 = accinfo.getPassword();
String s3 = accinfo.getUserName();
String s4 = accinfo.getaddress();
String s5 = accinfo.getpost();
String s6 = accinfo.getmail();

conn = dataSource.getConnection();
//获得行数
PreparedStatement ps2 = conn.prepareStatement("insert into userinfo (userid,password,username,address,post,mail)"
+ "values('" + s1 + "','" + s2 + "','" + s3 + "','" + s4 + "',"
+"'" + s5 + "','" + s6 + "')"); //这个语句成功执行,因为数据库里有添加
System.out.println("OK00"); //测试语句,服务器执行到这里就没有了
ResultSet rs2 = ps2.executeQuery();
System.out.println("OK01");
rs2.next();
System.out.println("OK1");
// if (rs1.next())
result.writeInt(1); //返回成功




错误提示如下:
OK00 //测试语句执行
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]No ResultSet set was pr
oduced.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown So
urce)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown So
urce)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatemen
t.java:80)

上面的程序已经在数据库添加成功了,为什么还有这样的提示,莫明其妙?????????

[cky417]

谢谢老大

[zx2002027]

PreparedStatement ps2 = conn.prepareStatement("insert into userinfo (userid,password,username,address,post,mail)"
这里执行的是insert，当然不会返回resultset集
应该用 ps2.executeUpdate();返回int型