连接sql server 数据库问题（很简单）
sql server驱动已加载成功
程序只能执行到 //rs = stmt.executeQuery(sql);便不能往下执行是为何？
编译能通过 执行是不报错！
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
url ="jdbc:microsoft:sqlserver://SYC:1433;DatabaseName=PersonManager";
//SYC 我的sqlserver服务器
conn = DriverManager.getConnection(url, "sa", "sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from user";
//rs = stmt.executeQuery(sql);
if(!rs.next() ){
JOptionPane msg1 = new JOptionPane();
JOptionPane.showMessageDialog(this,"here","here",1);
}
问题点数：20、回复次数：4Top
1 楼dragon525（）回复于 2004-04-04 12:00:14 得分 0
catch到的异常是什么？Top
2 楼sychallenger（sychallenger）回复于 2004-04-04 18:44:18 得分 0
没异常
Top
3 楼sychallenger（sychallenger）回复于 2004-04-04 18:44:48 得分 0
驱动我已装载 在Tools -> database pilot 中可以看到PersonManager数据库并可看到user表里面的列，但在右边的data项里的添加等符号为灰色 不能操作 使用sql语句
select * from user 执行但错误 为
com.borland.dx.dataset.DataSetException: [Microsoft][SQLServer JDBC Driver]Can't start a cloned connection while in manual transaction mode.
//连接数据库
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
String strTmpUser = "";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://SYC:1433;DatabaseName=PersonManager";
conn = DriverManager.getConnection(url, "sa", "sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//String sql = "select * from user";
rs = stmt.executeQuery("select * from user;");
rs.next();
//String no= rs.getString(0);
String name = rs.getString(1);
System.out.println(name);
}
catch (Exception e) {
e.printStackTrace();
}
Top
4 楼cqlgc（cqlgc）回复于 2004-04-04 19:18:17 得分 20
Tools -> database pilot 中Can't start a cloned connection while in manual transaction mode，要先断开连接，然后重新连接，再次执行就可以了
//连接数据库
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
String strTmpUser = "";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://SYC:1433;DatabaseName=PersonManager";
conn = DriverManager.getConnection(url, "sa", "sa");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//String sql = "select * from user";
rs = stmt.executeQuery("select * from user;");
rs.next();
//String no= rs.getString(0);
String name = rs.getString(1);
System.out.println(name);
add by XXX 2004-4-4
rs.close();
stmt.close();
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}
Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
