No ResultSet was produced异常怎么解决
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/10/02 18:18:28
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());
}
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());
}
看了下你的代码,你的订单号,在数据库中应该是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进行操作.
如果是int类型,先用Integer.parseInt(n),将n转换成int,sql语句改成
String sql = "select dingdanhao,kehu from MN where kehu=" + n ;
而且你直接使用
if(rs.next())比较暴力,最好加上判断if(rs!=null),然后再对rs进行操作.
No ResultSet was produced异常怎么解决
异常:java.lang.IllegalStateException怎么解决?
jdbc ResultSet 结果集 怎么处理
when was the machine produced
There was no sorrow there was no pain怎么翻译
英语一些语法问题1,ing,ed怎么区分比如 a.The remainder was produced from nat
精子精液异常,精子异常怎么治
java.lang.IllegalArgumentException是什么异常,如何解决.
异常怎么造句
欣喜异常怎么造句
After the new technique was introduced the factory produced
the film was produced by spielberg.改主动语态