JSP怎么修改表中某一字段的值,具体怎么写

2025-04-23 18:16:35
推荐回答(1个)
回答1:

链接数据库的步骤如下:
PreparedStatement pre = null;
Connection conn = DriverManager.getConnection(url);
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "update db_user set password=? where user_id=?";
pre = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
preState.setString(1, password);
preState.setString(2, userid);
ResultSet rs = pre.executeQuery();//执行得到数据集

建议先了解一下读写数据库的基本操作步骤