package com.qrsx.buyflowers.beans;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;

import java.util.ArrayList;

public class UserBean extends DBConnection {
	private UserClass userClass;// 本類的實體對象

	private Collection collection = null;

	private PreparedStatement ptst = null;

	private ResultSet rs = null;

	public UserBean() throws ClassNotFoundException, SQLException {
		super();
	}

	public void setUserInfo(UserClass userClass) {
		this.userClass = userClass;
	}
	public Collection getUserInfo(){
		collection = new ArrayList();
		collection.add(userClass);
		return collection;
		
	}

	public void addUserInfo() {
		String sql = "insert into users(usersName,usersPass,usersRepass,usersPassQuestion,usersPassReply,usersTrueName,usersAddress,usersPhone,usersE_mail) values(?,?,?,?,?,?,?,?,?);";
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, this.userClass.getUsersName());
			ptst.setString(2, this.userClass.getUsersPass());
			ptst.setString(3, this.userClass.getUsersRepass());
			ptst.setString(4, this.userClass.getUsersPassQuestion());
			ptst.setString(5, this.userClass.getUsersPassReply());
			ptst.setString(6, this.userClass.getUsersTrueName());
			ptst.setString(7, this.userClass.getUsersAddress());
			ptst.setString(8, this.userClass.getUsersPhone());
			ptst.setString(9, this.userClass.getUsersE_mail());
			ptst.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Boolean checkUserInfo() {
		String sql = "select usersName,usersPass from users where usersName=? and usersPass=?";
		Boolean flag = false;
		try {
			ptst = con.prepareStatement(sql);
			ptst.setString(1, this.userClass.getUsersName());
			ptst.setString(2, this.userClass.getUsersPass());
			rs = ptst.executeQuery();
			while (rs.next()) {
				flag = true;
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return flag;

	}

	public Collection getUserByUserName(String usersName) {
		String sql = "select * from users where usersName=?";
		try {
			ptst = con.prepareStatement(sql);
			collection = new ArrayList();
			ptst.setString(1, usersName);
			rs = ptst.executeQuery();
			while (rs.next()) {
				userClass = new UserClass();
				userClass.setUsersId(rs.getString("usersID"));
				userClass.setUsersName(rs.getString("usersName"));
				userClass.setUsersTrueName(rs.getString("usersTrueName"));
				userClass.setUsersAddress(rs.getString("usersAddress"));
				userClass.setUsersE_mail(rs.getString("usersE_mail"));
				collection.add(userClass);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return collection;

	}
}