WebRoot/jsp/book/addbook.jsp

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

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

<%@ page language="java" contentType="text/html; charset=GB2312"  pageEncoding="GB2312"%>
<%@page import="com.book.dao.DBHelper"%>
<%@page import="java.sql.*"%>
<%@page import="com.book.pojo.*"%>
<%@page import="java.util.*"%>
<%@page import="com.book.util.*"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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 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;
	ResultSet rs = null;
	
	if(book_name == null){
		List list = new ArrayList();
		try{
		 	conn = DBHelper.getConnection();
		 	ps = conn.prepareStatement("select type_id,type_name 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,rs);
		}
	}else{
		try{
			conn = DBHelper.getConnection();
			int typeId = Integer.parseInt(type_id);
			int count = Integer.parseInt(book_count);
			ps = conn.prepareStatement("insert into book_info (book_name,book_author,book_concerm,book_isbn,book_count,remark,type_id,book_price,book_editon,book_size) values (?,?,?,?,?,?,?,?,?,?)");
			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));