userserver.java~6~

来自「网上购书系统！jsp+servlet+jdbc实现！数据库sqlserver2」· JAVA~6~ 代码 · 共 77 行

package serives;

import java.sql.*;
import beans.UserBean;
import DbUtil.DbLink;
import java.util.ArrayList;
import beans.BookInfoBean;

public class userserver {
    private static String sql1 = "SELECT * FROM UserInfo WHERE UserName=?";
    private static String sql2 = "SELECT * FROM UserInfo WHERE PassWord=?";
    private static String sql3 = "SELECT num,name,rmb FROM BookInfo";
    public static boolean isSelectUser(UserBean bean) {
        boolean flag = false;
        try {
            Connection con = DbLink.getConnection();
            PreparedStatement prs = con.prepareStatement(sql1);
            prs.setString(1, bean.getUsername());
            ResultSet rs = prs.executeQuery();
            if (rs.next()) {
                flag = true;
            } else {
                flag = false;
            }
            rs.close();
            prs.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return flag;
    }

    public static boolean isSelectPassWord(UserBean bean) {
        boolean flag = false;
        try {
            Connection con = DbLink.getConnection();
            PreparedStatement prs = con.prepareStatement(sql2);
            prs.setString(1, bean.getUserpassword());
            ResultSet rs = prs.executeQuery();
            if (rs.next()) {
                flag = true;
            } else {
                flag = false;
            }
            rs.close();
            prs.close();
            con.close();

        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return flag;
    }
    public static ArrayList SelectBookInfo(){
        ArrayList list = new ArrayList();
        try {
            Connection con = DbLink.getConnection();
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(sql3);
            while(rs.next()){
                BookInfoBean bookbean = new BookInfoBean();
                bookbean.setNum(rs.getString(1));
                bookbean.setName(rs.getString(2));
                bookbean.setRmb(rs.getString(3));
                list.add(bookbean);
            }
            rs.close();
            st.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return list;
    }
}