JavaWeb商品管理系统

package com.demo.service.impl; import com.demo.mapper.BrandMapper; import com.demo.pojo.Brand; import com.demo.pojo.PageBean; import com.demo.service.BrandService; import com.demo.util.MyBatisUtils; import org.apache.ibatis.session.SqlSession; import java.util.List; public class BrandServiceImpl implements BrandService { @Override public List<Brand> selectAll() { //获取Mybatis连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用查询方法 List<Brand> brands = mapper.selectAll(); sqlSession.close(); return brands; } /** * 添加商品 * @param brand */ @Override public void addBrand(Brand brand) { //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用方法添加数据 mapper.addBrand(brand); sqlSession.commit(); sqlSession.close(); } /** * 修改数据 * @param brand */ @Override public void updateBrand(Brand brand) { //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用修改方法 mapper.updateBrand(brand); sqlSession.commit(); sqlSession.close(); } /** * 删除数据 * @param index */ @Override public void deleteBrand(int index) { //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用方法 mapper.deleteBrand(index); sqlSession.commit(); sqlSession.close(); } /** * 批量删除 * @param ints */ @Override public void deleteByIds(int[] ints) { //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用方法 mapper.deleteByIds(ints); sqlSession.commit(); sqlSession.close(); } /** * 分页查询 * @param currentPage * @param pageSize * @return */ @Override public PageBean selectBrandPage(int currentPage, int pageSize) { //计算开始数据 int start = (currentPage -1 ) * pageSize; //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用方法，查询总数 int total = mapper.totalBrand(); //调用方法查询页面显示 List<Brand> brands = mapper.selectPageBrand(start,pageSize); //封装到PageBean PageBean pageBean = new PageBean(total, brands); sqlSession.close(); return pageBean; } @Override public PageBean selectByPageAndCondition(int currentPage, int pageSize, Brand brand) { int start = (currentPage - 1) * pageSize; //获取连接 SqlSession sqlSession = MyBatisUtils.openSession(); BrandMapper mapper = sqlSession.getMapper(BrandMapper.class); //调用方法,查询条件总数 int selectByPageTotal = mapper.selectByPageAndConditionTotal(brand); //调用方法查询页面数据 List<Brand> brands = mapper.selectByPageAndCondition(start,pageSize,brand); sqlSession.close(); //封装数据 PageBean pageBean = new PageBean(selectByPageTotal,brands); return pageBean; } }