buyerbean.java

网上书店

package cuug;
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 + "'";
			System.out.println(strSql);
			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){
			e.printStackTrace();
			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());
	}*/


}