databean.java~76~

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

    public boolean deleteTest(int test_ID) {
        try {
            prepar = conn.prepareStatement(
                    "delete from Test where Test_ID=?");
            prepar.setInt(1, test_ID);
            int flag = prepar.executeUpdate();
            if (flag == 0) {
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
        return true;
    }

    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Admin获取用户列表方法/////////////////////////////////////////////////
    public ArrayList getUsersList(int page, int count) {
        ArrayList list = new ArrayList();
        try {
            proc = conn.prepareCall("{call proc_users_page (?,?,?)}");
            proc.setInt(1, page);
            proc.setInt(2, count);
            proc.registerOutParameter(3, Types.INTEGER);
            res = proc.executeQuery();
            while (res.next()) {
                UserBean ub = new UserBean();
                ub.setUsers_ID(res.getInt("Users_ID"));
                ub.setUsers_Name(res.getString("Users_Name"));
                ub.setUsers_Pwd(res.getString("Users_Pwd"));
                ub.setUsers_Age(res.getInt("Users_Age"));
                ub.setUsers_Agent(res.getString("Users_Agent"));
                ub.setUsers_Mz(res.getString("Users_Mz"));
                ub.setUsers_No(res.getString("Users_NO"));
                list.add(ub);
            }
            pagecount = proc.getInt(3);
        } catch (SQLException ex) {
            System.out.println("服务器异常发生在 getUsersList()");
            ex.printStackTrace();
        }
        return list;
    }

    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Admin删除用户方法/////////////////////////////////////////////////
    public boolean deleteUseers(int users_ID) {
        try {
            prepar = conn.prepareStatement(
                    "delete from Users where Users_ID=?");
            prepar.setInt(1, users_ID);
            int flag = prepar.executeUpdate();
            if (flag == 0) {
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
        return true;
    }


    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User登陆方法/////////////////////////////////////////////////
    public boolean checkUserLogin(UserBean ub) { // 验证登陆

        boolean result = false;
        if (!MyString.checkParameter(ub.getUsers_Name()
                                     + ub.getUsers_Pwd())) {
            return result;
        }
        try {
            String sql =
                    "select count(*) from Users where Users_Name=? and Users_Pwd=?";
            prepar = conn.prepareStatement(sql);
            prepar.setString(1, ub.getUsers_Name());
            prepar.setString(2, ub.getUsers_Pwd());
            res = prepar.executeQuery();
            if (res.next()) {
                if (res.getInt(1) > 0) {
                    result = true;
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    public UserBean getUserBean(UserBean ub) { // 获取UserBean持久化
        UserBean user = null;
        try {
            String sql =
                    "select * from Users where Users_Name=? and Users_Pwd=?";
            prepar = conn.prepareStatement(sql);
            prepar.setString(1, ub.getUsers_Name());
            prepar.setString(2, ub.getUsers_Pwd());
            res = prepar.executeQuery();
            if (res.next()) {
                user = new UserBean();
                user.setUsers_ID(res.getInt("Users_ID"));
                user.setUsers_Name(res.getString("Users_Name"));
                user.setUsers_Pwd(res.getString("Users_Pwd"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return user;
    }

    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User注册方法/////////////////////////////////////////////////
    public boolean regUser(UserBean ub) {
        try {
            prepar = conn.prepareStatement(
                    "insert into Users (Users_Name,Users_Pwd) values(?,?)");
            prepar.setString(1, ub.getUsers_Name());
            prepar.setString(2, ub.getUsers_Pwd());
            int flag = prepar.executeUpdate();
            if (flag == 0) {
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
        return true;

    }

    public boolean isHasName(String userName) {
        try {
            prepar = conn.prepareStatement(
                    "select count(*) from Users where Users_Name=?");
            prepar.setString(1, userName);
            res = prepar.executeQuery();
            res.next();
            if (res.getInt(1) != 0) {
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
        return true;

    }

    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User取考题方法/////////////////////////////////////////////////
    public String selectTests() {
        try {
            prepar = conn.prepareStatement(
                    "select top 1 * from Tests order by NEWID()");
            res = prepar.executeQuery();
            res.next();
            System.out.println("111111111111111111111111");
            System.out.println(res.getString("Tests_Time"));
            System.out.println("2222222222222222222222222");
            return res.getString("Tests_Time");
        } catch (SQLException ex) {
            ex.printStackTrace();
            return "";
        }
    }

    /////////////////////////////////////////////////////////////////////////////////////////////
    ////////////////////////////////按学生姓名查询学生/////////////////////////////////////////////
    public ArrayList getUserInfoByName(String name) {
        ArrayList list = null;
        UserBean user = null;
        try {
            String sql = "select * from users where Users_Name=?";
            prepar = conn.prepareStatement(sql);
            prepar.setString(1, name);
            res = prepar.executeQuery();
            list = new ArrayList();
            while (res.next()) {
                user = new UserBean();
                user.setUsers_ID(res.getInt("Users_ID"));
                user.setUsers_Name(res.getString("Users_Name"));
                user.setUsers_Pwd(res.getString("Users_Pwd"));
                user.setUsers_Age(res.getInt("Users_Age"));
                user.setUsers_Agent(res.getString("Users_Agent"));
                user.setUsers_Mz(res.getString("Users_Mz"));
                user.setUsers_No(res.getString("Users_No"));
                user.setUsers_Sex(res.getInt("Users_Sex"));
                list.add(user);
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            Close();
        }
        return list;
    }

    public boolean modifyStuInfo(UserBean bean) {
        boolean flag = false;
        int rowCount = 0;
        try {
            String sql = "update users set Users_Pwd=?,Users_Age=?,Users_Agent=?,Users_Mz=?,Users_No=?,Users_Sex=? where Users_Name=?";
            prepar = conn.prepareStatement(sql);
            prepar.setString(1, bean.getUsers_Pwd());
            prepar.setInt(2, bean.getUsers_Age());
            prepar.setString(3, bean.getUsers_Agent());
            prepar.setString(4, bean.getUsers_Mz());
            prepar.setString(5, bean.getUsers_No());
            prepar.setInt(6, bean.getUsers_Sex());
            prepar.setString(7, bean.getUsers_Name());
            rowCount = prepar.executeUpdate();
            if (rowCount > 0) {
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            Close();
        }
        return flag;
    }

    public boolean adminLogin(String name, String pwd) {
        Connection con = null;
        PreparedStatement pstmt = null;
        boolean flag = false;
        int rowCount = 0;

        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            con = DriverManager.getConnection(
                    "jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=Kaoshi",
                    "sa", "123456");
            String sql = "select * from teacher where tname=? and tpwd=?";
            pstmt = con.prepareStatement(sql);
            pstmt.setString(1, name);
            pstmt.setString(2, pwd);
            rowCount = pstmt.executeUpdate();
            if (rowCount > 0) {
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try{
                if(pstmt != null){
                    pstmt.close();
                    pstmt = null;
                }
                if(con != null){
                    con.close();
                    con = null;
                }
            }catch(Exception ex){
                ex.printStackTrace();
            }
        }
        return flag;
    }


    public static void main(String[] args) {
        DataBean bean = new DataBean();
        //ArrayList list = bean.getUserInfoByName("zhangsan");
        //UserBean userBean = (UserBean)list.get(0);
        //System.out.println("users_id=" + userBean.getUsers_ID());
        //System.out.println("users_name=" + userBean.getUsers_Name());
        //System.out.println("users_pwd=" + userBean.getUsers_Pwd());
        //System.out.println("users_age=" + userBean.getUsers_Age());
        //System.out.println("users_agent=" + userBean.getUsers_Agent());
        //System.out.println("users_mz=" + userBean.getUsers_Mz());
        //System.out.println("users_no=" + userBean.getUsers_No());
        //System.out.println("users_sex=" + userBean.getUsers_Sex());

        //UserBean bean1 = new UserBean();
        //bean1.setUsers_Age(100);
        //bean1.setUsers_Agent("bb");
        //bean1.setUsers_Mz("bb");
        //bean1.setUsers_Name("aa");
        //bean1.setUsers_Pwd("bb");
        //bean1.setUsers_Sex(0);
        //bean1.setUsers_No("123456");
        //if(bean.modifyStuInfo(bean1)){
        //    System.out.println("11111111111111111");
        //}else{
        //    System.out.println("222222222222222222222");
        //}


        boolean flag = bean.adminLogin("admin", "admin");
        System.out.println(flag);
    }

}