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

bookinfolist.html

   
   	
   
		
    
			
     
				      
       
					        
增加
					        
  
					        
 查询 
				       
			      
     
		
    
	
   
	
   
		
    
     			
     
			
     
      图书编号
     
			
     
      图书名称
     
 			
     
      出版社
     
			
     
      作者
     
			
     
      图书类别
     
			
     
      剩余数量
     
			
     
      操作按钮
     
		
    
	
   
	

bookinfoaddupdate.html

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

BookInfoDao.java

/**	 * 修改图书	 * @Description 	 * @param bookInfo	 * @return	 */	public int updateBookInfo(BookInfo bookInfo) {
   		Connection connection = JDBCUtil.getConnection();		PreparedStatement pStatement = null;				int count = -1;				try {
   			String sql = "update bookinfo set publisher = ? ,booktype = ? where bookid = ?";			pStatement = connection.prepareStatement(sql);			//填充占位符						pStatement.setString(1, bookInfo.getPublisher());			pStatement.setInt(2, bookInfo.getBookType());			pStatement.setString(3, bookInfo.getBookId());						count = pStatement.executeUpdate();					} catch (Exception e) {
   			e.printStackTrace();		}finally {
   			JDBCUtil.closeConnection(connection, pStatement, null);		}				return count;	}

BookInfoService.java

/**	 * 修改图书	 * @Description 	 * @param bookInfo	 * @return	 */	public int updateBookInfo(BookInfo bookInfo) {
   				return bookInfoDao.updateBookInfo(bookInfo);	}

BookInfoAction.java

/**	 * 添加或修改图书	 * @Description 	 * @param request	 * @param response	 * @throws ServletException	 * @throws IOException	 */	protected void bookInfoAddUpdate(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
   				String bookInfoStr = request.getParameter("data");		BookInfo bookInfo = JSONObject.parseObject(bookInfoStr,BookInfo.class);		Map
   
     resultMap = new HashMap<>();				//为空则为添加图书,否则为修改图书		if(StringUtils.isEmpty(bookInfo.getBookId())){
   			//验证图书是否重名			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));				}			}			}else {
   			int count = bookInfoService.updateBookInfo(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://sruki.baihongyu.com/