@Mapper@RepositorypublicinterfaceUserDao{
List<User>selectAll();
User query(@Param("id")int id);booleanadd(User user);booleandelete(@Param("id")int id);}
创建dao层对应的mapper文件
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.springcloud.dao.UserDao"><select id="selectAll" resultType="user">
select * from user;</select><select id="query" parameterType="_int" resultType="user">
select * from user where id=#{id};</select><insert id="add" parameterType="user">
insert into user(name, pwd) values (#{name}, #{pwd});</insert><delete id="delete" parameterType="_int">
delete from user where id=#{id};</delete></mapper>
public interface UserService {
List<User> selectAll();
User query(int id);
boolean add(User user);
boolean delete(int id);}
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<User> selectAll(){return userDao.selectAll();}
@Override
public User query(int id){return userDao.query(id);}
@Override
public boolean add(User user){return userDao.add(user);}
@Override
public boolean delete(int id){return userDao.delete(id);}}