package com.demo.dao.impl; import java.util.HashMap; import java.util.List; import java.util.Map; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import com.demo.dao.IUserDao; import com.demo.entity.User; public class UserDaoImpl implements IUserDao{ private SqlSessionFactory sqlSessionFactory; public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) { this.sqlSessionFactory = sqlSessionFactory; } @Override public void insert(User user) { SqlSession sqlSession = sqlSessionFactory.openSession(); sqlSession.insert("users.insert", user); } @Override public void delete(int userid) { SqlSession sqlSession = sqlSessionFactory.openSession(); sqlSession.insert("users.delete", userid); } @Override public void update(User user) { SqlSession sqlSession = sqlSessionFactory.openSession(); sqlSession.insert("users.update", user); } @Override public User query(int userid) { SqlSession sqlSession = sqlSessionFactory.openSession(); return sqlSession.selectOne("users.query", userid); } @Override public List<User> getList(int index, int count) { SqlSession sqlSession = sqlSessionFactory.openSession(); Map<String, Object> map = new HashMap<String,Object>(); map.put("index", index); map.put("size",count); return sqlSession.selectList("users.getList", map); } @Override public User login(String username, String password) { SqlSession sqlSession = sqlSessionFactory.openSession(); Map<String, Object> map = new HashMap<String,Object>(); map.put("username", username); map.put("password",password); return sqlSession.selectOne("users.login", map); } }
最近下载更多