jdbc连接sql server 2000,insert不能编译???
incompatible types
found : int
required: java.sql.ResultSet
ResultSet rs= stmt.executeUpdate(
^
1 error
我知道是数据类型不匹配,可是看executeUpdate中没有int型啊?
请指教啊
代码如下
import java.sql.*;
public class SqlInsert{
public static void main(String args[]){
int driverId=70;
String name="百合";
boolean gender=true;
String birthday="1989-11-22";
String dscp="野小孩";
String query="INSERT INTO Driver ";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:tai");
Statement stmt= conn.createStatement();
ResultSet rs= stmt.executeUpdate(
query+
"(driverId,name,gender,birthday,dscp)VALUES"+
"("+driverId+","+name+","+gender+","+birthday+","+dscp+")" );
conn.close();
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
}
}