userserver.java~7~

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

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";
    private static String sql4 =
            "INSERT INTO UserInfo(UserName,PassWord,Sex,Tel,Address) VALUES(?,?,?,?,?)";
    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;
    }

    public static void insertUserInfo(UserBean bean){
        try {
            Connection con = DbLink.getConnection();
            PreparedStatement prs = con.prepareStatement(sql4);
            prs.setString(1,bean.getUsername());
            prs.setString(2,bean.getUserpassword());
            prs.setString(3,bean.getSex());
            prs.setString(4,bean.getTel());
            prs.setString(5,bean.getAddress());
            prs.executeUpdate();
            prs.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}