springboot+mybatis+springmvc整合实例

库名为 springboot

    CREATE TABLE `t_user` (  
      `id` INT(11) NOT NULL,`username` VARCHAR(255) DEFAULT NULL,`password` VARCHAR(255) DEFAULT NULL,`email` VARCHAR(255) DEFAULT NULL,`useable` INT(20) DEFAULT NULL,`addtime` DATETIME DEFAULT NULL,`logintime` DATETIME DEFAULT NULL,`loginip` VARCHAR(255) DEFAULT NULL,PRIMARY KEY  (`id`)  
    ) ENGINE=INNODB DEFAULT CHARSET=utf8;  

spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
spring.datasource.username=root
spring.datasource.password=1234
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.view.prefix=/WEB-INF/templates/
spring.view.suffix=.jsp

    package com.sam.project.mvc.model;  
      
    /**  
     * @ClassName: User  
     * @Description: 实体模型  
     */  
    public class User {  
        private Integer id;  
      
         String username;  
      
         String password;  
      
         String email;  
      
          
         * 是否可用(0禁用,1可用)  
         */  
         Integer useable;  
      
          
         * 创建时间  
          String addtime;  
      
          
         * 登陆时间  
          String logintime;  
      
          
         * 登陆IP  
          String loginip;  
      
          
         * @return id  
         public Integer getId() {  
            return id;  
        }  
      
        @paramvoid setId(Integer id) {  
            this.id = username  
          String getUsername() {  
             username;  
        }  
      
         setUsername(String username) {  
            this.username = password  
          String getPassword() {  
             password;  
        }  
      
         setPassword(String password) {  
            this.password = email  
          String getEmail() {  
             email;  
        }  
      
         setEmail(String email) {  
            this.email =  
         * 获取是否可用(0禁用,1可用)  
         *  
         *  useable - 是否可用(0禁用,1)"> Integer getUseable() {  
             useable;  
        }  
      
          
         * 设置是否可用(0禁用,1)"> useable  
         *            是否可用(0禁用,1)"> setUseable(Integer useable) {  
            this.useable =  
         * 获取创建时间  
         *  
         *  addtime - 创建时间  
          String getAddtime() {  
             addtime;  
        }  
      
          
         * 设置创建时间  
         *  
         *  addtime  
         *            创建时间  
          setAddtime(String addtime) {  
            this.addtime =  
         * 获取登陆时间  
         *  
         *  logintime - 登陆时间  
          String getLogintime() {  
             logintime;  
        }  
      
          
         * 设置登陆时间  
         *  
         *  logintime  
         *            登陆时间  
          setLogintime(String logintime) {  
            this.logintime =  
         * 获取登陆IP  
         *  
         *  loginip - 登陆IP  
          String getLoginip() {  
             loginip;  
        }  
      
          
         * 设置登陆IP  
         *  
         *  loginip  
         *            登陆IP  
          setLoginip(String loginip) {  
            this.loginip = loginip;  
        }  
    }  

 com.sam.project.mvc.mapper;  
  
import java.util.List;  
  
 com.sam.project.mvc.model.User;  
  
  
 * @ClassName: UserMapper   
 * @Description: mybites数据查询接口  
 */  
interface UserMapper {  
  
    List<User> queryList();  
  
     save(User user);  
  
     batchDelete(Integer[] ids);  
  
     update(User user);  
  
} 

<?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.sam.project.mvc.mapper.UserMapper">  
        select id="queryList" resultType="com.sam.project.mvc.model.User">  
            SELECT u.id,u.username,u.password,u.email,u.useable,u.addtime,u.logintime,u.loginip FROM t_user u  
        </select>  
          
        ="queryById"insert ="save"  
            insert into t_user(username,password,email,useable,addtime)  
            values(#{username},#{password},#{email},#{useable},now())  
        insertupdate ="update"  
            update t_user set password = #{password},email = #{email},useable = #{useable} where id = #{id}  
        updatedelete ="batchDelete"  
            delete from t_user where id in  
            foreach collection="array" item="item" open="(" separator="," close=")"  
                #{item}  
            foreachdelete<!-- <delete id="delUsers">  
            delete from t_user where id in  
            <foreach collection="list" item="item" open="(" separator="," close=")">  
                #{item}  
            </foreach>  
        </delete> -->  
    mapper>  

 com.sam.project.mvc.service;  
      
     java.util.List;

 org.springframework.beans.factory.annotation.Autowired;
 org.springframework.stereotype.Service;

 com.sam.project.mvc.common.AjaxResult;
 com.sam.project.mvc.mapper.UserMapper;
 com.sam.project.mvc.model.User;  
      
    @Service  
     UserService {  
      
        @Autowired  
         UserMapper userMapper;  
          
         AjaxResult queryList() {  
            List<User> list = userMapper.queryList();  
            return new AjaxResult(list);  
        }  
      
         AjaxResult save(User user) {  
            user.setUsername("user" + System.currentTimeMillis());  
            user.setPassword("123456");  
            user.setEmail("user" + System.currentTimeMillis());  
            user.setUseable(1);  
            userMapper.save(user);  
             AjaxResult();  
        }  
      
         AjaxResult batchDelete(Integer[] ids) {  
            userMapper.batchDelete(ids);  
             AjaxResult update(User user) {  
            userMapper.update(user);  
             AjaxResult();  
        }  
      
    }  

     com.sam.project.mvc.controller;  
      
     org.springframework.stereotype.Controller;
 org.springframework.ui.ModelMap;
 org.springframework.web.bind.annotation.RequestMapping;
 org.springframework.web.bind.annotation.ResponseBody;

 com.sam.project.mvc.model.User;
 com.sam.project.mvc.service.UserService;  
      
      
     * @ClassName: UserController   
     * @Description: 用户Controller  
     */  
    @Controller  
     UserController {  
      
        @Autowired  
         UserService userService;  
          
        @ResponseBody  
        @RequestMapping("/queryList")  
         AjaxResult queryList(){  
             userService.queryList();  
        }  
      
        @ResponseBody  
        @RequestMapping("/addUser" AjaxResult addUser(User user){  
             userService.save(user);  
        }  
          
        @ResponseBody  
        @RequestMapping("/delUser")   
         AjaxResult delUser(Integer[] ids){  
             userService.batchDelete(ids);  
        }  
          
        @ResponseBody  
        @RequestMapping("/updateUser" AjaxResult updateUser(User user){  
             userService.update(user);  
        }  
        
        @RequestMapping("/hello")
         String hello(ModelMap map) {
            map.put("title","你好");
            return "index";
        }
      
    }  

     com.sam.project.mvc.common;  
      
      
     * @ClassName: AjaxResult   
     * @Description: 封装返回数据  
      AjaxResult {  
      
        private int retcode = 1;  
        private String retmsg = "操作成功" Object data;  
          
        public AjaxResult(int retcode,String retmsg,Object data){  
            this.retcode = retcode;  
            this.retmsg = retmsg;  
            this.data = data;  
        }  
          
         retmsg;  
        }  
          
         AjaxResult(Object data){  
            this.retmsg = "查询成功";  
             retcode){  
            this.retmsg = "操作失败";  
        }  
          
         AjaxResult(String retmsg){  
            this.retcode = 0 AjaxResult(){  
              
        }  
      
         getRetcode() {  
             retcode;  
        }  
        void setRetcode( retcode) {  
             String getRetmsg() {  
             retmsg;  
        }  
         setRetmsg(String retmsg) {  
             Object getData() {  
             data;  
        }  
         setData(Object data) {  
             data;  
        }  
      
        @Override  
         String toString() {  
            return "AjaxResult [retcode=" + retcode + ",retmsg=" + retmsg + ",data=" + data + "]";  
        }  
          
    }  

 com.sam.project.mvc;
 
 javax.sql.DataSource;

 org.apache.ibatis.session.SqlSessionFactory;
 org.apache.log4j.Logger;
 org.mybatis.spring.SqlSessionFactoryBean;
 org.mybatis.spring.annotation.MapperScan;
 org.springframework.boot.SpringApplication;
 org.springframework.boot.autoconfigure.EnableAutoConfiguration;
 org.springframework.boot.autoconfigure.SpringBootApplication;
 org.springframework.boot.builder.SpringApplicationBuilder;
 org.springframework.boot.context.properties.ConfigurationProperties;
 org.springframework.boot.context.web.SpringBootServletInitializer;
 org.springframework.context.annotation.Bean;
 org.springframework.context.annotation.ComponentScan;
 org.springframework.core.io.support.PathMatchingResourcePatternResolver;
 org.springframework.jdbc.datasource.DataSourceTransactionManager;
 org.springframework.transaction.PlatformTransactionManager;
 
@EnableAutoConfiguration
@SpringBootApplication
@ComponentScan
@MapperScan("com.sam.project.mvc.mapper")
class Application extends SpringBootServletInitializer {
    static Logger logger = Logger.getLogger(Application.);
 
    //DataSource配置
    @Bean
    @ConfigurationProperties(prefix="spring.datasource")
     DataSource dataSource() {
         org.apache.tomcat.jdbc.pool.DataSource();
    }
 
    提供SqlSeesion
    @Bean
    public SqlSessionFactory sqlSessionFactoryBean() throws Exception {
 
        SqlSessionFactoryBean sqlSessionFactoryBean =  SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());
 
        PathMatchingResourcePatternResolver resolver =  PathMatchingResourcePatternResolver();
 
        sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mapper/*.xml"));
 
         sqlSessionFactoryBean.getObject();
    }
 
    @Bean
     PlatformTransactionManager transactionManager() {
         DataSourceTransactionManager(dataSource());
    }
 
    @Override
    protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {
        return application.sources(Application.);
    }
    
     * Main Start
     */
    static  main(String[] args) {
        SpringApplication.run(Application.,args);
        logger.info("============= SpringBoot Start Success =============");
    }
 
}

<%@ page language="java contentTypetext/html; charset=UTF-8
    pageEncodingUTF-8"%>
DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
htmlheadmeta http-equiv="Content-Type" content="text/html; charset=UTF-8"title>你好body
${title }
>