springboot-集成mybatis

springboot集成mybatis

首先application.properties:

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


spring.datasource.url=jdbc:mysql://127.0.0.1:3306/vedio?useSSL=true&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=helloanlysqx
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

pom.xml:

<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.anlysqx</groupId>
  <artifactId>springboot-jsp</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>1.5.6.RELEASE</version>
  </parent>
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		
		<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-tomcat</artifactId>
		</dependency>
		<dependency>
		    <groupId>org.apache.tomcat.embed</groupId>
		    <artifactId>tomcat-embed-jasper</artifactId>
		</dependency>
		
		<dependency>
		    <groupId>mysql</groupId>
		    <artifactId>mysql-connector-java</artifactId>
		    <version>8.0.14</version>
		</dependency>

		
		<dependency>
		    <groupId>org.mybatis.spring.boot</groupId>
		    <artifactId>mybatis-spring-boot-starter</artifactId>
		    <version>2.0.1</version>
		</dependency>
		
		
		
	</dependencies>
	
	
  
</project>

App.java

package com.anlysqx.app;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.ComponentScan;

@EnableAutoConfiguration
@ComponentScan(basePackages={"com.anlysqx.controller"})
@MapperScan(basePackages={"com.anlysqx.dao"})
public class App {
	public static void main(String[] args) {
		SpringApplication.run(App.class, args);
	}
}

dao层mapper.java

package com.anlysqx.dao;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.anlysqx.entity.User;

@Mapper
public interface UserMapper {
	
	@Select("select * from user where uname = #{uname}")
	public List<User> getUserByName(String uname);
	
	@Insert("insert into user (uname,age,password) values (#{uname},#{age},#{password})")
	public void insertOneUser(User user);
}

controller层

package com.anlysqx.controller;

import java.util.List;

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;

import com.anlysqx.dao.UserMapper;
import com.anlysqx.entity.User;

@Controller
public class MybatisController {
	@Autowired
	private UserMapper userMapper;
	
	@ResponseBody
	@RequestMapping("/getuser")
	public List<User> getOneUserByName(){
		return userMapper.getUserByName("燎原");
	}
	
}

entity层

package com.anlysqx.entity;

public class User {
	
	private Integer id;
	private String uname;
	private Integer age;
	private String password;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUname() {
		return uname;
	}
	public void setUname(String uname) {
		this.uname = uname;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public User(Integer id, String uname, Integer age, String password) {
		super();
		this.id = id;
		this.uname = uname;
		this.age = age;
		this.password = password;
	}
	public User() {
		super();
		// TODO Auto-generated constructor stub
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", uname=" + uname + ", age=" + age + ", password=" + password + "]";
	}
	
	
	
}