作业帮No ResultSet was produced异常怎么解决try{Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbc:odbc:PIM","test","1234");java.sql.Statement stmt=con.createStatement();String n=jTextField1.getText();Strin
来源：学生作业帮助网 编辑：作业帮 时间：2024/10/06 15:17:30
No ResultSet was produced异常怎么解决try{Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbc:odbc:PIM","test","1234");java.sql.Statement stmt=con.createStatement();String n=jTextField1.getText();Strin
No ResultSet was produced异常怎么解决
try{
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:PIM","test","1234");
java.sql.Statement stmt=con.createStatement();
String n=jTextField1.getText();
String m=jTextField10.getText();
if(n.equals("")){
JOptionPane.showMessageDialog(null,"请重新输入名字!");
return;
}
String sql = "select dingdanhao,kehu from MN where kehu='" + n + "'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
if( n.equals(rs.getString("kehu"))){
jTextField10.setText(rs.getString("dingdanhao"));
jTextField10.disable();}
}else{
String sq = "update Num set num=num+1 where ID=1 ";
jTextField10.setText(stmt.executeQuery(sq).getString("num"));
jTextField10.disable();
}
stmt.close();
con.close();
}
catch(Exception e){
System.out.println( e.getMessage());
}
No ResultSet was produced异常怎么解决try{Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");Connection con=DriverManager.getConnection("jdbc:odbc:PIM","test","1234");java.sql.Statement stmt=con.createStatement();String n=jTextField1.getText();Strin
看了下你的代码,你的订单号,在数据库中应该是int类型吧,应该不至于是string.这个你确认一下.
如果是int类型,先用Integer.parseInt(n),将n转换成int,sql语句改成
String sql = "select dingdanhao,kehu from MN where kehu=" + n ;
而且你直接使用
if(rs.next())比较暴力,最好加上判断if(rs!=null),然后再对rs进行操作.