62,615
社区成员
发帖
与我相关
我的任务
分享
public void add(StudentAddAction stu){ //返回空就可以了
String sql = " INSERT INTO student(name,sex,birthday,address,emailNum,telephone,departmentId,majorId,gybh) " +
" values(?,?,?,?,?,?,?,?,?)";
boolean b = false;
PreparedStatement stmt = null;
try {
stmt = con.prepareStatement(sql);
stmt.setString(1, stu.getName());
stmt.setString(2, stu.getSex());
stmt.setString(3, stu.getBirthday());
stmt.setString(4, stu.getAddress());
stmt.setString(5, stu.getEmailNum());
stmt.setString(6, stu.getTelephone());
stmt.setString(7, stu.getDepartmentId());
stmt.setString(8, stu.getMajorId());
stmt.setString(9, stu.getGybh());
b = stmt.execute();
} catch (SQLException e) {
System.out.println("插入失败");//如果插入失败,就会执行catch子句啊,可在这提示插入失败
}finally{ //关闭对象应该放在finally里,因为不管操作成功与否,都应该关
if(stmt!=null){
try {
stmt.close();//关闭statement对象链接
} catch (SQLException e1) {
e1.printStackTrace();
}
}
if(con!=null){//con连接也应该关的,且关时,应该遵循先开的后关原则啊,否则会报异常
try {
con.close();//关闭statement对象链接
} catch (SQLException e2) {
e2.printStackTrace();
}
}
}
}
if(stmt.executeUpdate()>0){
b=true;
}else b=false;
return b