下面的语句有问题不:
String sql="update employee set em_name=?,em_sex=?,em_time=?,em_saraly=? where em_id=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,em_name);
pstmt.setString(2,em_sex);
pstmt.setString(3,em_time);
pstmt.setString(4,em_salary);
pstmt.setString(5,em_id);
pstmt.executeUpdate();所有类型都是String,不过执行都修改不了表啊。
String sql="update employee set em_name=?,em_sex=?,em_time=?,em_saraly=? where em_id=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1,em_name);
pstmt.setString(2,em_sex);
pstmt.setString(3,em_time);
pstmt.setString(4,em_salary);
pstmt.setString(5,em_id);
pstmt.executeUpdate();所有类型都是String,不过执行都修改不了表啊。
String sql="update employee set em_name='"+em_name"'where em_id='"+em_id"";有错,知道怎么改。
少个'