spercontrol.java

管理系统

package com.aptech.cdjj.sex.action;

/**
 * <p>Title: 控制层</p>
 *
 * <p>Description: 接收用户输入的数据对数据库进行操作</p>
 *
 * <p>Copyright: SEX</p>
 *
 * <p>Company: 北大青鸟</p>
 *
 * @author 杨凯
 * @version 1.0
 *
 */

/** 导包*/
import java.sql.*;
import java.util.ArrayList;
import com.aptech.cdjj.sex.database.SDBManager;
import java.util.Vector;

public class SPerControl {
    //实例化一个 Statement 对象 s 为空
    Statement s = null;
    //实例化一个 ResultSet 对象 rs 为空
    ResultSet rs = null;
    //实例化一个 ArrayList 对象 arraylist
    ArrayList arraylist = new ArrayList();
    /**
     * 输入增加人员的信息
     * @param id String 编号
     * @param name String 姓名
     * @param time String 时间
     * @param sex String 性别
     * @param age String 年龄
     * @param natives String 籍贯
     * @param dept String 部门
     * @param duty String 职务
     * @param phone String 电话
     * @return ArrayList
     */
    public ArrayList cont(String id,String name,String sex,String age,String stat,String phone,String add,String duty,String time){
        SDBManager.ConnToDB();
        //向数据库增加新增人员数据信息对数据库进行操作
        String sql ="insert into person values('"+id+"','"+name+"','"+sex+"','"+age+"','"+stat+"','"+phone+"','"+add+"','"+duty+"','"+time+"')";
        SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return arraylist;
    }
    public ArrayList selectOne(String sql){
        SDBManager.ConnToDB();
        ResultSet rs = SDBManager.executeQuery(sql);
        ArrayList temp = new ArrayList();
        try {
            while (rs.next()) {

                temp.add(rs.getString(1));
            }
        } catch (SQLException ex) {
        }
        return temp;
    }

    /**
     * 输入修改人员的信息
     * @param id String 编号
     * @param name String 姓名
     * @param time String 入职时间
     * @param sex String 性别
     * @param age String 年龄
     * @param natives String 籍贯
     * @param dept String 部门
     * @param duty String 职务
     * @param phone String 电话
     * @return ArrayList
     */
    public ArrayList amend(String id,String name,String time,String sex,String age,String add,String phone,String stat,String duty){
        SDBManager.ConnToDB();
        //向数据库增加修改人员数据信息对数据库进行操作
        String sql="update person set pid='"+id+"',pname='"+name+"',psex='"+sex+"',page='"+age+"',pstep='"+duty+"',pphone='"+phone+"',paddress='"+add+"',pstate='"+stat+"',pdate='"+time+"' where pname='"+name+"'";
        SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return arraylist;
    }

    //输入编号以编号进行删除
    public int amend1(String id){
        SDBManager.ConnToDB();
        String sql = "delete  from  person where pid='"+id+"'";
        int str = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入姓名以姓名进行删除
    public int amend2(String name){
        SDBManager.ConnToDB();
        String sql = "delete from person where pname='"+name+"'";
        int str=  SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入性别以性别进行删除
    public int amend3(String sex){
        SDBManager.ConnToDB();
        String sql = "delete from person where psex='"+sex+"'";
        int str = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入年龄以年龄进行删除
    public int amend4(String age){
        SDBManager.ConnToDB();
        String sql = "delete from person where page='"+age+"'";
        int str = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入地址以地址进行删除
    public int amend5(String add){
        SDBManager.ConnToDB();
        String sql = "delete from person where paddress='"+add+"'";
        int str = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入职务以职务进行删除
    public int amend6(String stat){
        SDBManager.ConnToDB();
        String sql = "delete from person where pstep='"+stat+"'";
        int str = SDBManager.executeUpdate(sql);
        SDBManager.closeObj();
        return str;
    }
    //输入电话以电话进行删除
    public int amend7(String phone){
        SDBManager.ConnToDB();
        String sql = "delete from person where pphone = '"+phone+"'";
       int str = SDBManager.executeUpdate(sql);
       SDBManager.closeObj();
        return str;
    }
    //查询所有人员信息
    public Vector que() throws SQLException {
        SDBManager.ConnToDB();
        String sql = "select * from person order by pid";
        rs = SDBManager.executeQuery(sql);
        Vector vect = new Vector();
        while(rs.next()){
            Vector vec = new Vector();
            vec.add(rs.getString("pid"));
            vec.add(rs.getString("pname"));
            vec.add(rs.getString("psex"));
            vec.add(rs.getString("page"));
            vec.add(rs.getString("pstep"));
            vec.add(rs.getString("pphone"));
            vec.add(rs.getString("paddress"));
            vec.add(rs.getString("pstate"));
            vec.add(rs.getString("pdate"));
            vect.add(vec);
        }
        SDBManager.closeObj();
        return vect;
    }


    //以编号进行查询
    public Vector query1(String id) throws SQLException {
        SDBManager.ConnToDB();
        String sql = "select * from Person where pid='"+id+"'";
        rs = SDBManager.executeQuery(sql);
        Vector vect = new Vector();
        while(rs.next()){
            Vector vec = new Vector();
            vec.add(rs.getString("pid"));
            vec.add(rs.getString("pname"));
            vec.add(rs.getString("psex"));
            vec.add(rs.getString("page"));
            vec.add(rs.getString("pstep"));
            vec.add(rs.getString("pphone"));
            vec.add(rs.getString("paddress"));
            vec.add(rs.getString("pstate"));
            vec.add(rs.getString("pdate"));
            vect.add(vec);
        }
        SDBManager.closeObj();
       return vect;
    }

    //以姓名进行查询
    public Vector query2(String name) throws SQLException {
      SDBManager.ConnToDB();
      String sql = "select * from Person where pname='"+name+"'";
      rs = SDBManager.executeQuery(sql);
      Vector vect = new Vector();
      while(rs.next()){
          Vector vec = new Vector();
          vec.add(rs.getString("pid"));
          vec.add(rs.getString("pname"));
          vec.add(rs.getString("psex"));
          vec.add(rs.getString("page"));
          vec.add(rs.getString("pstep"));
          vec.add(rs.getString("pphone"));
          vec.add(rs.getString("paddress"));
          vec.add(rs.getString("pstate"));
          vec.add(rs.getString("pdate"));
          vect.add(vec);
      }
      SDBManager.closeObj();
     return vect;
  }
  //以性别进行查询
  public Vector query3(String sex) throws SQLException {
      SDBManager.ConnToDB();
      String sql = "select * from Person where psex='" + sex + "'";
      rs = SDBManager.executeQuery(sql);
      Vector vect = new Vector();
      while (rs.next()) {
          Vector vec = new Vector();
          vec.add(rs.getString("pid"));
          vec.add(rs.getString("pname"));
          vec.add(rs.getString("psex"));
          vec.add(rs.getString("page"));
          vec.add(rs.getString("pstep"));
          vec.add(rs.getString("pphone"));
          vec.add(rs.getString("paddress"));
          vec.add(rs.getString("pstate"));
          vec.add(rs.getString("pdate"));
          vect.add(vec);
      }
      SDBManager.closeObj();
      return vect;
  }

  //以年龄进行查询
  public Vector query4(String age) throws SQLException {
      SDBManager.ConnToDB();
      String sql = "select * from Person where page='" + age + "'";
      rs = SDBManager.executeQuery(sql);
      Vector vect = new Vector();
      while (rs.next()) {
          Vector vec = new Vector();
          vec.add(rs.getString("pid"));
          vec.add(rs.getString("pname"));
          vec.add(rs.getString("psex"));
          vec.add(rs.getString("page"));
          vec.add(rs.getString("pstep"));
          vec.add(rs.getString("pphone"));
          vec.add(rs.getString("paddress"));
          vec.add(rs.getString("pstate"));
          vec.add(rs.getString("pdate"));
          vect.add(vec);
      }
      SDBManager.closeObj();
      return vect;
  }

  //以地址进行查询
  public Vector query5(String add) throws SQLException {
      SDBManager.ConnToDB();
      String sql = "select * from Person where paddress='" + add + "'";
      rs = SDBManager.executeQuery(sql);
      Vector vect = new Vector();
      while (rs.next()) {
          Vector vec = new Vector();
          vec.add(rs.getString("pid"));
          vec.add(rs.getString("pname"));
          vec.add(rs.getString("psex"));
          vec.add(rs.getString("page"));
          vec.add(rs.getString("pstep"));
          vec.add(rs.getString("pphone"));
          vec.add(rs.getString("paddress"));
          vec.add(rs.getString("pstate"));
          vec.add(rs.getString("pdate"));
          vect.add(vec);
      }
      SDBManager.closeObj();
      return vect;
  }

  //以职务进行查询
  public Vector query6(String stat) throws SQLException {
    SDBManager.ConnToDB();
    String sql = "select * from Person where pstep='" + stat + "'";
    rs = SDBManager.executeQuery(sql);
    Vector vect = new Vector();
    while (rs.next()) {
        Vector vec = new Vector();
        vec.add(rs.getString("pid"));
        vec.add(rs.getString("pname"));
        vec.add(rs.getString("psex"));
        vec.add(rs.getString("page"));
        vec.add(rs.getString("pstep"));
        vec.add(rs.getString("pphone"));
        vec.add(rs.getString("paddress"));
        vec.add(rs.getString("pstate"));
        vec.add(rs.getString("pdate"));
        vect.add(vec);
    }
    SDBManager.closeObj();
    return vect;
  }

  //以电话进行查询
  public Vector query7(String phone) throws SQLException {
   SDBManager.ConnToDB();
   String sql = "select * from Person where pphone='" + phone + "'";
   rs = SDBManager.executeQuery(sql);
   Vector vect = new Vector();
   while (rs.next()) {
       Vector vec = new Vector();
       vec.add(rs.getString("pid"));
       vec.add(rs.getString("pname"));
       vec.add(rs.getString("psex"));
       vec.add(rs.getString("page"));
       vec.add(rs.getString("pstep"));
       vec.add(rs.getString("pphone"));
       vec.add(rs.getString("paddress"));
       vec.add(rs.getString("pstate"));
       vec.add(rs.getString("pdate"));
       vect.add(vec);
   }
   SDBManager.closeObj();
   return vect;
  }

}