userbean.java~30~

基于b/s模式的jsp在线考试系统

package com.gton.bean;

import java.sql.*;
import java.util.ArrayList;
import com.gton.util.DBUtil;

public class UserBean {
    private int users_ID;
    private String users_Name;
    private String users_Pwd;
    private int users_Age;
    private int users_Sex;
    private String users_No;
    private String users_Agent;
    private String users_Mz;
    public UserBean() {
    }

    public void setUsers_ID(int users_ID) {
        this.users_ID = users_ID;
    }

    public void setUsers_Name(String users_Name) {
        this.users_Name = users_Name;
    }

    public void setUsers_Pwd(String users_Pwd) {
        this.users_Pwd = users_Pwd;
    }

    public void setUsers_Age(int users_Age) {
        this.users_Age = users_Age;
    }

    public void setUsers_Agent(String users_Agent) {
        this.users_Agent = users_Agent;
    }

    public void setUsers_Mz(String users_Mz) {
        this.users_Mz = users_Mz;
    }

    public void setUsers_No(String users_No) {
        this.users_No = users_No;
    }

    public void setUsers_Sex(int users_Sex) {
        this.users_Sex = users_Sex;
    }

    public int getUsers_ID() {
        return users_ID;
    }

    public String getUsers_Name() {
        return users_Name;
    }

    public String getUsers_Pwd() {
        return users_Pwd;
    }

    public int getUsers_Age() {
        return users_Age;
    }

    public String getUsers_Mz() {
        return users_Mz;
    }

    public String getUsers_Agent() {
        return users_Agent;
    }

    public String getUsers_No() {
        return users_No;
    }

    public int getUsers_Sex() {
        return users_Sex;
    }

    public ArrayList getAllStu() {
        ArrayList list = null;
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        UserBean bean = null;

        try {
            con = DBUtil.getConnection();
            String sql = "select * from Users";
            pstmt = con.prepareStatement(sql);
            rs = pstmt.executeQuery();
            list = new ArrayList();
            while (rs.next()) {
                bean = new UserBean();
                bean.setUsers_Age(rs.getInt("Users_Age"));
                bean.setUsers_Agent(rs.getString("Users_Agent"));
                bean.setUsers_ID(rs.getInt("Users_ID"));
                bean.setUsers_Mz(rs.getString("Users_Mz"));
                bean.setUsers_Name(rs.getString("Users_Name"));
                bean.setUsers_No(rs.getString("Users_No"));
                bean.setUsers_Pwd(rs.getString("Users_Pwd"));
                bean.setUsers_Sex(rs.getInt("Users_Sex"));
                list.add(bean);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBUtil.closeConnection(rs, pstmt, con);
        }

        return list;
    }

    public boolean deleteById(int id) {
        Connection con = null;
        PreparedStatement pstmt = null;
        boolean flag = false;
        int rowCount = 0;

        try {
            con = DBUtil.getConnection();
            String sql = "delete from Users where Users_ID=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setInt(1, id);
            rowCount = pstmt.executeUpdate();
            if (rowCount > 0) {
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBUtil.closeConnection(null, pstmt, con);
        }

        return flag;
    }

    public static UserBean queryById(int id) {
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        UserBean bean = null;

        try {
            con = DBUtil.getConnection();
            String sql = "select * from Users where Users_ID=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setInt(1, id);
            rs = pstmt.executeQuery();
            if (rs.next()) {
                bean = new UserBean();
                bean.setUsers_Age(rs.getInt("Users_Age"));
                bean.setUsers_Agent(rs.getString("Users_Agent"));
                bean.setUsers_ID(rs.getInt("Users_ID"));
                bean.setUsers_Mz(rs.getString("Users_Mz"));
                bean.setUsers_Name(rs.getString("Users_Name"));
                bean.setUsers_No(rs.getString("Users_No"));
                bean.setUsers_Pwd(rs.getString("Users_Pwd"));
                bean.setUsers_Sex(rs.getInt("Users_Sex"));
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBUtil.closeConnection(rs, pstmt, con);
        }

        return bean;
    }

    public static boolean modify(String name, String pwd, int age,
                                 String agent, String mz, String no, int sex) {
        boolean flag = false;
        Connection con = null;
        PreparedStatement pstmt = null;
        int rowCount = 0;

        try {
            con = DBUtil.getConnection();
            String sql = "update Users set Users_Pwd=?,Users_Age=?,Users_Sex=?,Users_No=?,Users_Agent=?,Users_Mz=? where Users_Name=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setString(1, pwd);
            pstmt.setInt(2, age);
            pstmt.setInt(3, sex);
            pstmt.setString(4, no);
            pstmt.setString(5, agent);
            pstmt.setString(6, mz);
            pstmt.setString(7, name);
            rowCount = pstmt.executeUpdate();
            if (rowCount > 0) {
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            DBUtil.closeConnection(null, pstmt, con);
        }
        return flag;
    }
}