连接SQL SERVER 2000,执行了插入操作后
本应该输出:Connection is successfully!
编译执行就出现了这个:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at Test.main(Test.java:30)
请问老大这是个什么异常错误啊???
该怎么解决啊??!!
急救啊!!!!!!!!!!!!!!!!!!
本应该输出:Connection is successfully!
编译执行就出现了这个:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown Source)
at Test.main(Test.java:30)
请问老大这是个什么异常错误啊???
该怎么解决啊??!!
急救啊!!!!!!!!!!!!!!!!!!
怎么会报:没有resultset生成 的错误呢?
赋值错误?
其他语句如insert , update 应该用 executeUpdate
String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbUrl="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TestDB";
String user="bn";
String password="bn";Connection dbConn;
Statement stt;
ResultSet rs;
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbUrl,user,password);
stt= dbConn.createStatement();
rs=stt.executeQuery("insert into stu (number,name,sex) values('001','sky','man')");
System.out.println("Successfully!");
总是报那个错误,请高手指点~~!!!
executeQuery(Sting sql)只能执行查询,不能更新
executeQuery(Sting sql)只能执行查询,不能更新executeQuery改成 executeUpdate()
主要引起错误的是 你用了executeQuery()这个方法 它是用来查询用的 应该用select语句