java no resultset_java异常，java.sql.SQLException: No ResultSet was produced

java.sql.SQLException:NoResultSetwasproduced添加还是成功了，为什么会报这个异常啊，哪里出问题了，怎么修改啊//删除importjava.sql.Connection;importjava.sql.DriverManager;imp...

java.sql.SQLException: No ResultSet was produced

添加还是成功了，为什么会报这个异常啊，哪里出问题了，怎么修改啊

//删除

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

public class l11_6{

public static void main(String[]args){

PreparedStatement ps=null;

Connection ct=null;

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载一个驱动程序

ct=DriverManager.getConnection("jdbc:odbc:SQL","sa","000000");

sm=ct.createStatement();

ps=ct.prepareStatement("insert into bumen values(?,?,?)");

ps.setInt(1, 16); //

ps.setString(2, "运输");

ps.setString(3, "山外");

ResultSet rs=ps.executeQuery();

//rs=ps.executeQuery(sql);

}

catch(Exception e){

e.printStackTrace();

}

finally{

try{

if(sm!=null){

sm.close();

}

if(ct!=null){

ct.close();

}

}

catch(Exception e){ }

}

}

}

展开