// 更新
public boolean doUpdate(Emp emp) throws Exception {
boolean flag = false;
String sql = "update emp set ename=?,job=?,hiredate=?,salary=? where empno=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, emp.getEmpno());
pstmt.setString(2, emp.getEname());
pstmt.setString(3, emp.getJob());
pstmt.setDate(4, new java.sql.Date(emp.getHiredate().getTime()));
pstmt.setFloat(5, emp.getSalary());
if (pstmt.executeUpdate() > 0) {
flag = true;
}
pstmt.close();
System.out.println(flag);
return flag;
}
这样么? 输出是false
public boolean doUpdate(Emp emp) throws Exception {
boolean flag = false;
String sql = "update emp set ename=?,job=?,hiredate=?,salary=? where empno=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, emp.getEmpno());
pstmt.setString(2, emp.getEname());
pstmt.setString(3, emp.getJob());
pstmt.setDate(4, new java.sql.Date(emp.getHiredate().getTime()));
pstmt.setFloat(5, emp.getSalary());
if (pstmt.executeUpdate() > 0) {
flag = true;
}
pstmt.close();
System.out.println(flag);
return flag;
}
这样么? 输出是false
public boolean doUpdate(Emp emp) throws Exception {
boolean flag = false;
String sql = "update emp set ename=?,job=?,hiredate=?,salary=? where empno=?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, emp.getEmpno());
pstmt.setString(2, emp.getEname());
pstmt.setString(3, emp.getJob());
pstmt.setDate(4, new java.sql.Date(emp.getHiredate().getTime()));
pstmt.setFloat(5, emp.getSalary());
if (pstmt.executeUpdate() > 0) {
flag = true;
}
pstmt.close();
System.out.prinln(flag);
return flag;
}
这样么? 输出是false
pstmt = conn.prepareStatement(sql);
pstmt.setInt(4, emp.getEmpno());
pstmt.setString(0 emp.getEname());
pstmt.setString(1 emp.getJob());
pstmt.setDate(2 new java.sql.Date(emp.getHiredate().getTime()));
pstmt.setFloat(3, emp.getSalary());
妹子,你的参数传递错误,对应上