studentbo.java~55~

考试管理系统：实现学生信息的注册、修改、查询、删除；以及对试题进行管理：增加试题、修改试题、删除试题、查询试题

/**
 * 考生信息业务对象 Examinee information business object
 */

package edu.sccp.examManager.business;

import java.sql.*;
import java.util.*;

import edu.sccp.examManager.VO.*;
import edu.sccp.examManager.database.*;
import edu.sccp.examManager.tools.*;

public class StudentBO {
    private boolean bl=false;
    private String status;
    public StudentBO() {
    }
    public String getStatus(){
        return status;
    }

    /**
     * 管理员登录
     * @param name String：用户名
     * @param password String：密码
     * @return boolean：登录成功/失败(true/false)
     */
    public boolean login(String name,String password){
    bl=false;
    if(name.equals("a")){
      if(password.equals("a")){
        bl=true;
      }else{
        status="密码错误！！！";
      }
    }else{
      status="用户不存在！！！";
    }
    return bl;
  }

  /**
   * 按照考号查询考生信息
   * @param pk String
   * @return ArrayList
   */
  public ArrayList findById(String pk){
   ArrayList list=null;
   ConnectBean cb=new ConnectBean();
   PreparedStatement ps=null;
   if(!cb.openConnection()){
     Tools.showDialog("数据库连接失败！");
     return null;
   }
   try {
     ps=cb.createPreparedStatement("select * from t_student where f_stuid=?",true);
     ps.setString(1,pk);
     cb.executeQuery();
     list=new ArrayList();
     String data = "考号***密码***姓名***班级***注册日期***备注";
     list.add(data);
     while(cb.next()){
       ExamineeVO stu = new ExamineeVO();
       stu.setId(cb.getString(1));
       stu.setPassword(cb.getString(2).trim());
       stu.setName(cb.getString(3).trim());
       stu.setClass(cb.getString(4).trim());
       stu.setDate(cb.getString(5));
       stu.setMemo(cb.getString(6).trim());
       list.add(stu);
     }
     if(cb.first()==false) Tools.showDialog("查无此人！");
   }
   catch (SQLException ex) {
     Tools.println(ex.getMessage());
   }
   return list;
   }

   /**
    * 按姓名查询考生信息
    * @param name String
    * @return ArrayList
    */
   public ArrayList findByName(String name){
       ArrayList list=null;
       ConnectBean cb=new ConnectBean();
       PreparedStatement ps=null;
       if(!cb.openConnection()){
           Tools.showDialog("数据库连接失败！");
           return null;
       }
       try {
           ps=cb.createPreparedStatement("select * from t_student where f_name=?",true);
           ps.setString(1,name);
           cb.executeQuery();
           list=new ArrayList();
           String data = "考号***密码***姓名***班级***注册日期***备注";
           list.add(data);
         while(cb.next()){
             ExamineeVO stu = new ExamineeVO();
             String id=cb.getString(1).trim();
             stu.setId(id);
             stu.setPassword(cb.getString(2).trim());
             stu.setName(cb.getString(3).trim());
             stu.setClass(cb.getString(4).trim());
             stu.setDate(cb.getString(5));
             stu.setMemo(cb.getString(6).trim());
             list.add(stu);
         }
       if(cb.first()==false) Tools.showDialog("查无此人！");
     }
    catch (SQLException ex) {
        Tools.println(ex.getMessage());
    }
    return list;
   }

   public ArrayList findByAll(){
    ArrayList list=null;
    ConnectBean cb=new ConnectBean();
    if(!cb.openConnection()){
      Tools.showDialog("数据库连接失败！");
      return null;
    }
    try {
      cb.createPreparedStatement("select * from t_student");
      cb.executeQuery();
      list=new ArrayList();
      String data = "考号***密码***姓名***班级***注册日期***备注";
      list.add(data);
      while(cb.next()){
         ExamineeVO stu = new ExamineeVO();
         stu.setId(cb.getString(1));
         stu.setPassword(cb.getString(2).trim());
         stu.setName(cb.getString(3).trim());
         stu.setClass(cb.getString(4).trim());
         stu.setDate(cb.getString(5));
         stu.setMemo(cb.getString(6).trim());
         list.add(stu);
      }
    }
    catch (SQLException ex) {
      Tools.println(ex.getMessage());
    }
    return list;
  }


   public boolean addExaminee(ExamineeVO stu){
    ConnectBean cb=new ConnectBean();
    PreparedStatement ps=null;
    bl=false;
    try {
    if(!cb.openConnection()){
     Tools.showDialog("数据库连接失败！");
     return false;
    }
      ps=cb.createPreparedStatement("insert into t_student values(?,?,?,?,?,?)");//see material in API:java.sql  Interface PreparedStatement
      ps.setString(1,stu.getId());
      ps.setString(2,stu.getPassword());
      ps.setString(3,stu.getName());
      ps.setString(4,stu.getSclass());
      ps.setString(5,stu.getDate());
      ps.setString(6,stu.getMemo());
      ps.executeUpdate();
      bl=true;//insert transaction succeeded!!
    } catch (SQLException ex) {
      Tools.println(ex.getMessage());
      return bl;//insert failure!!
    }
    catch (Exception ex) {
      Tools.println(ex.getMessage());
      return bl;
    }

    finally{
      try {
        ps.close();//It is generally good practice to release resources as soon as you are finished with
        cb.close(); //them to avoid tying up(means:occupy) database resources.
        return bl;
      }
      catch (SQLException ex1) {
        Tools.println(ex1.getMessage());
        return bl;
      }
    }
  }

  public boolean editExaminee(ExamineeVO stu){//update method to be added!!!
      ConnectBean cb=new ConnectBean();
      PreparedStatement ps=null;
      if(!cb.openConnection()){
          Tools.showDialog("数据库连接失败！");
      }
      try {
          ps = cb.createPreparedStatement("update t_student set f_password=?,f_name=?,f_class=?,f_date=?,f_memo=? where f_stuid=?", true);
          ps.setString(1,stu.getPassword());
          ps.setString(2,stu.getName());
          ps.setString(3,stu.getSclass());
          ps.setString(4,stu.getDate());
          ps.setString(5,stu.getMemo());
          ps.setString(6,stu.getId());
          ps.executeUpdate();
          bl= true;
      }catch (SQLException ex1) {
          Tools.println(ex1.getMessage());
          bl=false;
      }
    return bl;
  }


  public boolean deleteExaminee(String pk){
    ConnectBean cb=new ConnectBean();
    PreparedStatement ps=null;
    if(!cb.openConnection()){
     Tools.showDialog("数据库连接失败！");
     return false;
    }
    try {
      ps = cb.createPreparedStatement("delete from t_student where f_stuid=?", true);
      ps.setString(1, pk);
      ps.executeUpdate();
      bl=true;
    }catch (SQLException ex1) {
        Tools.showDialog("发生异常,即将退出......");
        Tools.println(ex1.getMessage());
        bl=false;
      }
      return bl;
  }
}