SpringMVCWeb项目如何使用SpringBoot和Mybatis实现

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
 `id` int(11) NOT NULL,
 `name` varchar(255) DEFAULT NULL,
 `age` int(11) DEFAULT NULL,
 `password` varchar(255) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '7player', '18', '123456');

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

 4.0.0
 cn.7player.framework
 springboot-mybatis
 1.0-SNAPSHOT
 
 org.springframework.boot
 spring-boot-starter-parent
 1.2.5.RELEASE
 
 
 UTF-8
 1.7
 
 
 
  
 
  org.springframework.boot
  spring-boot-starter-web
 
 
 
  org.springframework.boot
  spring-boot-starter-thymeleaf
 
 
 
  org.springframework.boot
  spring-boot-starter-jdbc
 
 
 
  org.springframework.boot
  spring-boot-starter-actuator
 
 
 
  org.mybatis
  mybatis-spring
  1.2.2
 
 
  org.mybatis
  mybatis
  3.2.8
 
 
 
  org.apache.tomcat
  tomcat-jdbc
 
 
  mysql
  mysql-connector-java
 
 
 
  com.alibaba
  fastjson
  1.1.43
 
 
 
  com.mangofactory
  swagger-springmvc
  0.9.5
 
 
 
 
  
  org.springframework.boot
  spring-boot-maven-plugin
  
 
 
 
 
  spring-milestone
  https://repo.spring.io/libs-release
 
 
 
 
  spring-milestone
  https://repo.spring.io/libs-release
 
 

package cn.no7player;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.log4j.Logger;
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;
import javax.sql.DataSource;
@EnableAutoConfiguration
@SpringBootApplication
@ComponentScan
@MapperScan("cn.no7player.mapper")
public class Application {
 private static Logger logger = Logger.getLogger(Application.class);
 //DataSource配置
 @Bean
 @ConfigurationProperties(prefix="spring.datasource")
 public DataSource dataSource() {
 return new org.apache.tomcat.jdbc.pool.DataSource();
 }
 //提供SqlSeesion
 @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());
 }
 /**
 * Main Start
 */
 public static void main(String[] args) {
 SpringApplication.run(Application.class, args);
 logger.info("============= SpringBoot Start Success =============");
 }
}

package cn.no7player.controller;
import org.apache.log4j.Logger;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
@Controller
public class HelloController {
 private Logger logger = Logger.getLogger(HelloController.class);
 /*
 * http://localhost:8080/hello?name=cn.7player
 */
 @RequestMapping("/hello")
 public String greeting(@RequestParam(value="name", required=false, defaultValue="World") String name, Model model) {
 logger.info("hello");
 model.addAttribute("name", name);
 return "hello";
 }
}

package cn.no7player.controller;
import cn.no7player.model.User;
import cn.no7player.service.UserService;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
@Controller
public class UserController {
 private Logger logger = Logger.getLogger(UserController.class);
 @Autowired
 private UserService userService;
 /*
 * http://localhost:8080/getUserInfo
 */
 @RequestMapping("/getUserInfo")
 @ResponseBody
 public User getUserInfo() {
 User user = userService.getUserInfo();
 if(user!=null){
  System.out.println("user.getName():"+user.getName());
  logger.info("user.getAge():"+user.getAge());
 }
 return user;
 }
}

package cn.no7player.controller;
import cn.no7player.model.User;
import com.wordnik.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import java.util.ArrayList;
import java.util.List;
@RestController
@RequestMapping(value="/users")
public class SwaggerController {
 /*
 * http://localhost:8080/swagger/index.html
 */
 @ApiOperation(value="Get all users",notes="requires noting")
 @RequestMapping(method=RequestMethod.GET)
 public List getUsers(){
 List list=new ArrayList();
 User user=new User();
 user.setName("hello");
 list.add(user);
 User user2=new User();
 user.setName("world");
 list.add(user2);
 return list;
 }
 @ApiOperation(value="Get user with id",notes="requires the id of user")
 @RequestMapping(value="/{name}",method=RequestMethod.GET)
 public User getUserById(@PathVariable String name){
 User user=new User();
 user.setName("hello world");
 return user;
 }
}

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

@ConfigurationProperties(prefix=“spring.datasource”) 

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


 
 select name, age,password from user;
 

package cn.no7player.mapper;
import cn.no7player.model.User;
public interface UserMapper {
 public User findUserInfo();
}