readerdao.java

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

package com.dao;

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

public class ReaderDao {
    private JDBCConnection con=null;

    public ReaderDao() {
     con=new JDBCConnection();
     this.con.createConnection();
    }


    /****************增加读者************************************/
      public boolean insertReader(ReaderForm bookForm) {
      try{
          System.out.println("开始增加读者````````````");
          String sql = "insert into tb_reader values('"+bookForm.getBookCardMark()
                       +"','"+bookForm.getName()+"','"+bookForm.getSex()+"','"+bookForm.getIDCard()
                       +"','"+bookForm.getWorkUnit()+"','"+bookForm.getAddress()+"','"+bookForm.getTel()
                       +"','"+bookForm.getBorrowBookNumber()+"','"+bookForm.getRealerType()
                       +"','"+bookForm.getCardPrice()+"','"+bookForm.getStartTime()+"','"
                       +bookForm.getOverTime()+"')";
          System.out.println("cccccccccccccccccc");
          con.executeQuery(sql);
          System.out.println("增加读者信息成功！！！");
          con.closeConneciton();
          return true;
       }catch(Exception e){
      System.out.println("增加读者信息失败！！！");
      return true;
       }
     }


/*******************************删除***************************************/
   public boolean delectReader(ReaderForm bookForm) {
       String bookCardMark=bookForm.getBookCardMark();
   try{
       String sql ="delete from tb_reader where bookCardMark='"+bookCardMark+"'";
       con.executeQuery(sql);
       System.out.println("删除读者信息成功！！！");
       con.closeConneciton();
       return true;
     }catch(Exception e){
       System.out.println("删除读者信息失败！！！");
       return false;
     }
   }

/**********************************修改************************************/
   public void UpdateReader(ReaderForm bookForm){
         try{
             String sql = "update tb_reader set name='" +bookForm.getName()
                          + "',sex='" +bookForm.getSex() + "',IDCard='"
                          +bookForm.getIDCard() + "',workUnit='" +bookForm.getWorkUnit()
                          + "',address='" +bookForm.getAddress() + "',tel='"
                          +bookForm.getTel() + "',borrowBookNumber='" +bookForm.getBorrowBookNumber()
                          + "',realerType='" +bookForm.getRealerType() + "',cardPrice='"
                          +bookForm.getCardPrice() + "',startTime='" +bookForm.getStartTime()
                          + "', overTime='"+bookForm.getOverTime()+"' where  bookCardMark='" +bookForm.getBookCardMark() + "'";
             con.executeUpdata(sql);
             System.out.println("修改读者信息成功！！！");
             con.closeConneciton();
         }catch(Exception e){
         System.out.println("修改读者信息失败！！！");
         }
   }
//***********************************************************************////
   //自动编号的方法
   public String selectMaxIdReader() {
       List list=new ArrayList();
       String reader = null;
       ReaderForm reForm = null;
       String sql="select * from tb_reader where id=(select Max(id) from tb_reader)";
       ResultSet rs=con.executeQuery(sql);
       try{
           while(rs.next()){
               reForm = new ReaderForm();
               reForm.setId(rs.getInt("id"));
               reForm.setBookCardMark(rs.getString("bookCardMark"));
               reForm.setName(rs.getString("name"));
               reForm.setSex(rs.getString("sex"));
               reForm.setIDCard(rs.getString("IDCard"));
               reForm.setWorkUnit(rs.getString("workUnit"));
               reForm.setAddress(rs.getString("address"));
               reForm.setTel(rs.getString("tel"));
               reForm.setBorrowBookNumber(rs.getInt("borrowBookNumber"));
               reForm.setRealerType(rs.getString("realerType"));
               reForm.setCardPrice(rs.getFloat("cardPrice"));
               reForm.setStartTime(rs.getString("startTime"));
               reForm.setOverTime(rs.getString("overTime"));
               list.add(reForm);
           }
       }catch(Exception e){}
       if (reForm != null) {
       reader = reForm.getBookCardMark();
      }
       reader = DealwithString.maxNumberString(reader, "R-", 2);
       return reader;
   }

   //********************************查询**********************************//
   //以读者编号为条件查询读者全部信息
   public ReaderForm selectReaderbook(ReaderForm reForm1) {
       System.out.println("读者..........");
    String sql="select * from tb_reader where bookCardMark='"+reForm1.getBookCardMark()+"'";
    ReaderForm reForm=null;
    ResultSet rs = con.executeQuery(sql);
      try {
         while(rs.next()){
         reForm=new ReaderForm();
         reForm.setId(rs.getInt("id"));
         reForm.setBookCardMark(rs.getString("bookCardMark"));
         reForm.setName(rs.getString("name"));
         reForm.setSex(rs.getString("sex"));
         reForm.setIDCard(rs.getString("IDCard"));
         reForm.setWorkUnit(rs.getString("workUnit"));
         reForm.setAddress(rs.getString("address"));
         reForm.setTel(rs.getString("tel"));
         reForm.setBorrowBookNumber(rs.getInt("borrowBookNumber"));
         reForm.setRealerType(rs.getString("realerType"));
         reForm.setCardPrice(rs.getFloat("cardPrice"));
         reForm.setStartTime(rs.getString("startTime"));
         reForm.setOverTime(rs.getString("overTime"));
         }
      } catch (Exception ex) {}
      con.closeConneciton();
      return reForm;
  }

  //全部查询
 public List selectReader() {
     System.out.println("查询读者11..........");
     List list=new ArrayList();
     ReaderForm readerForm=null;
     String sql="select * from tb_reader order by id";
     ResultSet rs = con.executeQuery(sql);
    try {
       while(rs.next()){
       readerForm=new ReaderForm();
       readerForm.setId(rs.getInt("id"));
       readerForm.setBookCardMark(rs.getString("bookCardMark"));
       readerForm.setName(rs.getString("name"));
       readerForm.setSex(rs.getString("sex"));
       readerForm.setIDCard(rs.getString("IDCard"));
       readerForm.setWorkUnit(rs.getString("workUnit"));
       readerForm.setAddress(rs.getString("address"));
       readerForm.setTel(rs.getString("tel"));
       readerForm.setBorrowBookNumber(rs.getInt("borrowBookNumber"));
       readerForm.setRealerType(rs.getString("realerType"));
       readerForm.setCardPrice(rs.getFloat("cardPrice"));
       readerForm.setStartTime(rs.getString("startTime"));
       readerForm.setOverTime(rs.getString("overTime"));
       list.add(readerForm);
       }
    } catch (Exception ex) {
    System.out.println("出错误11111");
    }
    con.closeConneciton();
    return list;
}

//以读者类型为条件查询读者全部信息
  public ReaderForm selectReaderbooks(ReaderForm reForm1) {
      System.out.println("读者..........");
   String sql="select * from tb_reader where realerType='"+reForm1.getRealerType()+"'";
   ReaderForm reForm=null;
   ResultSet rs = con.executeQuery(sql);
     try {
        while(rs.next()){
        reForm=new ReaderForm();
        reForm.setId(rs.getInt("id"));
        reForm.setBookCardMark(rs.getString("bookCardMark"));
        reForm.setName(rs.getString("name"));
        reForm.setSex(rs.getString("sex"));
        reForm.setIDCard(rs.getString("IDCard"));
        reForm.setWorkUnit(rs.getString("workUnit"));
        reForm.setAddress(rs.getString("address"));
        reForm.setTel(rs.getString("tel"));
        reForm.setBorrowBookNumber(rs.getInt("borrowBookNumber"));
        reForm.setRealerType(rs.getString("realerType"));
        reForm.setCardPrice(rs.getFloat("cardPrice"));
        reForm.setStartTime(rs.getString("startTime"));
        reForm.setOverTime(rs.getString("overTime"));
        }
     } catch (Exception ex) {}
     con.closeConneciton();
     return reForm;
  }

//查询出多少条纪录
  public int selectReader(int number){
      List list = new ArrayList();
      ReaderForm readerForm=null;
      String sql=("select * from tb_reader order by id");
      ResultSet rs=con.executeQuery(sql);
       try{
           while(rs.next()){
               readerForm = new ReaderForm();
               readerForm.setId(rs.getInt("id"));
               readerForm.setBookCardMark(rs.getString("bookCardMark"));
               readerForm.setName(rs.getString("name"));
               readerForm.setSex(rs.getString("sex"));
               readerForm.setIDCard(rs.getString("IDCard"));
               readerForm.setWorkUnit(rs.getString("workUnit"));
               readerForm.setAddress(rs.getString("address"));
               readerForm.setTel(rs.getString("tel"));
               readerForm.setBorrowBookNumber(rs.getInt("borrowBookNumber"));
               readerForm.setRealerType(rs.getString("realerType"));
               readerForm.setCardPrice(rs.getFloat("cardPrice"));
               readerForm.setStartTime(rs.getString("startTime"));
               readerForm.setOverTime(rs.getString("overTime"));
               list.add(readerForm);
           }
       }catch(Exception e){}
       number=list.size();
       if (number % 13 == 0) {
           number = number / 13;
       } else {
           number = number / 13 + 1;
       }
      con.closeConneciton();
      return number;
   }



}