readers.java~3~

图书管理系统,B/S,C/S都有,附有源代码

package reader;

import java.sql.*;
import java.util.Vector;
import database.*;
import book.bookInfo;
import javax.servlet.http.HttpServletRequest;

/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class Readers {

  private Vector readerList; //图书列表
  private javax.servlet.http.HttpServletRequest request; //建立页面请求

  public Vector getReaderList() {
    return readerList;
  }

  public String createReaderSN() throws
      Exception {

    DataBase db = new DataBase();

    String newReaderSN = "0000000";
    int intReaderSN;
    try {
      //从数据库中取出最大的编号
      ResultSet rs = db.executeQuery("select max(读者编号) as 读者编号 from Book");
      rs.next();
      newReaderSN = rs.getString(1);
      //转换为INT格式以便增加
      intReaderSN = Integer.parseInt(newReaderSN);
      rs.close();
      //编号是否大于9999999
      if (intReaderSN < 9999999) {
        //编号+1
        intReaderSN++;
        //转换为字符串
        newReaderSN = Integer.toString(intReaderSN);
        //字符串不满7位前面填充0
        while (newReaderSN.length() < 7) {
          newReaderSN = "0" + newReaderSN;
        }
      }
      else {
        //编号大于9999999
        newReaderSN = "0000000";
      }
      return newReaderSN;
    }
    catch (SQLException e) {
      System.out.println(e);
      newReaderSN = "0000000";
    }
    return newReaderSN;
  }

  public boolean getAllReader() throws Exception {
    DataBase db = new DataBase();
    try {
      ResultSet rs = db.executeQuery("select * from Reader");
      readerList = new Vector();
      while (rs.next()) {
        readerInfo readerinfo = new readerInfo();
        readerinfo.setReaderSN(rs.getString(1));
        readerinfo.setReaderName(rs.getString(2));
        readerinfo.setReaderSex(rs.getString(3));
        readerinfo.setReaderWP(rs.getString(4));
        readerinfo.setReaderLocked(rs.getString(5));
        readerinfo.setReaderLevel(rs.getString(6));
        readerinfo.setReaderCT(rs.getString(7));
        readerinfo.setReaderAvail(rs.getString(8));
        readerinfo.setReaderPhone(rs.getString(9));
        readerinfo.setReaderComment(rs.getString(10));
        readerList.addElement(readerinfo);
      }
      rs.close();
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }
  }

  public boolean getOneReader(String newReaderSN) throws Exception {
    DataBase db = new DataBase();
    try {
      ResultSet rs = db.executeQuery("select * from Reader where 读者编号 = '" +
                                     db.toSql(newReaderSN) +
                                     "'"
                                     );

      if (rs.next()) {
        readerList = new Vector();
        readerInfo readerinfo = new readerInfo();
        readerinfo.setReaderSN(rs.getString(1));
        readerinfo.setReaderName(rs.getString(2));
        readerinfo.setReaderSex(rs.getString(3));
        readerinfo.setReaderWP(rs.getString(4));
        readerinfo.setReaderLocked(rs.getString(5));
        readerinfo.setReaderLevel(rs.getString(6));
        readerinfo.setReaderCT(rs.getString(7));
        readerinfo.setReaderAvail(rs.getString(8));
        readerinfo.setReaderPhone(rs.getString(9));
        readerinfo.setReaderComment(rs.getString(10));
        readerList.addElement(readerinfo);
      }
      else {
        rs.close();
        return false;
      }
      rs.close();
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }

  }

  public boolean searchReader(HttpServletRequest res) throws
      Exception {

    request = res;

    DataBase db = new DataBase();

    String readerSN = db.toSql(request.getParameter("readerSN"));
    String readerName = db.toSql(request.getParameter("readerName"));
    String readerSex = db.toSql(request.getParameter("readerSex"));
    String readerWP = db.toSql(request.getParameter("readerWP"));
    String readerLocked = db.toSql(request.getParameter("readerLocked"));
    String readerLevel = db.toSql(request.getParameter("readerLevel"));
    String readerCT = db.toSql(request.getParameter("readerCT"));
    String readerAvail = db.toSql(request.getParameter("readerAvail"));
    String readerPhone = db.toSql(request.getParameter("readerPhone"));
    String readerComment = db.toSql(request.getParameter("readerComment"));

    String searchSql = "select * from Reader where 读者编号 like '%" + readerSN +
        "%'";

    if (!readerName.equals("")) {
      searchSql = searchSql + " and 读者姓名 like '%" + readerName + "%'";
    }
    if (!readerSex.equals("")) {
      searchSql = searchSql + " and 性别 like '%" + readerSex + "%'";
    }
    if (!readerWP.equals("")) {
      searchSql = searchSql + " and 单位 like '%" + readerWP + "%'";
    }

    if (!readerLocked.equals("")) {
      searchSql = searchSql + " and 是否锁定 like '%" + readerLocked + "%'";
    }

    if (!readerLevel.equals("")) {
      searchSql = searchSql + " and 借阅权限 like '%" + readerLevel + "%'";
    }

    if (!readerCT.equals("")) {
      searchSql = searchSql + " and 创建时间 like '%" + readerCT + "%'";
    }

    if (!readerAvail.equals("")) {
      searchSql = searchSql + " and 有效期限 like '%" + readerAvail + "%'";
    }

    if (!readerPhone.equals("")) {
      searchSql = searchSql + " and 联系电话 like '%" + readerPhone + "%'";
    }

    if (!readerComment.equals("")) {
      searchSql = searchSql + " and 备注 like '%" + readerComment + "%'";
    }

    try {
      ResultSet rs = db.executeQuery(searchSql);
      readerList = new Vector();
      while (rs.next()) {
        readerList = new Vector();
        readerInfo readerinfo = new readerInfo();
        readerinfo.setReaderSN(rs.getString(1));
        readerinfo.setReaderName(rs.getString(2));
        readerinfo.setReaderSex(rs.getString(3));
        readerinfo.setReaderWP(rs.getString(4));
        readerinfo.setReaderLocked(rs.getString(5));
        readerinfo.setReaderLevel(rs.getString(6));
        readerinfo.setReaderCT(rs.getString(7));
        readerinfo.setReaderAvail(rs.getString(8));
        readerinfo.setReaderPhone(rs.getString(9));
        readerinfo.setReaderComment(rs.getString(10));
        readerList.addElement(readerinfo);
      }
      rs.close();
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }
  }

  public boolean addReader(HttpServletRequest res) throws
      Exception {

    //产生新的图书编号
    String readerSN = createReaderSN();
    if (readerSN.equals("0000000")) {
      return false;
    }

    request = res;

    DataBase db = new DataBase();

    //获取页面请求
    String readerName = db.toSql(request.getParameter("readerName"));
    String readerSex = db.toSql(request.getParameter("readerSex"));
    String readerWP = db.toSql(request.getParameter("readerWP"));
    String readerLocked = db.toSql(request.getParameter("readerLocked"));
    String readerLevel = db.toSql(request.getParameter("readerLevel"));
    String readerCT = db.toSql(request.getParameter("readerCT"));
    String readerAvail = db.toSql(request.getParameter("readerAvail"));
    String readerPhone = db.toSql(request.getParameter("readerPhone"));
    String readerComment = db.toSql(request.getParameter("readerComment"));

    //添加图书信息
    String insertSql = "insert into Book values('" + readerSN + "','" +
        readerName +
        "','" + readerSex + "','" + readerWP + "','" + readerLocked + "','" +
        readerLevel +
        "','" + readerCT + "','" + readerAvail + "','" + readerPhone + "','" +
        readerComment +
        "')";

    try {
      db.executeUpdate(insertSql);
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }

  }

  public boolean delReader(String newReaderSN) throws
      Exception {

    DataBase db = new DataBase();

    String readerSN = db.toSql(newReaderSN);

    //删除图书
    String delSql = "delete from Reader where 读者编号 = '" + readerSN + "'";

    try {
      db.executeUpdate(delSql);
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }

  }

  public boolean updateReader(HttpServletRequest res) throws
      Exception {

    request = res;

    DataBase db = new DataBase();

    //获取页面请求信息
    String readerSN = db.toSql(request.getParameter("readerSN"));
    String readerName = db.toSql(request.getParameter("readerName"));
    String readerSex = db.toSql(request.getParameter("readerSex"));
    String readerWP = db.toSql(request.getParameter("readerWP"));
    String readerLocked = db.toSql(request.getParameter("readerLocked"));
    String readerLevel = db.toSql(request.getParameter("readerLevel"));
    String readerCT = db.toSql(request.getParameter("readerCT"));
    String readerAvail = db.toSql(request.getParameter("readerAvail"));
    String readerPhone = db.toSql(request.getParameter("readerPhone"));
    String readerComment = db.toSql(request.getParameter("readerComment"));

    //更新图书信息
    String updateSql = "update Reader set 读者姓名 = '" + readerName + "', 性别 = '" +
        readerSex + "', 单位 = '" + readerWP + "', 是否锁定 = '" + readerLocked +
        "', 借阅权限 = '" + readerLevel + "', 创建时间 = '" + readerCT + "', 有效期限 = '" +
        readerAvail + "', 联系电话 = '" + readerPhone + "', 备注 = '" + readerComment +
        "' where 读书编号 = '" + readerSN + "'";

    try {
      db.executeUpdate(updateSql);
      return true;
    }
    catch (SQLException e) {
      System.out.println(e);
      return false;
    }

  }

}