0$房天下问答|java编写学生信息查询程序$https://m.fang.com/ask/ask_1797947.html$https://static.soufunimg.com/common_m/m_public/201511/images/asksharedefault.png
packc/pages/ask/detail/detail?askid=1797947
-
java编写学生信息查询程序
是考试作业,做一个连接数据库的查询程序。程序没错,但点查询后出现java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态的错误。高手帮忙,谢谢!部分代码:class RunDemand implements ActionListener { public void actionPerformed (ActionEvent e) { if(e.getSource() == demand) { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String ls = "select * from S where sno ="+snotf.getText(); Connection con = DriverManager.getConnection(url, user, password); Statement sta = con.createStatement(); ResultSet rs = sta.executeQuery(ls); sname1.setText(rs.getString("sname")); sex1.setText(rs.getString("sex")); birthday1.setText(rs.getString("birthday")); nation1.setText(rs.getString("nation")); place1.setText(rs.getString("place")); address1.setText(rs.getString("address")); post1.setText(rs.getString("post")); clname1.setText(rs.getString("clname")); dorm1.setText(rs.getString("dorm")); phone1.setText(rs.getString("phone")); email1.setText(rs.getString("email")); remark1.setText(rs.getString("remark")); }catch(SQLException sqle) { System.out.println(sqle.toString()); }catch(Exception ex){ System.out.println(ex.toString()); } } } }
更多
提问者:cuipengzr85
发布于2011-01-17
免责声明:问答内容均来源于互联网用户,房天下对其内容不负责任,如有版权或其他问题可以联系房天下进行删除。

关注成功