public static void inserdata()
{
ResultSet rs=null;
try {
Class.forName(sDBDriver);
} catch (Exception ex) {ex.printStackTrace();}
String sql="insert into userInfo values('5','user','password','school')";
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (Exception ex) {ex.printStackTrace();} }
public static void main(String args[])
{
inserdata();
}错误:NO ResultSet was Produced
{
ResultSet rs=null;
try {
Class.forName(sDBDriver);
} catch (Exception ex) {ex.printStackTrace();}
String sql="insert into userInfo values('5','user','password','school')";
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (Exception ex) {ex.printStackTrace();} }
public static void main(String args[])
{
inserdata();
}错误:NO ResultSet was Produced
public static void inserdata()
{
try {
Class.forName(sDBDriver);
} catch (Exception ex) {ex.printStackTrace();}
String sql="insert into user(user,password,school) values('fgh','fgh','gh')";
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeQuery(sql);
} catch (Exception ex) {ex.printStackTrace();} }
public static void main(String args[])
{
inserdata();
}
}
你的sConnStr怎么没看到你赋值?
是执行更新操作,本来就是没返回值的,rs=stmt.executeQuery(sql);就是个错误语句
stmt.executeUpdate(sql);的返回值是个整数,返回1表示成功