WebRoot/jsp/reader/updatereader.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="com.book.util.Util"%>
<%@page import="java.sql.*"%>
<%
	String idStr = request.getParameter("id");
	String name = request.getParameter("name");
	String sex = request.getParameter("sex");
	String email = request.getParameter("email");
	String qq = request.getParameter("qq");
	String phone = request.getParameter("phone");
	String address = request.getParameter("address");
	
		Connection conn =null;
		PreparedStatement ps = null;
		int id = Integer.parseInt(idStr);
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("update book_reader set reader_name = ?,reader_sex=?,reader_phone=?,reader_address=?,email=?,qq=? where reader_id=?");
		 	ps.setString(1,Util.encodeGB2312(name));
		 	ps.setString(2,Util.encodeGB2312(sex));
		 	ps.setString(3,phone);
		 	ps.setString(4,Util.encodeGB2312(address));
		 	ps.setString(5,email);
		 	ps.setString(6,qq);
		 	ps.setInt(7,id);
		 	ps.executeUpdate();
		 	
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,null);
		}
		response.sendRedirect("readerList.jsp");
 %>