package wdm;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class UserBean {
	private String memberID;

	private String memberName;

	private String pwd;

	private String email;

	private String phoneCode;

	private String zipCode;

	private String address;

	private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; // JDBC驅動

	private static String strDBUrl = "jdbc:odbc:bookstore"; // 數據源 ，

	private Connection conn = null; // 連接

	public UserBean() {
		// 加載JDBC-ODBC驅動
		try {
			Class.forName(strDBDriver);
		}
		// 捕獲異常
		catch (java.lang.ClassNotFoundException e) {
			System.err.println("BuyerBean():" + e.getMessage());
		}
	}

	public String getAddress() {
		return address;
	}

	public void setAddress(String userAddress) {
		this.address = userAddress;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String userEmail) {
		this.email = userEmail;
	}

	public String getMemberID() {
		return memberID;
	}

	public void setMemberID(String userID) {
		this.memberID = userID;
	}

	public String getMemberName() {
		return memberName;
	}

	public void setMemberName(String userName) {
		this.memberName = userName;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String userPassword) {
		this.pwd = userPassword;
	}

	public String getPhoneCode() {
		return phoneCode;
	}

	public void setPhoneCode(String userTelephone) {
		this.phoneCode = userTelephone;
	}

	public String getZipCode() {
		return zipCode;
	}

	public void setZipCode(String userZipcode) {
		this.zipCode = userZipcode;
	}

	public boolean reg() {
		Statement stmt;
		String strSql = "";
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "insert into buyerInfo"
					+ " values( '"
					+ this.memberID
					+ "', '"
					+ this.memberName
					+ "', 1,'"
					+ this.pwd
					+ "', '"
					+ this.phoneCode
					+ "', '"
					+ this.zipCode
					+ "','"
					+ this.address
					+ "', '"
					+ this.email
					+ "')";
			System.out.println("phoneCode  :" + phoneCode
					+ "---------memberName:" + memberName);
			System.out.println(strSql);
			stmt.executeUpdate(strSql);

		} catch (Exception e) {
			System.out.println(e);
			return false;
		}
		return true;
	}

	public boolean upDate() {
		Statement stmt;
		String strSql = "";
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "update buyerInfo" + " set memberName= '"
					+ this.memberName + "',pwd= '" + this.pwd
					+ "',phoneCode= '" + this.phoneCode + "',zipCode= '"
					+ this.zipCode + "', address='" + this.address
					+ "', email= '" + this.email + "' where memberID='"
					+ getMemberID() + "'";
			System.out.println(strSql);
			stmt.executeUpdate(strSql);

		} catch (Exception e) {
			System.out.println(e);
			return false;
		}
		return true;
	}

	public List getAllUser() {
		Statement stmt;
		String strSql = "";
		UserBean user = null;// new UserBean();
		List list = new ArrayList();
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "select * from buyerInfo";
			// System.out.println(strSql);
			ResultSet rs = stmt.executeQuery(strSql);
			while (rs.next()) {
				user = new UserBean();
				user.setMemberID(rs.getString("memberID"));
				user.setMemberName(rs.getString("memberName"));
				user.setPwd(rs.getString("pwd"));
				user.setEmail(rs.getString("email"));
				user.setPhoneCode(rs.getString("phoneCode"));
				user.setZipCode(rs.getString("zipCode"));
				user.setAddress(rs.getString("address"));
				list.add(user);
			}

		} catch (Exception e) {
			System.out.println(e);
			// return false;
		}
		return list;
	}

	public void del(String memberID) {
		Statement stmt;
		String strSql = "";
		try {
			conn = DriverManager.getConnection(strDBUrl);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE);

			strSql = "delete from buyerInfo where memberID='" + memberID + "'";
			stmt.executeUpdate(strSql);

		} catch (Exception e) {
			System.out.println(e);
			// return false;
		}
	}

}