userimpl.java

jsp+servlet网上购物,是一个实现mvc的网站

package com.ebook.impl;

import java.sql.*;
import com.ebook.dao.UserDao;
import com.ebook.Entity.*;
import java.text.SimpleDateFormat;

public class UserImpl implements UserDao {

    private Connection con;

    public UserImpl(Connection con) {
        this.con = con;
    }

    public boolean isLogin(User user) throws Exception {
        boolean flag = false;
        PreparedStatement pstm;
        String sql = "select* from user where name=? and password=?";
        pstm = con.prepareStatement(sql);
        pstm.setString(1, user.getName());
        pstm.setString(2, user.getPassword());
        ResultSet rs = pstm.executeQuery();
        while (rs.next()) {
            flag = true;
        }

        return flag;
    }
 public boolean isAdminLogin(Admin admin) throws Exception {
        boolean flag = false;
        PreparedStatement pstm;
        String sql = "select* from admin where adminname=? and password=?";
        pstm = con.prepareStatement(sql);
        pstm.setString(1, admin.getAdminname());
        pstm.setString(2, admin.getPassword());
        ResultSet rs = pstm.executeQuery();
        while (rs.next()) {
            flag = true;
        }

        return flag;
    }
    public boolean isExist(String username) throws Exception {
        boolean flag = false;
        PreparedStatement pstm;
        String sql = "select name from user where name=?";
        pstm = con.prepareStatement(sql);
        pstm.setString(1, username);
        ResultSet rs = pstm.executeQuery();
        while (rs.next()) {
            if (rs.getString("name").equals(username)) {
                flag = true;
            }
        }
        return flag;
    }

    public User findUser(String username) throws Exception {
        PreparedStatement pstm;
        String sql = "select* from user where name=?";
        pstm = con.prepareStatement(sql);
        pstm.setString(1, username);
        ResultSet rs = pstm.executeQuery();
        User user = null;
        while (rs.next()) {
            user = new User();
            user.setId(rs.getInt("id"));
            user.setName(rs.getString("name"));
            user.setPassword(rs.getString("password"));
            user.setAddress(rs.getString("adress"));
            user.setSex(rs.getString("sex"));
            user.setEmail(rs.getString("email"));
            user.setPhone(rs.getString("phone"));
            user.setPostNum(rs.getString("postNum"));
            user.setRegtime(rs.getString("regtime"));
        }
        return user;
    }

    public void addUser(User user) throws Exception {
        PreparedStatement pstm;
        String sql = "insert into user(name,password,email,phone,adress,postNum,sex,regtime) values(?,?,?,?,?,?,?,?)";
        pstm = con.prepareStatement(sql);
        pstm.setString(1, user.getName());
        pstm.setString(2, user.getPassword());
        pstm.setString(3, user.getEmail());
        pstm.setString(4, user.getPhone());
        pstm.setString(5, user.getAddress());
        pstm.setString(6, user.getPostNum());
        pstm.setString(7, user.getSex());
        pstm.setString(8, getDate());
        pstm.executeUpdate();


    }

    public String getDate() {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        String time = df.format(new java.util.Date());
        return time;
    }
}