详解MyEclipse中搭建spring-boot+mybatis+freemarker框架

  4.0.0
  com.lm.spring-boot
  spring-boot
  0.0.1-SNAPSHOT
  
    UTF-8
  
  
    org.springframework.boot
    spring-boot-starter-parent
    1.3.0.RELEASE
  
  
    
      org.springframework.boot
      spring-boot-starter-web
    
    
    
      org.springframework.boot
      spring-boot-starter-freemarker
    
    
    
      org.springframework.boot
      spring-boot-starter-jdbc
    
    
    
      org.mybatis
      mybatis-spring
      1.2.2
    
    
      org.mybatis
      mybatis
      3.2.8
    
    
    
      mysql
      mysql-connector-java
    
  
  
    
      
        maven-compiler-plugin
        
          1.6
          1.6
        
      
      
        org.springframework.boot
        spring-boot-maven-plugin
        
          
            
              repackage
            
          
        
        
          
            org.springframework
            springloaded
            1.2.5.RELEASE
          
        
      
    
    
    spring-boot
  

package com.lm.application;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.tomcat.jdbc.pool.DataSource;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;

@EnableAutoConfiguration
@SpringBootApplication
@ComponentScan(basePackages={"com.lm"})//指定spring管理的bean所在的包
@MapperScan("com.lm.dao")//指定mybatis的mapper接口所在的包
public class Application{

  public static void main(String[] args) {
    SpringApplication.run(Application.class, args);
  }

  //创建数据源
  @Bean
  @ConfigurationProperties(prefix = "spring.datasource")//指定数据源的前缀 ,在application.properties文件中指定
  public DataSource dataSource() {
    return new DataSource();
  }

  //创建SqlSessionFactory
  @Bean
  public SqlSessionFactory sqlSessionFactoryBean() throws Exception {

    SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    sqlSessionFactoryBean.setDataSource(dataSource());

    PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();

    sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/*.xml"));

    return sqlSessionFactoryBean.getObject();
  }

  //创建事物管理器
  @Bean
  public PlatformTransactionManager transactionManager() {
    return new DataSourceTransactionManager(dataSource());
  }
}

#datasource
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/你的数据库名称?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
spring.datasource.username=数据库用户名
spring.datasource.password=数据库密码
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# FREEMARKER (FreeMarkerAutoConfiguration)
spring.freemarker.allow-request-override=false
spring.freemarker.allow-session-override=false
spring.freemarker.cache=true
spring.freemarker.charset=UTF-8
spring.freemarker.check-template-location=true
spring.freemarker.content-type=text/html
spring.freemarker.enabled=true
spring.freemarker.expose-request-attributes=false
spring.freemarker.expose-session-attributes=false
spring.freemarker.expose-spring-macro-helpers=true
spring.freemarker.prefer-file-system-access=true
spring.freemarker.suffix=.ftl
spring.freemarker.template-loader-path=classpath:/templates/
spring.freemarker.settings.template_update_delay=0
spring.freemarker.settings.default_encoding=UTF-8
spring.freemarker.settings.classic_compatible=true
spring.freemarker.order=1
#server
server.port=80

<?xml version="1.0" encoding="UTF-8"?>


 
  select id, username,password,email from t_user
 

package com.lm.controller;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import com.lm.model.User;
import com.lm.service.UserService;

@Controller
@RequestMapping("/user")
public class UserController {

  @Autowired
  private UserService userService;

  @RequestMapping("/list")
  public String list(ModelMap map){
    List userList=userService.findAll();
    map.addAttribute("userList", userList);
    return "/user/list";
  }
}

  
  


  
    <#list userList as user>
    

    

      
id
用户名
密码
邮箱
    

      
${user.id}
 
${user.username}
${user.password}
${user.email}
    
    
 

package com.lm.service;

import java.util.List;

import com.lm.model.User;

public interface UserService {

  List findAll();

}

package com.lm.service.impl;

import java.util.List;

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

import com.lm.dao.UserMapper;
import com.lm.model.User;
import com.lm.service.UserService;

@Service
public class UserServiceImpl implements UserService{

  @Autowired
  private UserMapper userMapper;

  @Override
  public List findAll() {
    return userMapper.findAll();
  }

}

package com.lm.dao;

import java.util.List;
import com.lm.model.User;

public interface UserMapper {

  List findAll();

}

package com.lm.model;

public class User {
  private Integer id;
  private String username;
  private String password;
  private String email;

  public Integer getId() {
    return id;
  }

  public void setId(Integer id) {
    this.id = id;
  }

  public String getUsername() {
    return username;
  }

  public String getEmail() {
    return email;
  }

  public void setEmail(String email) {
    this.email = email;
  }

  public void setUsername(String username) {
    this.username = username;
  }

  public String getPassword() {
    return password;
  }

  public void setPassword(String password) {
    this.password = password;
  }

}