package com.eshop.bean;

import java.sql.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.eshop.util.*;


public class User {
	
	private int id;
	private String username;
	private String password;
	private String phone;
	private String addr;
	private Date rdate;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getAddr() {
		return addr;
	}
	public void setAddr(String addr) {
		this.addr = addr;
	}
	public Date getRdate() {
		return rdate;
	}
	public void setRdate(Date rdate) {
		this.rdate = rdate;
	}
	
	/**
	 * 用戶注冊
	 */
	public void regUser() {

		Connection conn = ConnectionManager.getConn();
		
		PreparedStatement pstmt = null;
		String sql = "insert into [user] (username,password,phone,addr,rdate) values(?,?,?,?,getdate())";
		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			pstmt.setString(3, phone);
			pstmt.setString(4, addr);

			pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			ConnectionManager.closeConn(conn);
			ConnectionManager.closePreparedStatement(pstmt);
		}

	}
	
	/**
	 * 獲取用戶列表
	 * @return
	 */
	public  List getUsers(){
		List  Users=new ArrayList();
		String sql="select * from [user] ";
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		
		Connection conn=ConnectionManager.getConn();
		try{
			
		pstmt=conn.prepareStatement(sql);
		rs=pstmt.executeQuery();
		while(rs.next()){
			User u=new User();
			u.setId(rs.getInt("id"));
			u.setAddr(rs.getString("addr"));
			u.setPhone(rs.getString("phone"));
			u.setUsername(rs.getString("username"));
			u.setRdate(rs.getTimestamp("rdate"));
			Users.add(u);
			
		}
		}catch (SQLException e){
			e.printStackTrace();
		}finally{
			ConnectionManager.closeResultSet(rs);
			ConnectionManager.closePreparedStatement(pstmt);
			ConnectionManager.closeConn(conn);
		}
		return Users;
	}
	

	public static void main(String [] args){
		User u=new User();
		System.out.println(u.getUsers().size());
//		
//		u.setAddr("fdfdfd");
//		u.setPassword("fddfdf");
//		u.setPhone("fdfdf");
//		u.setUsername("12323232");
		//u.setRdate(new Date(System.currentTimeMillis()));
		//u.regUser();
	}
	
	
	

}