java往SQL Server中插入数据插不进去
pf711 2013-04-13 11:30:43 sql中生成了一个用户表,有4个字段,分别是ID(数据库中设定了自动生成,就是为了计数用),身份(varchar型数据),账号(varchar型数据),密码(varchar型数据),但是利用java语句往里边插不进数据。请各位前辈帮忙给指点一下吧,谢谢你们了,
代码如下“
public void connectJDBC(){
Connection conn = null;
PreparedStatement pstmt = null;
String str[] = {"admin","200506095430","123"}
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=学生选课系统","sa","123");
pstmt = conn.prepareStatement("insert into table values (?,?,?)");
pstmt.setInt(1,str[0]);
pstmt.setInt(2,str[1]);
pstmt.setInt(3,str[2]);
pstmt.executeUpdate();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
}finally{
try{
if(pstmt != null){
pstmt.close();
pstmt = null;
}
if(conn != null){
conn.close();
conn = null;
}
}catch (SQLException e){
e.printStackTrace();
}
}
System.out.println("lianshangshujnuku");//调试性语句
}