sql = "update userinfo set username=?,password=?,ip=? where username=" + username;pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.setString(3, IP);update语句中 能用?代替吗。???????我知道insert 语句中能用。
sql = "insert into userinfo (username,password,ip) values(?,?,?)";
pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.setString(3, IP);update语句中 能用?代替吗。???????我知道insert 语句中能用。
sql = "insert into userinfo (username,password,ip) values(?,?,?)";
/*
* 通过id修改用户
*/
public boolean user_update(int id, String usp) {
// TODO Auto-generated method stub
int i=0;
String sql="update tb_user set user_password = ? where id = ?";
//System.out.println(sql);
conn=JDBCUtil.getConnection();
try {
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, usp);
pstmt.setInt(2, id);
i = pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JDBCUtil.close(conn, stmt, pstmt, rs);
}
return i>0;
}
}