本文共 3889 字，大约阅读时间需要 12 分钟。

模板

bookinfoadd.html

   	
   
		
    		
    
			
     
基本信息
			
     
				
      
					       
        
          
图书名称：
          
          
出版社：
          
         
					        
          
作者：
          
          
图书类别：
          
         
					        
          
剩余数量：
          
         
				       
      
			
     
		
    
		
    
			
     确定 
     取消		
    
	
   
	

bookinfolist.html

function add() {
   			mini.open({
   // 				url : bootPATH + "../pages/bookinfo/bookinfoadd.html",				url : "/bookmanage/pages/bookinfo/bookinfoadd.html",				title : "新增图书",				width : 600,				height : 400,				onload : function() {
   					var iframe = this.getIFrameEl();					var data = {
   						action : "new"					};					iframe.contentWindow.SetData(data);				},				ondestroy : function(action) {
   					var msg = action.split("-");					grid.reload();					if(msg.length > 1){
   						mini.showTips({
   							content: msg[1],							state: 'success',							x: 'center',							y: 'top',							timeout: 5000						});					}				}			});		}

BookInfoDao.java

/**	 * 添加图书	 * @Description 	 * @param bookInfo	 * @return	 */	public int addBookInfo(BookInfo bookInfo) {
   		Connection connection = JDBCUtil.getConnection();		PreparedStatement pStatement = null;				int count = -1;				try {
   			String sql = "insert into bookinfo(bookid,bookname,publisher,author,booktype,remain) values (?,?,?,?,?,?)";			pStatement = connection.prepareStatement(sql);			//填充占位符			pStatement.setString(1, bookInfo.getBookId());			pStatement.setString(2, bookInfo.getBookName());			pStatement.setString(3, bookInfo.getPublisher());			pStatement.setString(4, bookInfo.getAuthor());			pStatement.setInt(5, bookInfo.getBookType());			pStatement.setInt(6, bookInfo.getRemain());						count = pStatement.executeUpdate();					} catch (Exception e) {
   			e.printStackTrace();		}finally {
   			JDBCUtil.closeConnection(connection, pStatement, null);		}				return count;	}	/**	 * 根据作者和图书名称查找图书	 * @Description 	 * @param bookInfo	 * @return	 */	public int findBookWithAuthor(BookInfo bookInfo) {
   		Connection connection = JDBCUtil.getConnection();		PreparedStatement pStatement = null;		ResultSet rSet = null;		int count = -1;				try {
   			String sql = "select * from  bookinfo where bookname = ? and author = ?";			pStatement = connection.prepareStatement(sql);			//填充占位符			pStatement.setString(1, bookInfo.getBookName());			pStatement.setString(2, bookInfo.getAuthor());									rSet = pStatement.executeQuery();			while(rSet.next()) {
   				count = rSet.getInt(1);			}					} catch (Exception e) {
   			e.printStackTrace();		}finally {
   			JDBCUtil.closeConnection(connection, pStatement, null);		}				return count;	}

BookInfoService.java

/**	 * 添加图书	 * @Description 	 * @param bookInfo	 * @return	 */	public int addBookInfo(BookInfo bookInfo) {
   		//生成UUID图书编号		bookInfo.setBookId(UUID.randomUUID().toString());		return bookInfoDao.addBookInfo(bookInfo);	}		/**	 * 根据作者和图书名称查找图书	 * @Description 	 * @param bookInfo	 * @return	 */	public boolean findBookWithAuthor(BookInfo bookInfo) {
   		return bookInfoDao.findBookWithAuthor(bookInfo) > 0 ? true : false;	}

BookInfoAction.java

protected void bookInfoAdd(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   				String bookinfoStr = request.getParameter("data");		BookInfo bookInfo = JSONObject.parseObject(bookinfoStr,BookInfo.class);		Map
   
     resultMap = new HashMap<>();				//验证图书是否重名		if(bookInfoService.findBookWithAuthor(bookInfo)) {
   			resultMap.put("state", "2");			resultMap.put("msg", "该书籍重复");			response.getWriter().print(JSONObject.toJSONString(resultMap));		}else {
   			int count = bookInfoService.addBookInfo(bookInfo);			if(-1 != count) {
   				resultMap.put("state", "1");				resultMap.put("msg", "保存成功");				response.getWriter().print(JSONObject.toJSONString(resultMap));			}else {
   				resultMap.put("state", "2");				resultMap.put("msg", "保存失败");				response.getWriter().print(JSONObject.toJSONString(resultMap));			}		}		}
   

转载地址：http://iruki.baihongyu.com/