SpringBoot+Mybatis的简单实例

最新推荐文章于 2020-07-12 16:45:26 发布

原创最新推荐文章于 2020-07-12 16:45:26 发布 · 239 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #springboot #入门

java 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中集成MyBatis，包括实体类定义、DAO层实现、Service层设计以及Controller层接口开发。通过具体代码示例，展示了用户增删改查操作的实现过程。

1.首先是程序的结构

2.User实体类

package com.example.demo.entity;

import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="user")
public class User implements Serializable {
	
	private static final long serialVersionUID = 1L;
	@Id
    @Column(name="id")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
	private int id;   
    @Column(name="name")
	private String name;
    @Column(name="sex")
	private String sex;
    @Column(name="age")
    private int age;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", sex=" + sex + "]";
	}
	
	
}

3.DemoApplication.java

@SpringBootApplication()
@MapperScan("com.example.demo.dao")
public class DemoApplication extends SpringBootServletInitializer {

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

4.Controller.java

@RestController
@RequestMapping("/test")
public class Controller {
	 @Resource
	private IUserService userService;
    
	//通过名字查询
	@GetMapping("/findUserByName")
	public List<User> findUserByName(String name){
		List<User> list=userService.findUserByName(name);
		return list;
	}
        //通过ID查询
	@GetMapping("/findUserById")
	public User findUserById(int id){
		User user=userService.findUserById(id);
		return user;
	}
        //通过ID删除
	@GetMapping("/deleteUser")
	public void deleteUser(int id){
		userService.deleteUser(id);
	}
       //修改
	@PostMapping("/updateUser")
	public void updateUser(User user){
		userService.updateUser(user);
	}
       //添加
	@PostMapping("/insertUser")
	public void insertUser(User user){
		userService.insertUser(user);
	}
	
	
	
}

5.Dao层

public interface IUserDao  {
	 List<User> findUserByName(String name);
	 User findUserById(int id);
	 void insertUser(User user);
	 void deleteUser(int id);
     void updateUser(User user);

}

6.service层

public interface IUserService {
		List<User> findUserByName(String name);
		User findUserById(int id);
		void insertUser(User user);
	    void deleteUser(int id);
		void updateUser(User user);
}

7.serviceImpl层

@Service("userService")
public class UserServiceImpl  implements IUserService {
    
	@Resource
	private IUserDao userDao;
	
    @Override
	public List<User> findUserByName(String name) {
		// TODO Auto-generated method stub
		return userDao.findUserByName(name); 
	}

	@Override
	public User findUserById(int id) {
		// TODO Auto-generated method stub
		return userDao.findUserById(id);
	}

	@Override
	public void insertUser(User user) {
		userDao.insertUser(user);
		
	}

	@Override
	public void deleteUser(int id) {
		userDao.deleteUser(id);
		
	}

	@Override
	public void updateUser(User user) {
		userDao.updateUser(user);
		
	}
	
	

}

8.mapper.xml

<?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.example.demo.dao.IUserDao" >

     <select id="findUserByName" parameterType="java.lang.String" resultType="com.example.demo.entity.User">
		SELECT * FROM user WHERE name like '%${value}%'
	</select>
	<select id="findUserById" parameterType="int" resultType="com.example.demo.entity.User">
		SELECT * FROM user WHERE id =#{value}
	</select>
	<insert id="insertUser" parameterType="User">
	   insert into user (id,name,sex)value(#{id},#{name},#{sex})
	</insert>
	<update id="updateUser" parameterType="com.example.demo.entity.User">
	   update user set name=#{name},sex=#{sex} where id=#{id}
	</update>
	<delete id="deleteUser" parameterType="java.lang.Integer">
	   delete from user where id=#{id}
	</delete>
	</mapper>

9.application.yml

#默认使用配置
spring:
  profiles:
    active: dev

#公共配置与profiles选择无关
mybatis:
  typeAliasesPackage: com.example.demo.entity
  mapperLocations: classpath:mapper/*.xml


---

#开发配置
spring:
  profiles: dev

  datasource:
    url: jdbc:mysql://localhost:3306/test?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf8&useSSL=true&serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

10.maven依赖

<?xml version="1.0" encoding="UTF-8"?>
<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.example</groupId>
	<artifactId>demo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>demo</name>
	<description>Demo project for Spring Boot</description>
 
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.0.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	
	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>
	
<repositories>
        <repository>
            <id>aliyun nexus maven</id>
            <url>http://maven.aliyun.com/nexus/content/groups/public/</url>
        </repository>
    </repositories>
    
	<dependencies>
		<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>


        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>




</project>

然后就可以用接口测试了

其中要注意Dao层要和mapper中的名字相同。

希望这些对你能有所帮助。