使用Cookie实现商品的浏览记录功能

package com.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.entity.Items; /** * 实体Dao类 * @author feizi * 业务逻辑类 */ public class EntityDao { private Connection conn = null; private PreparedStatement pst = null; private ResultSet rs = null; /** * 查询所有的商品列表 * @return */ public List<Items> getItemsList(){ List<Items> itemsList = new ArrayList<Items>(); Items items = null; String sql = "SELECT * FROM items;"; try { pst = DaoHelper.getConnection().prepareStatement(sql); rs = pst.executeQuery(); while(rs.next()){ items = new Items(); items.setId(rs.getInt("id")); items.setName(rs.getString("name")); items.setCity(rs.getString("city")); items.setNumber(rs.getInt("number")); items.setPrice(rs.getDouble("price")); items.setPicture(rs.getString("picture")); itemsList.add(items); } } catch (SQLException e) { e.printStackTrace(); }finally{ DaoHelper.closeConnection(rs, pst, conn); } return itemsList; } /** * 根据商品编号查询商品 * @param id * @return */ public Items getItemsById(int id){ Items items = null; String sql = "SELECT * FROM items WHERE id = ?;"; try { pst = DaoHelper.getConnection().prepareStatement(sql); pst.setInt(1, id); rs = pst.executeQuery(); if(rs.next()){ items = new Items(); items.setId(rs.getInt("id")); items.setName(rs.getString("name")); items.setCity(rs.getString("city")); items.setNumber(rs.getInt("number")); items.setPrice(rs.getDouble("price")); items.setPicture(rs.getString("picture")); } } catch (SQLException e) { e.printStackTrace(); }finally{ DaoHelper.closeConnection(rs, pst, conn); } return items; } /** * 获取最近浏览的五条记录信息 * @param list * @return */ public List<Items> getViewList(String list){ System.out.println("=================================getViewList"); List<Items> itemList = new ArrayList<Items>(); int iCount = 5; if(null != list && list.length() > 0){ String[] arr = list.split(","); //倒序输出五条信息 if(arr.length >= 5){ for (int i = arr.length-1; i >= arr.length-iCount; i--) { System.out.println("============1>>>>>>>>>i:"+i); itemList.add(getItemsById(Integer.parseInt(arr[i]))); } }else{ for (int i = arr.length-1; i >= 0; i--) { System.out.println("============2>>>>>>>>>>i:"+i); itemList.add(getItemsById(Integer.parseInt(arr[i]))); } } return itemList; }else{ return null; } } /** * main测试 * @param args */ public static void main(String[] args){ EntityDao dao = new EntityDao(); /*List<Items> itemsList = dao.getItemsList(); if(null != itemsList && itemsList.size() > 0){ for(Items items : itemsList){ System.out.println(items.getId()+","+items.getName()+","+items.getCity()+",￥" +items.getPrice()+","+items.getNumber()+","+items.getPicture()); } }*/ /*Items items = dao.getItemsById(1); if(items != null){ System.out.println("\n\n"+items.getId()+","+items.getName()+","+items.getCity()+",￥" +items.getPrice()+","+items.getNumber()+","+items.getPicture()); }*/ List<Items> itemsList = dao.getViewList("1;2;3"); if(null != itemsList && itemsList.size() > 0) { for(Items items : itemsList) { System.out.println(items.getId()+","+items.getName()+","+items.getCity()+",￥" +items.getPrice()+","+items.getNumber()+","+items.getPicture()); } } } }