WebRoot/jsp/book/editbook.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="com.book.pojo.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312">
<title>编辑图书信息</title>
<%
	String idStr = request.getParameter("book_id");
	
	int id = Integer.parseInt(idStr);
	
	Connection conn =null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	BookInfo book = new BookInfo();
	List list = new ArrayList();
	try{
	 	conn = DBHelper.getConnection();
	 	ps = conn.prepareStatement("select * from book_info where book_id="+id);
	 	rs = ps.executeQuery();
		if(rs.next()){
			book.setBook_id(rs.getInt(1));
		 	book.setBook_name(rs.getString(2));
		 	book.setBook_author(rs.getString(3));
		 	book.setBook_concerm(rs.getString(4));
		 	book.setBook_isbn(rs.getString(5));
		 	book.setBook_price(rs.getDouble(6));
		 	book.setBook_editon(rs.getString(7));
		 	book.setBook_size(rs.getString(8));
		 	book.setBook_count(rs.getInt(9));
		 	book.setRemark(rs.getString(10));
		 	book.setType_id(rs.getInt(11));
		}
		
		ps = conn.prepareStatement("select * from book_type");
		rs = ps.executeQuery();
		while(rs.next()){
		 	BookType type = new BookType();
		 	type.setType_id(rs.getInt(1));
		 	type.setType_name(rs.getString(2));
		 	list.add(type);
		 }
		 request.setAttribute("typeList",list);
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		DBHelper.close(conn,ps,null);
	}
 %>
<style type="text/css">
<!--
body {
	margin-left: 3px;
	margin-top: 0px;
	margin-right: 3px;
	margin-bottom: 0px;