mydao.java

jsp购物车

package com.accp.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.accp.bean.User;
import com.accp.bean.UserShop;
import com.accp.bean.UserShopItem;

public class MyDao implements IDao{
	private Connection con;
	private PreparedStatement pre;
	private ResultSet rs;
	private User user;
	private UserShop shop;
	private UserShopItem usi;
    ArrayList<User> ls;
    ArrayList<UserShop> us;
    ArrayList<UserShopItem> ushop;
    public MyDao()
    {
    	ls=new ArrayList<User>();
    	us=new ArrayList<UserShop>();
    	ushop=new ArrayList<UserShopItem>();
    }
    public void Close()
    {
    	try {
			if(rs!=null)
			{
				rs.close();
			}
			if(pre!=null)
			{
				pre.close();
			}
			if(con!=null)
			{
				con.close();
			}
		} catch (Exception e) {
			System.out.println("关闭异常！");
		}
    }

	public User login(String userName,String userPwd)
	{
		String sql="select * from userInfo where userName=? and userPwd=?";
		try {
			con=BaseDao.getCon();
			pre=con.prepareStatement(sql);
			pre.setString(1,userName);
			pre.setString(2,userPwd);
			rs=pre.executeQuery();
			while(rs.next())
			{
				user=new User();
				user.setUserId(rs.getInt(1));
				user.setUserName(rs.getString(2));
				user.setUserPwd(rs.getString(3));
			}
		} catch (Exception e) {
			System.out.println("登录失败！"+e.toString());
		}finally
		{
			Close();
		}
		return user;
	}
	public ArrayList<User> lookUser()
	{
		String sql="select * from userInfo";
		try {
			con=BaseDao.getCon();
			pre=con.prepareStatement(sql);
			rs=pre.executeQuery();
			while(rs.next())
			{
				user=new User();
				user.setUserId(rs.getInt(1));
				user.setUserName(rs.getString(2));
				user.setUserPwd(rs.getString(3));
				ls.add(user);
			}				
		} catch (Exception e) {
			System.out.println("查询用户信息失败！"+e.toString());
		}finally
		{
			Close();
		}
		return ls;
	}
	public ArrayList<UserShop> selectResult()
	{
		String sql="select * from shopInfo";
		try {
			con=BaseDao.getCon();
			pre=con.prepareStatement(sql);
			rs=pre.executeQuery();
			while(rs.next())
			{
			    shop=new UserShop();
			    shop.setShopId(rs.getString(1));
			    shop.setShopName(rs.getString(2));
			    shop.setShopPrice(rs.getDouble(3));
			    us.add(shop);
			}
			
		} catch (Exception e) {
			System.out.println("查询购物车失败！"+e.toString());
		}finally
		{
			Close();
		}
		return us;
	}
//	public ArrayList<UserShopItem> cool()
//	{
//		String sql="select * from shopInfo";
//		try {
//			con=BaseDao.getCon();
//			pre=con.prepareStatement(sql);
//			rs=pre.executeQuery();
//			while(rs.next())
//			{
//			    usi=new UserShopItem();
//			    usi.setUser(rs.getClass(1));
//			}
//			
//		} catch (Exception e) {
//			System.out.println("查询购物车失败！"+e.toString());
//		}finally
//		{
//			Close();
//		}
//		return ushop;
//	}
}