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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>com.lm.spring-boot</groupId>  <artifactId>spring-boot</artifactId>  <version>0.0.1-SNAPSHOT</version>  <properties>    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>  </properties>  <parent>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-parent</artifactId>    <version>1.3.0.RELEASE</version>  </parent>  <dependencies>    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-web</artifactId>    </dependency>    <!--视图采用freemarker渲染 -->    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-freemarker</artifactId>    </dependency>    <!-- JDBC -->    <dependency>      <groupId>org.springframework.boot</groupId>      <artifactId>spring-boot-starter-jdbc</artifactId>    </dependency>    <!-- mybatis -->    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis-spring</artifactId>      <version>1.2.2</version>    </dependency>    <dependency>      <groupId>org.mybatis</groupId>      <artifactId>mybatis</artifactId>      <version>3.2.8</version>    </dependency>    <!-- mysql -->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>    </dependency>  </dependencies>  <build>    <plugins>      <plugin>        <artifactId>maven-compiler-plugin</artifactId>        <configuration>          <source>1.6</source>          <target>1.6</target>        </configuration>      </plugin>      <plugin>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-maven-plugin</artifactId>        <executions>          <execution>            <goals>              <goal>repackage</goal>            </goals>          </execution>        </executions>        <dependencies>          <dependency>            <groupId>org.springframework</groupId>            <artifactId>springloaded</artifactId>            <version>1.2.5.RELEASE</version>          </dependency>        </dependencies>      </plugin>    </plugins>    <!-- 指定最终生成jar包的文件名-->    <finalName>spring-boot</finalName>  </build></project>

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());  }}

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

<?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.lm.dao.UserMapper"> <select id="findAll" resultType="com.lm.model.User" parameterType="java.lang.String">  select id, username,password,email from t_user </select></mapper>

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<User> userList=userService.findAll();    map.addAttribute("userList", userList);    return "/user/list";  }}

<!DOCTYPE html><html lang="en"><head>  <meta charset="UTF-8">  <title>用户列表</title></head><body>  <table>    <tr>      <th>id</th><th>用户名</th><th>密码</th><th>邮箱</th>    </tr>    <#list userList as user>    <tr>      <td>${user.id}</td> <td>${user.username}</td><td>${user.password}</td><td>${user.email}</td>    </tr>    </#list> </table></body></html>

package com.lm.service;import java.util.List;import com.lm.model.User;public interface UserService {  List<User> 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;@Servicepublic class UserServiceImpl implements UserService{  @Autowired  private UserMapper userMapper;  @Override  public List<User> findAll() {    return userMapper.findAll();  }}

package com.lm.dao;import java.util.List;import com.lm.model.User;public interface UserMapper {  List<User> 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;  }}