MyBatis详解（二）：mybatis开发dao

User findUserById(int id) throws Exception;

List findUserByName(String name) throws Exception;

void insertUser(User user) throws Exception;

void deleteUser(int id) throws Exception;

void updateUser(User user) throws Exception;

}

2.3、dao接口实现类

---

package mybatis.dao;

import mybatis.po.SqlSessionUtils;

import mybatis.po.User;

import org.apache.ibatis.session.SqlSession;

import java.util.List;

public class UserDaoImpl implements UserDao{

@Override

public User findUserById(int id) throws Exception {

SqlSession sqlSession= SqlSessionUtils.getSqlSession();

User user=sqlSession.selectOne(“user.findUserById”,id);

sqlSession.close();

return user;

}

@Override

public List findUserByName(String name) throws Exception {

SqlSession sqlSession=SqlSessionUtils.getSqlSession();

List users= sqlSession.selectList(“user.findUserByName”,name);

sqlSession.close();

return users;

}

@Override

public void insertUser(User user) throws Exception {

SqlSession sqlSession=SqlSessionUtils.getSqlSession();

sqlSession.insert(“user.insertUser”,user);

sqlSession.commit();

sqlSession.close();

}

@Override

public void deleteUser(int id) throws Exception {

SqlSession sqlSession=SqlSessionUtils.getSqlSession();

sqlSession.delete(“user.deleteUser”,id);

sqlSession.commit();

<