personbean.java

oa源码哈

package edu.scfc;

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

public class PersonBean {

    private String realName;
    private String sex;
    private String dept;
    private String business;
    private String email;
    private String bodyCard;
    private String loginAccounts;
    private String loginPassword;
    Connection con = null;
    PreparedStatement pstmt = null;
    Statement stmt = null;
    ResultSet rs = null;
    ConnDB objConnDB = new ConnDB();

    public PersonBean() {
    }

    public void setRealName(String realname){
        this.realName=realname;
    }

    public String getRealName(){
        return this.realName;
    }

    public void setSex(String sex){
        this.sex=sex;
    }

    public String getSex(){
        return this.sex;
    }

    public void setDept(String dept){
        this.dept=dept;
    }

    public String getDept(){
        return this.dept;
    }

    public void setBusiness(String business){
        this.business=business;
    }

    public String getBusiness(){
        return this.business;
    }

    public void setEmail(String email){
        this.email=email;
    }

    public String getEmail(){
        return this.email;
    }

    public void setBodyCard(String bodycard){
        this.bodyCard=bodycard;
    }

    public String getBodyCard(){
        return this.bodyCard;
    }

    public void setLoginAccounts(String loginaccounts){
        this.loginAccounts=loginaccounts;
    }

    public String getLoginAccounts(){
        return this.loginAccounts;
    }
    public void setLoginPassword(String loginpassword){
        this.loginPassword=loginpassword;
    }

    public String getLoginPassword(){
        return this.loginPassword;
    }

    public Vector SelectAllPersonnel(){
        try{
            Vector vc = new Vector();
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select * from TB_Personnel");
            rs = pstmt.executeQuery();
            while(rs.next()){
                PersonBean objPersonBean = new PersonBean();
                objPersonBean.setRealName(rs.getString("RealName"));
                vc.addElement(objPersonBean);
            }
            return vc;
        }catch(SQLException ex){}
        return null;
    }

    public ResultSet selectUser(String loginName,String loginPassword){
        try {
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("select RealName,Sex,Dept,Business from TB_Personnel where LoginAccounts = ? and LoginPassword = ?");
            pstmt.setString(1,loginName);
            pstmt.setString(2,loginPassword);
            rs = pstmt.executeQuery();
        } catch (SQLException ex1) {
        }
        return rs;
    }

    public void insertPerson(){
        try{
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("insert into TB_Personnel(RealName,Sex,Dept,Business,Email,BodyCard,LoginAccounts,LoginPassword) values (?,?,?,?,?,?,?,?)");
            pstmt.setString(1,this.getRealName());
            pstmt.setString(2,this.getSex());
            pstmt.setString(3,this.getDept());
            pstmt.setString(4,this.getBusiness());
            pstmt.setString(5,this.getEmail());
            pstmt.setString(6,this.getBodyCard());
            pstmt.setString(7,this.getLoginAccounts());
            pstmt.setString(8,this.getLoginPassword());
            pstmt.executeQuery();
        }catch(SQLException ex){}
    }
}