package wdm;

import java.sql.*;

public class BuyerBean {

	private String memberID = null; // 會員ID

	private String memberName = null; // 會員姓名

	private String pwd = null; // 密碼

	private int logonTimes = -1; // 登錄的次數

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

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

	private Connection conn = null; // 連接

	private ResultSet rs = null; // 結果集

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

	// 獲得登錄次數，登錄的會員的名字也在該方法調用時獲得
	public int getLogontimes() {
		String strSql = null;
		try {
			conn = DriverManager.getConnection(strDBUrl);
			Statement stmt = conn.createStatement();
			strSql = "Select logonTimes,memberName from buyerInfo where memberID = '"
					+ memberID + "' and pwd ='" + pwd + "'";
			rs = stmt.executeQuery(strSql);
			while (rs.next()) {
				// 登錄的次數
				logonTimes = rs.getInt("logonTimes");
				// 會員姓名
				memberName = rs.getString("memberName");
			}
			rs.close();
			// 如果是合法會員則將其登錄次數加1
			if (logonTimes != -1) {
				strSql = "Update buyerInfo set logonTimes = logonTimes +1 where memberID = '"
						+ memberID + "'";
				stmt.executeUpdate(strSql);
			}
			stmt.close();
			conn.close();

		}
		// 捕獲異常
		catch (SQLException e) {
			System.err.println("BuyerBean.getLogontimes():" + e.getMessage());
		}
		return logonTimes;
	}

	// 設置memberID屬性；
	public void setMemberID(String ID) {
		this.memberID = ID;
	}

	// 設置pwd 屬性
	public void setPwd(String password) {
		this.pwd = password;
	}

	// 獲得該會員的真實姓名，必須在取該會員登錄的次數之后才能被賦予正確的值
	public String getMemberName() {
		return memberName;
	}

	/*
	 * 測試Bean中的各個方法是否能夠正常工作 public static void main(String args[]) { BuyerBean
	 * buyer = new BuyerBean(); buyer.setMemberID("abcd"); buyer.setPwd("1234");
	 * System.out.println(buyer.getLogontimes());
	 * System.out.println(buyer.getMemberName()); }
	 */
}