buyerbean.java

JSP的在线书店的所有源代码 使用MyEclipse开发工具

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()); }
	 */
}