adminbean.java~10~

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

package com.gton.bean;

import java.sql.*;
import com.gton.util.DBUtil;
/**
 * <p>Title: AdminBean管理员类</p>
 */
public class AdminBean {
    private int admin_ID;
    private String admin_Name;
    private String admin_Pwd;
    public AdminBean() {
    }

    public void setAdmin_ID(int admin_ID) {
        this.admin_ID = admin_ID;
    }

    public void setAdmin_Name(String admin_Name) {
        this.admin_Name = admin_Name;
    }

    public void setAdmin_Pwd(String admin_Pwd) {
        this.admin_Pwd = admin_Pwd;
    }

    public int getAdmin_ID() {
        return admin_ID;
    }

    public String getAdmin_Name() {
        return admin_Name;
    }

    public String getAdmin_Pwd() {
        return admin_Pwd;
    }

    public static AdminBean getByName(String name){
        Connection con = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        AdminBean bean = null;

        try{
            con = DBUtil.getConnection();
            String sql = "select * from Admin where Admin_Name=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setString(1, name);
            rs = pstmt.executeQuery();
            if(rs.next()){
                bean = new AdminBean();

            }
        }catch(Exception ex){

        }finally{

        }

        return bean;
    }
}