10.11

spring+mybatis
IUserDao

public interface IUserDao {
    List<User> findAll();
    void update(int id,String username,String password);
    void delete(int id);
    void insert(String username,String password);
}

UserServece

import java.util.List;
@Service
public class UserService implements IUserService {
    @Autowired
    private IUserDao userDao;

    @Override
    public void update(int id, String username, String password) {
        userDao.update(id,username,password);
    }

    @Override
    public void delete(int id) {
        userDao.delete(id);
    }

    @Override
    public void insert(String username, String password) {
        userDao.insert(username,password);
    }

    @Override
    public List<User> findAll() {
        return userDao.findAll();
    }
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.zhongruan.dao.IUserDao">
    <select id="findAll" resultType="com.zhongruan.bean.User">
        select * from fuser
    </select>
    <select id="delete" parameterType="int">
            delete * from fuser where id=#{id}
        </select>
    <select id="update" parameterType="com.zhongruan.bean.User">
        update fuser set username=#{username},password=#{password} where id=#{id}
    </select>
    <select id="insert" parameterType="com.zhongruan.bean.User">
        insert into fuser(username,password) value(#{username},#{password})
    </select>
</mapper>

test

public class test {
    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        IUserService userService = (IUserService) context.getBean("userService");
        List<User> users = userService.findAll();
        System.out.println(users);
    }
}