WebRoot/jsp/book/updatebook.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("book_id");
	String book_name = request.getParameter("book_name");
	String book_author = request.getParameter("book_author");
	String book_concerm = request.getParameter("book_concerm");
	String book_isbn = request.getParameter("book_isbn");
	String book_count = request.getParameter("book_count");
	String remark = request.getParameter("remark");
	String type_id = request.getParameter("type_id");
	String price = request.getParameter("price");
	String editon = request.getParameter("editon");
	String size = request.getParameter("size");
	
		Connection conn =null;
		PreparedStatement ps = null;
		int id = Integer.parseInt(idStr);
		int count = Integer.parseInt(book_count);
		int typeId = Integer.parseInt(type_id);
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("update book_info set book_name = ?,book_author=?,book_concerm=?,book_isbn=?,book_count=?,remark=?,type_id=?,book_price=?,book_editon=?,book_size=? where book_id=?");
		 	ps.setString(1,Util.encodeGB2312(book_name));
		 	ps.setString(2,Util.encodeGB2312(book_author));
		 	ps.setString(3,Util.encodeGB2312(book_concerm));
		 	ps.setString(4,book_isbn);
		 	ps.setInt(5,count);
		 	ps.setString(6,Util.encodeGB2312(remark));
		 	ps.setInt(7,typeId);
		 	ps.setDouble(8,Double.parseDouble(price));
		 	ps.setString(9,editon);
		 	ps.setString(10,size);
		 	ps.setInt(11,id);
		 	ps.executeUpdate();
		 	
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			DBHelper.close(conn,ps,null);
		}
		response.sendRedirect("bookList.jsp");
 %>