userbeanbo.java

用MVC实现JSP购物车案例说明详细设计方案

package com.shop.model;
import java.sql.*;

public class UserBeanBo {
	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs=null;
	/**
	 * @author 让痛苦痛苦
	 * @return 返回验证的用户合法性 
	 * @return
	 */
	public boolean check(String u,String p){
		boolean b=false;
		try {
			String sql="select * from users where username='"+u+"'";
			conn=new Conn().getConn();
			pstmt=conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			if(rs.next())
			{
				String dbPass=rs.getString(3);
				if(dbPass.equals(p))
				{
				
					b=true;
				}
			}
			
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
				
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
		return b;
	}
	
	/**
	 * @author 让痛苦痛苦
	 * @param getUb 建立用户bean
	 * @return
	 */
	public UserBean getUb(String u)
	{
		UserBean ub=new UserBean();
		String sql="select * from users where username="+u+"";
		
		try {
			conn=new Conn().getConn();
			pstmt=conn.prepareStatement(sql);
			rs=pstmt.executeQuery();
			if(rs.next())
			{
				ub.setUserid(rs.getInt(1));
				ub.setUsername(rs.getString(2));
				ub.setPasswd(rs.getString(3));
				ub.setEmail(rs.getString(4));
				ub.setAddress(rs.getString(5));
				ub.setGrade(rs.getInt(6));
			}
		} catch (Exception e) {
			e.printStackTrace();
			// TODO: handle exception
		}
		finally 
		{
			try {
				rs.close();
				pstmt.close();
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
				// TODO: handle exception
			}
		}
		return ub;
		
	}

}