完整ssm框架游乐园项目+有聊天功能

package com.first.fangte.dao; import java.util.List; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import com.first.fangte.model.ProNote; import com.first.fangte.model.Product; import com.first.fangte.model.ReceiveAddr; import com.first.fangte.model.Shopping; import com.first.fangte.model.UserProduct; public class ProductDaoImpl implements ProductDao{ private SqlSessionFactory sf; public static final String mapping="com.first.fangte.model."; public SqlSessionFactory getSf() { return sf; } public void setSf(SqlSessionFactory sf) { this.sf = sf; } @Override//1-添加商品 public boolean addProduct(Product p) { SqlSession session=sf.openSession(); int ret=session.insert(mapping+"ProductMapping.addProduct", p); session.commit(); session.close(); return ret>0?true:false; } @Override//2-根据商品编号删除商品 public boolean deleteProduct(int pid) { SqlSession session=sf.openSession(); int ret=session.delete(mapping+"ProductMapping.deleteProduct", pid); session.commit(); session.close(); return ret>0?true:false; } @Override//3-根据商品编号修改商品信息 public boolean updateProduct(Product p) { SqlSession session=sf.openSession(); int ret=session.update(mapping+"ProductMapping.updateProduct", p); session.commit(); session.close(); return ret>0?true:false; } @Override//4-查询所有商品信息 public List<Product> queryAllProduct() { SqlSession session=sf.openSession(); List<Product>list=session.selectList(mapping+"ProductMapping.queryProduct"); session.close(); return list; } @Override//5-根据商品编号查询商品信息 public Product queryByPid(int pid) { Product p=new Product(); p.setPid(pid); SqlSession session=sf.openSession(); Product product=session.selectOne(mapping+"ProductMapping.queryProduct", p ); session.close(); return product; } @Override//6-根据商品名称查询(关联模糊查询) public List<Product> queryByPname(String key) { Product p=new Product(); p.setPname(key); SqlSession session=sf.openSession(); List<Product>list=session.selectList(mapping+"ProductMapping.queryProduct",p); session.close(); return list; } @Override//7-根据种类查询 public List<Product> queryByPtype(String type) { Product p=new Product(); p.setPtype(type); SqlSession session=sf.openSession(); List<Product>list=session.selectList(mapping+"ProductMapping.queryProduct",p); session.close(); return list; } @Override//8-给购物车添加商品 public boolean addShopping(Shopping sh) { SqlSession session=sf.openSession(); int ret=session.insert(mapping+"ShoppingMapping.addShopping",sh); session.commit(); session.close(); return ret>0?true:false; } @Override//9-根据商品编号删除商品 public boolean deleteShopping(int sid) { SqlSession session=sf.openSession(); Shopping sh=new Shopping(); sh.setSid(sid); int ret=session.delete(mapping+"ShoppingMapping.deleteShopping",sh); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean updateShopping(Shopping sh) { SqlSession session=sf.openSession(); int ret=session.update(mapping+"ShoppingMapping.updateShopping",sh); session.commit(); session.close(); return ret>0?true:false; } @Override public List<Shopping> queryAllShopping(){ SqlSession session=sf.openSession(); List<Shopping>list=session.selectList(mapping+"ShoppingMapping.queryShopping"); session.close(); return list; } @Override public List<Shopping> queryShoppingByUname(String uname) { SqlSession session=sf.openSession(); Shopping sh=new Shopping(); sh.setUsername(uname); List<Shopping>list=session.selectList(mapping+"ShoppingMapping.queryShopping",sh); session.close(); return list; } @Override public Shopping queryByShid(int sid) { SqlSession session=sf.openSession(); Shopping sh=new Shopping(); sh.setSid(sid); Shopping shopping=session.selectOne(mapping+"ShoppingMapping.queryShopping",sh); session.close(); return shopping; } @Override public boolean addUserProduct(UserProduct up) { SqlSession session=sf.openSession(); int ret=session.insert(mapping+"UserProductMapping.addUserProduct",up); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean deleteUserProduct(int upid) { SqlSession session=sf.openSession(); int ret=session.delete(mapping+"UserProductMapping.deleteUserProduct",upid); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean updateUserProduct(UserProduct up) { SqlSession session=sf.openSession(); int ret=session.update(mapping+"UserProductMapping.updateUserProduct",up); session.commit(); session.close(); return ret>0?true:false; } @Override public List<UserProduct> queryAllUserProduct() { SqlSession session=sf.openSession(); List<UserProduct>list=session.selectList(mapping+"UserProductMapping.queryUserProduct"); session.close(); return list; } @Override public List<UserProduct> queryUserProductByUname(String uname) { SqlSession session=sf.openSession(); UserProduct up=new UserProduct(); up.setUsername(uname); List<UserProduct>list=session.selectList(mapping+"UserProductMapping.queryUserProduct",up); session.close(); return list; } @Override public List<UserProduct> queryUserProductByPid(int pid) { SqlSession session=sf.openSession(); UserProduct up=new UserProduct(); up.setPid(pid); List<UserProduct>list=session.selectList(mapping+"UserProductMapping.queryUserProduct",up); session.close(); return list; } @Override public UserProduct queryUserProductByUpid(int upid) { SqlSession session=sf.openSession(); UserProduct up=new UserProduct(); up.setUpid(upid); UserProduct userProduct=session.selectOne(mapping+"UserProductMapping.queryUserProduct",up); session.close(); return userProduct; } @Override public boolean deleteUserProducts(List<Integer> list) { SqlSession session=sf.openSession(); int ret=session.delete(mapping+"UserProductMapping.deleteSomeUserProduct", list); session.commit(); session.close(); return ret>0?true:false; } @Override//发表评论 public boolean addProNote(ProNote pn) { SqlSession session=sf.openSession(); int ret=session.insert(mapping+"ProNoteMapping.addProNote", pn); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean deleteProNoteById(int id) { SqlSession session=sf.openSession(); ProNote pn=new ProNote(); pn.setPnid(id); int ret=session.delete(mapping+"ProNoteMapping.deleteProNote", pn); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean deleteProNoteByPid(int pid) { SqlSession session=sf.openSession(); ProNote pn=new ProNote(); pn.setPid(pid); int ret=session.delete(mapping+"ProNoteMapping.deleteProNote", pn); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean deleteProNoteByUname(String uname) { SqlSession session=sf.openSession(); ProNote pn=new ProNote(); pn.setUsername(uname); int ret=session.delete(mapping+"ProNoteMapping.deleteProNote", pn); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean deleteProNoteByStatus(String status) { SqlSession session=sf.openSession(); ProNote pn=new ProNote(); pn.setStatus(status); int ret=session.delete(mapping+"ProNoteMapping.deleteProNote", pn); session.commit(); session.close(); return ret>0?true:false; } @Override public boolean updateProNoteById(int id) { SqlSession session=sf.openSession(); int ret=session.delete(mapping+"ProNoteMapping.updateProNote", id); session.commit(