WebRoot/jsp/book/updatetype.jsp

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%
	String idStr = request.getParameter("type_id");
	String type_name = request.getParameter("type_name");
	String remark = request.getParameter("remark");
	
	if(type_name != null && !"".equals(type_name)){
		Connection conn =null;
		PreparedStatement ps = null;
		int id = Integer.parseInt(idStr);
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("update book_type set type_name = ?,remark=? where type_id=?");
		 	ps.setString(1,new String(type_name.getBytes("iso_8859_1"),"gb2312"));
		 	ps.setString(2,remark);
		 	ps.setInt(3,id);
		 	ps.executeUpdate();
		 	
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,null);
		}
		response.sendRedirect("typeList.jsp");
	}
 %>