jsp操作数据库之修改

来源：互联网发布：网络教育统考报名网编辑：程序博客网时间：2024/04/24 06:56

思路是要想先修改必须查询到

图片：

查询代码如下：

<%!   public static final String DBDRIVER="org.gjt.mm.mysql.Driver";   public static final String DBURL="jdbc:mysql://localhost:3306/user";   public static final String DBUSER="root";   public static final String DBPASS="************";%><%   Connection conn=null;   PreparedStatement pst=null;   ResultSet rs=null;   String id=null;%><%    try{    Class.forName(DBDRIVER);    conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);     request.setCharacterEncoding("utf-8");     id=request.getParameter("id");    String sql_update="select * from user_table where id='"+id+"'";    pst=conn.prepareStatement(sql_update);    rs=pst.executeQuery();    if(rs.next()){%><form action="doupdate.jsp?id=<%=rs.getString("id")%>" method="post">用户名：<input type="text" value="<%=rs.getString("username")%>" name="user">密码：    <input type="text" value="<%=rs.getString("password") %>" name="psw">用户类型：<select name="ty">          <option value="管理员" >管理员</option>          <option value="普通用户">普通用户</option>            </select><input type="submit" value="修改"><input type="reset" value="取消"></form>    <%     }    }    catch(Exception e){    out.println(e);    }%>

修改代码如下：

<%!      public static final String DBDRIVER="org.gjt.mm.mysql.Driver";      public static final String DBURL="jdbc:mysql://localhost:3306/user";      public static final String DBUSER="root";      public static final String DBPASS="*******";%><%     Connection conn=null;     PreparedStatement pst=null;     int rs=0;     String ids=null;     String user=null;     String psw=null;     String ty=null;%><%   try{     Class.forName(DBDRIVER);   conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);   request.setCharacterEncoding("utf-8");   ids=request.getParameter("id");   user=request.getParameter("user");   psw=request.getParameter("psw");   ty=request.getParameter("ty");   String sql_update="update user_table set username='"+user+"',password='"+psw+"',type='"+ty+"'where id='"+ids+"'";   pst=conn.prepareStatement(sql_update);   rs=pst.executeUpdate();   if(rs!=0){   out.println("更新成功");%><jsp:forward page="query.jsp"></jsp:forward><%   }   }   catch(Exception e){out.println(e);}%>

0 0