userserver.java

网上购书系统！jsp+servlet+jdbc实现！数据库sqlserver2

package serives;

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

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(?,?,?,?,?)";
    private static String sql5 =
            "INSERT INTO BuyBookInfo(username,buybook,sumrmb,buydate) 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();
        }
    }

    public static void insertBuyBookInfo(BuyBookInfo buybean) {
        try {
            Connection con = DbLink.getConnection();
            PreparedStatement prs = con.prepareStatement(sql5);
            prs.setString(1, buybean.getUsername());
            prs.setString(2, buybean.getBuybook());
            prs.setString(3, buybean.getSumrmb());
            prs.setString(4, buybean.getBuydate());
            prs.executeUpdate();
            prs.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}