buyerbean.java

小书店代码可以实现一些简单的功能适合初学习jsp的读者

package cuug;
import java.sql.*;

public class BuyerBean {
	
	private String memberID = null ;   
	private String memberName = null;  
	private String pwd = null;			
	private int logontimes = -1;			
	private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	private static String strDBUrl = "jdbc:odbc:bookstore";  
	private Connection conn =null;            
	private ResultSet rs = null;					
	
	public BuyerBean (){
		
		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();
			
			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 ;
	}
	
	public  void setMemberID(String ID){
		this.memberID = ID;
	}
	
	public void  setPwd(String password){
		this.pwd = password;
	}
	
	public String getMemberName(){
		return memberName;
	}
}