本文共 6500 字，大约阅读时间需要 21 分钟。

按照上次的博客：

这次把Hibernate转换成Mybatis 3.4.1 基本变化在于数据操作层。

下面贴出代码变动的地方（没有贴出的跟上面一条博客相同，项目运行效果也是一致的），以及此次学习Mybatis用的参考文档.有关Ioc可以参考，有关AOP可以参考，有关Mybatis可以参考

目录结构图 ：

bean.xml :

web.xml:

   
            
      
        
     
      org.springframework.web.context.ContextLoaderListener
       
      
          
     
      contextConfigLocation
           
     
      classpath*:bean.xml
         
        
            
     
      SpringMVC
             
     
      org.springframework.web.servlet.DispatcherServlet
             
     
      1
         
        
            
     
      SpringMVC
             
     
      /
         
        
        
                
     
                      org.springframework.web.context.request.RequestContextListener            
             
         
        
            
     
      PageFilter
             
     
      com.ctc.Common.PageFilter
         
        
            
     
      PageFilter
             
     
      /*
         
    
   

sqlMapConfig.xml ：

User.java :

package com.ctc.Model;/** *  * @author Tency *  * Date 2016/11 */public class User {
       private int id;    private String userName;    private String passWord;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getUserName() {        return userName;    }    public void setUserName(String userName) {        this.userName = userName;    }    public String getPassWord() {        return passWord;    }    public void setPassWord(String passWord) {        this.passWord = passWord;    }    @Override    public String toString() {        return "User [id=" + id + ", userName=" + userName + ", passWord=" + passWord + "]";    }    @Override    public int hashCode() {        final int prime = 31;        int result = 1;        result = prime * result + id;        result = prime * result + ((passWord == null) ? 0 : passWord.hashCode());        result = prime * result + ((userName == null) ? 0 : userName.hashCode());        return result;    }    @Override    public boolean equals(Object obj) {        if (this == obj)            return true;        if (obj == null)            return false;        if (getClass() != obj.getClass())            return false;        User other = (User) obj;        if (id != other.id)            return false;        if (passWord == null) {            if (other.passWord != null)                return false;        } else if (!passWord.equals(other.passWord))            return false;        if (userName == null) {            if (other.userName != null)                return false;        } else if (!userName.equals(other.userName))            return false;        return true;    }}

UserMapper.java :

package com.ctc.Mapper;import java.util.List;import java.util.Map;import org.mybatis.spring.annotation.MapperScan;import com.ctc.Model.User;/** *  * @author Tency *  * Date 2016/12 */@MapperScanpublic interface UserMapper {
       List
   
     retrieve(String userName,String passWord);    void add(User user);    List
    
      retrieveAll(Map
     
       map);    int retrieveCount();    User load(int id);    void update(User user);    void delete(int id);}
     
    
   

UserMapper.xml ：

   
       
            select * from User where userName=#{0} and passWord=#{1}        
        select * from User limit #{offset},#{size}        
            select count(*) from User        
            select * from        User where id=#{id}        
    
             insert into User (userName,passWord) values (#{userName},#{passWord})    
        
    
             update User set userName=#{userName} , passWord=#{passWord} where id=#{id}    
        
    
             delete from User where id=#{id}    
    
   

UserServiceImpl.java :

package com.ctc.ServiceImpl;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.annotation.Resource;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpSession;import org.apache.ibatis.annotations.Param;import org.springframework.stereotype.Service;import org.springframework.web.context.request.RequestContextHolder;import org.springframework.web.context.request.ServletRequestAttributes;import com.ctc.Mapper.UserMapper;import com.ctc.Model.PageConstants;import com.ctc.Model.Pager;import com.ctc.Model.User;import com.ctc.Service.UserService;/** *  * @author Tency *  * Date 2016/11 */@Service("userServiceImpl")public class UserServiceImpl implements UserService {
       @Resource    private UserMapper userMapper;    HttpSession session;    HttpServletRequest request;    @Override    public List
   
     checkLogin(@Param("userName")String userName, @Param("passWord")String passWord) {        // TODO Auto-generated method stub        List
    
      list= userMapper.retrieve(userName, passWord);         request = ((ServletRequestAttributes)RequestContextHolder.getRequestAttributes()).getRequest();          session=request.getSession();        if(!list.isEmpty())        {            session.setAttribute("userName", list.get(0).getUserName());        }        return list;    }    @Override    public void addUser(User user) {        // TODO Auto-generated method stub        this.userMapper.add(user);    }    @Override    public User showUser(int id) {        // TODO Auto-generated method stub        return userMapper.load(id);    }    @Override    public void updateUser(User user) {        // TODO Auto-generated method stub        this.userMapper.update(user);        request = ((ServletRequestAttributes)RequestContextHolder.getRequestAttributes()).getRequest();         session=request.getSession();        session.setAttribute("userName", user.getUserName());    }    @Override    public void deleteUser(int id) {        // TODO Auto-generated method stub        this.userMapper.delete(id);    }    @Override    public Pager
     
       userList() {        // TODO Auto-generated method stub        Map
      
        map = new HashMap
       
        ();        Pager
        
          pager = new Pager
         
          (); int size = PageConstants.getSize(); int offset = PageConstants.getOffset(); map.put("size", size); map.put("offset", offset); pager.setDatas(userMapper.retrieveAll(map)); pager.setTotal(userMapper.retrieveCount()); return pager; }}
         
        
       
      
     
    
   

转载地址：https://blog.csdn.net/u010890358/article/details/54411011 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！