SpringMVC +Spring+ SpringJDBC整合实例:
首先设置dao层:
package com.offcn.dao;
import com.offcn.entity.User;
import com.offcn.utils.PageUtils;
import java.util.List;
public interface UserDao {
User selectByName(String userName);
//获取数据-第一个参数当前页,第二个参数是每页显示多少条
List<User> selectAllList(Integer currentPageNo,Integer pageSize);
/**
*
* @return
*/
//查出总记录数
Integer selectUserCount();
/**
*
* @param user
* @return
*/
//增加的方法
Integer addUser(User user);
//删除
/**
*
* @param id
* @return
*/
Integer deleteUser(int id);
//修改
/**
*
* @param user
* @return
*/
Integer updateUser(User user);
//查询单个用户
User selectOneUser(int id);
/*----模糊查询-----*/
List<User> selectLikeUser(PageUtils pageUtils);
//模糊查询总记录数
Integer selectLikeCount(PageUtils pageUtils);
}
UserDaoImpl实现层:
package com.offcn.dao.impl;
import com.offcn.dao.UserDao;
import com.offcn.entity.User;
import com.offcn.handle.ArrayResultHandler;
import com.offcn.handle.BeanListResultHandler;
import com.offcn.handle.BeanResultHandler;
import com.offcn.utils.BaseDao;
import com.offcn.utils.EmptyUtils;
import com.offcn.utils.PageUtils;
import org.springframework.stereotype.Repository;
import java.util.ArrayList;
import java.util.List;
@Repository(“userDao”)
public class UserDaoImpl implements UserDao {
//登陆验证
@Override
public User selectByName(String userName) {
String sql = "select * from user where uname=?";
return (User) BaseDao.executeQuery(sql,new Object[]{userName}, new BeanResultHandler(User.class));
}
//查询分页
@Override
public List<User> selectAllList(Integer currentPageNo, Integer pageSize) {
String sql="select * from user limit ?,?";
Object []objects={(currentPageNo-1)*pageSize,pageSize};
return (List<User>) BaseDao.executeQuery(sql,objects, new BeanListResultHandler(User.class));
}
@Override
//查询总记录数
public Integer selectUserCount() {
String sql="select count(1) from user";
List list =(List) BaseDao.executeQuery(sql, null, new ArrayResultHandler());
String count= list.get(0)+"";
return Integer.parseInt(count);
}
@Override
public Integer addUser(User user) {
String sql="insert into user(uname,upwd,usex) values(?,?,?)";
return BaseDao.executeUpdate(sql,new Object[]{user.getUname(),user.getUpwd(),user.getUsex()});
}
@Override
public Integer deleteUser(int id) {
String sql="delete from user where uid=?";
return BaseDao.executeUpdate(sql,new Object[]{id});
}
@Override
public Integer updateUser(User user) {
String sql="update user set uname=?,upwd=?,usex=? where uid=?";
return BaseDao.executeUpdate(sql,new Object[]{user.getUname(),user.getUpwd(),user.getUsex(),user.getUid()});
}
@Override
public User selectOneUser(int id) {
String sql="select * from user where uid=?";
User user = (User) BaseDao.executeQuery(sql, new Object[]{id}, new BeanResultHandler(User.class));
return user;
}
/*--模糊分页查询--*/
@Override
public List<User> selectLikeUser( PageUtils pageUtils) {
//String sql="select * from user where 1=1";
Strin