jdbc连接数据库,执行到executeUpdate()时就一直没反应,试过输出语句,在此前可以输出,此后就没反应了,代码如下:
public static boolean insert(int id, String pwd, String name,
String phone, String email){
boolean flag = false;
Connection conn = null;
PreparedStatement prep = null;
try {
conn = DriverManager.getConnection(url, dbUser, dbPassword);
String sql = "insert into user_001(id,password,name,phone,email) " +
"values(?,?,?,?,?)";
prep = conn.prepareStatement(sql);
prep.setInt(1, id);
prep.setString(2, pwd);
prep.setString(3, name);
prep.setString(4, phone);
prep.setString(5, email);
System.out.println("before n");
int n = prep.executeUpdate();
System.out.println("n:" + n);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
if(prep != null){
try {
prep.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn != null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return flag;
}
executeUpdate()执行不了
- 写回答
- 好问题 0 提建议
- 关注问题
- 邀请回答
-