《图书管理系统jsp实现(netbeans)》由会员分享,可在线阅读,更多相关《图书管理系统jsp实现(netbeans)(35页珍藏版)》请在金锄头文库上搜索。
1、AddBook.jspaddBookForm.jsp添加图书function isNull( str ) if ( str = ) return true; else return false;var regu = +$; var re = new RegExp(regu); return re.test(str); var bookNameFlag = true;function book_nameF(bookName) if(isNull(bookName)$(#bookName span).html(不能为空);bookNameFlag = false;else$(#bookName s
2、pan).html(); bookNameFlag = true; var authorFlag = true;function authorF(author) if(isNull(author)$(#author span).html(不能为空); authorFlag = false;else$(#author span).html( ); authorFlag = true; var priceFlag = true;function priceF(price) if(isNull(price)$(#price span).html(不能为空); priceFlag = false; e
3、lse if(isNaN(price)$(#price span).html(请输入数字); priceFlag = false;else$(#price span).html( ); priceFlag = true; var isbnFlag = true;function isbnF(isbn) if(isNull(isbn)$(#isbn span).html(不能为空);isbnFlag = false;else$.post(addValidateIsbn.jsp,isbn:isbn, function(data)if(data)$(#isbn span).html(isbn 重复)
4、; isbnFlag = false;else$(#isbn span).html();isbnFlag = true;,json);$(document).ready(function()/页面加载的时候将所有的书籍类型显示出来$.ajax(type:get,url:book_type.jsp,dataType:json,success:function(data)for(var i=0;i+datai.typeName+); ,complete:function()/页面加载的时候执行一次查询search(); ); /页面加载的时候添加样式$(#authorHobby ul li).ad
5、dClass(float_left);/重置$(#addReset).click(function()location.reload(); );var cbf = false;/checkbox 选中个数的限制$(#authorHobby input:checkbox).click(function()if($(#authorHobby input:checkbox:checked).length4)$(#authorHobby div.div_checkbox).next().html(最多只能选择 4 个);cbf = false;else if($(#authorHobby input:
6、checkbox:checked).length添加图书 书名:类型:ISBN:价格:作者:性别:男女爱好:java旅游上网看书睡觉钓鱼吃货跳舞美术 唱歌addValidateISBN.jspBook_type.jsp findAllBookType() List bookTypes = new ArrayList();Connection conn = null;PreparedStatement prep = null;ResultSet rst = null;try conn = getConnection();prep = conn.prepareStatement(findBookT
7、ypeSql);rst = prep.executeQuery();BookType bookType = null;while (rst.next() bookType = new BookType();bookType.setId(rst.getInt(id);bookType.setTypeName(rst.getString(type_name);bookTypes.add(bookType); catch (ClassNotFoundException e) e.printStackTrace();return null; catch (SQLException ex) ex.pri
8、ntStackTrace();return null; finally try if (rst != null) rst.close();if (prep != null) prep.close();closeConnection(); catch (SQLException ex) ex.printStackTrace();return null;return bookTypes;%Books_list.jspparams) StringBuffer sb = new StringBuffer();sb.append(select count(*) from books where 1 );
9、if (!(bookName = null | bookName.equals() sb.append( and book_name=?);params.add(bookName);if (!(isbn = null | isbn.equals() sb.append( and isbn=?);params.add(isbn);if (!(author = null | author.equals() sb.append( and author=?);params.add(author);if (price != null) sb.append( and price=?);params.add
10、(price);if (typeId != null) sb.append( and type_id=?); params.add(typeId);return sb.toString();/创建根据条件查询到相关记录的 SQLpublic String createFindBooksSql(int index, String bookName, String isbn, String author, Float price, Integer typeId, List params) StringBuffer sb = new StringBuffer();sb.append(select *
11、 from books join book_type on book_type.id=books.type_id where 1 );if (!(bookName = null | bookName.equals() sb.append( and book_name=?);params.add(bookName);if (!(isbn = null | isbn.equals() sb.append( and isbn=?);params.add(isbn);if (!(author = null | author.equals() sb.append( and author=?);param
12、s.add(author);if (price != null) sb.append( and price=?);params.add(price);if (typeId != null) sb.append( and type_id=?);params.add(typeId);sb.append( order by books.id desc limit ?,?);return sb.toString();/根据条件查询到总页数public int findPageCountByCondition(int index, String bookName, String isbn, String
13、 author, Float price, Integer typeId, List params) int pageCount = 0; /总页数Connection conn = null;PreparedStatement prep = null;ResultSet rst = null;try conn = getConnection();params = new ArrayList(); /用来存储条件查询时的各种条件值,便于 prep赋值的时候使用String sql = createPageCountSql(bookName, isbn, author, price, typeI
14、d, params);prep = conn.prepareStatement(sql);for (int i = 0; i findBooksByCondition(int index, String bookName, String isbn, String author, Float price, Integer typeId, List params) List books = new ArrayList();Connection conn = null;PreparedStatement prep = null; ResultSet rst = null;try conn = get
15、Connection();params = new ArrayList(); /用来存储条件查询时的各种条件值,便于 prep 赋值的时候使用String sql = createFindBooksSql(index, bookName, isbn, author, price, typeId, params);prep = conn.prepareStatement(sql);for (int i = 0; i params = new ArrayList();int pageCount = findPageCountByCondition(index, bookName, isbn, author, price, typeId, params);List books = findBooksByCondition(index, bookName, isbn, author, price, typeId,