bookdao.java

来自「图书管理系统。JSP+Struts(MVC框架)sql2000数据库」· Java 代码 · 共 360 行 · 第 1/2 页

package com.dao;

import java.sql.SQLException;
import java.sql.*;
import java.lang.String;
import org.apache.xml.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.tool.JDBCConnection;
import com.actionForm.BookForm;
import java.util.*;
import java.sql.ResultSet;
import com.tool.DealwithString;
import java.lang.String;

public class BookDao {
    private JDBCConnection con=null;

    public BookDao(){
       con=new JDBCConnection();
       this.con.createConnection();
    }
////////////////////////////////////////////////////////
    //添加图书信息的方法
   public boolean insertBook(BookForm bookForm) {
       try{
           String sql = "insert into tb_book values('" + bookForm.getBookNumber() +
                        "','" + bookForm.getLineNumber()
                        + "','" + bookForm.getBookName() + "','" +
                        bookForm.getAuthor() + "','" + bookForm.getPublish()
                        + "','" + bookForm.getPublishNumber() + "','" +
                        bookForm.getSortNumber()
                        + "','" + bookForm.getInPirce() + "','" +
                        bookForm.getSinglePirce() + "','" + bookForm.getBookSum()
                        + "','" + bookForm.getMan() + "','" +
                        bookForm.getCreatime() + "')";
           con.executeUpdata(sql);
           con.closeConneciton();
           return true;
       }catch(Exception e){
       return false;
       }
    }

/*************************************************************/
    //删除图书
    public boolean deleteBook(BookForm bookForm) {
        try{
            String sql = "delete from tb_book where bookNumber='" + bookForm.getBookNumber() +"'";
            con.executeUpdata(sql);
            con.closeConneciton();
            return true;
        }catch(Exception e){
            return false;}

    }
/********************************************************************/
    //以图书编号修改图书全部信息
      public boolean UpdateBook(BookForm  bookForm){
          //TBBookActionForm bookForm=null;
          try{
              String sql = "update tb_book set lineNumber='" +
                           bookForm.getLineNumber() + "',bookName='"+bookForm.getBookName()+"',author='" +
                           bookForm.getAuthor() + "',publish='" +
                           bookForm.getPublish() + "',publishNumber='" +
                           bookForm.getPublishNumber() + "',sortNumber='" +
                           bookForm.getSortNumber() + "',inPirce='" +
                           bookForm.getInPirce() + "',singlePirce='" +
                           bookForm.getSinglePirce() + "',bookSum='" +
                           bookForm.getBookSum() + "',man='" + bookForm.getMan() +
                           "',creatime='" + bookForm.getCreatime() +
                           "' where bookNumber='" + bookForm.getBookNumber() + "'";
              con.executeUpdata(sql);
              con.closeConneciton();
          }catch(Exception e){
          System.out.println("图书信息修改失败！！！");
          }
          return true;
  }
  /*****************************************************************************/
  //以图书编号为条件修改图书数量
          public boolean addBook(BookForm form) {
             try{
                 String sql = "update tb_book set bookSum='" + form.getBookSum()
                              + "' where bookNumber='" + form.getBookNumber() +
                              "'";
                 con.executeUpdata(sql);
                 con.closeConneciton();
                 System.out.println("updateBook is successful");
                 return true;
             }catch(Exception e){
                 return false;
             }
         }
/*************************************************************************/
         //以图书条形码为条件修改图书数量
         public boolean addOneBook(BookForm form) {
            try{
                String sql = "update tb_book set bookSum='" + form.getBookSum()
                             + "' where lineNumber='" + form.getLineNumber() +
                             "'";
                con.executeUpdata(sql);
                con.closeConneciton();
                System.out.println("updateOneBook is successful");
                return true;
            }catch(Exception e){
                return false;
            }
        }

/*//**********************************************************/
   //查询出多少条纪录
   public int selectBooks(){
       List list = new ArrayList();
       BookForm bookForm=null;
       String sql=("select * from tb_book order by id");
       ResultSet rs=con.executeQuery(sql);
        try{
          bookForm=new BookForm();
          bookForm.setId(Integer.valueOf(rs.getString("id")));
          bookForm.setBookNumber(rs.getString("bookNumber"));
          bookForm.setLineNumber(rs.getString("lineNumber"));
          bookForm.setBookName(rs.getString("bookName"));
          bookForm.setAuthor(rs.getString("author"));
          bookForm.setPublish(rs.getString("publish"));
          bookForm.setPublishNumber(Integer.valueOf(rs.getString("publishNumber")));
          bookForm.setSortNumber(rs.getString("sortNumber"));
          bookForm.setInPirce(rs.getFloat("inPirce"));
          bookForm.setSinglePirce(rs.getFloat("singlePirce"));
          bookForm.setBookSum(rs.getInt("bookSum"));
          bookForm.setMan(rs.getString("man"));
          bookForm.setCreatime(rs.getString("creatime"));
          list.add(bookForm);
        }catch(Exception e){}
        int number=list.size();
        if (number % 13 == 0) {
            number = number / 13;
        } else {
            number = number / 13 + 1;
        }
       con.closeConneciton();
       return number;
   }

   //全部查询
   public List selectBooks(int number){
       List list = new ArrayList();
       BookForm bookForm=null;
       String sql=("select * from tb_book order by id");
       ResultSet rs=con.executeQuery(sql);
       try{
          while(rs.next()){
          bookForm=new BookForm();
          bookForm.setId(Integer.valueOf(rs.getString("id")));
          bookForm.setBookNumber(rs.getString("bookNumber"));
          bookForm.setLineNumber(rs.getString("lineNumber"));
          bookForm.setBookName(rs.getString("bookName"));
          bookForm.setAuthor(rs.getString("author"));
          bookForm.setPublish(rs.getString("publish"));
          bookForm.setPublishNumber(Integer.valueOf(rs.getString("publishNumber")));
          bookForm.setSortNumber(rs.getString("sortNumber"));
          bookForm.setInPirce(rs.getFloat("inPirce"));
          bookForm.setSinglePirce(rs.getFloat("singlePirce"));
          bookForm.setBookSum(rs.getInt("bookSum"));
          bookForm.setMan(rs.getString("man"));
          bookForm.setCreatime(rs.getString("creatime"));
          list.add(bookForm);
          }
          number=list.size();
          if (number*13 == 0) {
           number = number*13;
           } else {
           number = number*13 + 1;
           }
       }catch(Exception e){}
       con.closeConneciton();
       return list;
   }