SpringBoot整合Mybatis(CRUD的实现) - Win

TOP

SpringBoot整合Mybatis(CRUD的实现)(二)

2019-09-06 00:26:39 【大中小】浏览:125次

pring.datasource.username=root 13 spring.datasource.password=123456 14 spring.datasource.driver-class-name=com.mysql.jdbc.Driver application.properties

3.在Springboot启动类添加@MapperScan注解

 1 package com.beilin;
 2 
 3 import org.mybatis.spring.annotation.MapperScan;
 4 import org.springframework.boot.SpringApplication;
 5 import org.springframework.boot.autoconfigure.SpringBootApplication;
 6 
 7 @MapperScan(value = "com.beilin.mapper")
 8 @SpringBootApplication
 9 public class SpringbootApplication {
10 
11     public static void main(String[] args) {
12         SpringApplication.run(SpringbootApplication.class, args);
13     }
14 
15 }

SpringbootApplication

四、代码实现

1.实体类User

 1 package com.beilin.entity;
 2 
 3 public class User {
 4     /**
 5      *  name:学生实体
 6      */
 7 
 8     //主键id
 9     private int id;
10     //姓名
11     private String name;
12     //年龄
13     private int age;
14 
15     // Get和 Set方法
16     public int getId() {
17         return id;
18     }
19 
20     public void setId(int id) {
21         this.id = id;
22     }
23 
24     public String getName() {
25         return name;
26     }
27 
28     public void setName(String name) {
29         this.name = name;
30     }
31 
32     public int getAge() {
33         return age;
34     }
35 
36     public void setAge(int age) {
37         this.age = age;
38     }
39 }

User.java

2.数据操作层UserMapper

 1 package com.beilin.mapper;
 2 
 3 import com.beilin.entity.User;
 4 
 5 import java.util.List;
 6 
 7 public interface UserMapper {
 8 
 9      //插入
10     public void insert(User user);
11 
12     //根据id删除
13     public void delete(Integer id);
14 
15      //根据user的id修改
16     public void update(User user);
17 
18     //根据id查询
19     public User getById(Integer id);
20 
21     //查询全部
22     public List<User> list();
23 
24 }

UserMapper.java

3.UserMapper映射文件

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 3 <mapper namespace="com.beilin.mapper.UserMapper">
 4 
 5     <!-- 插入一个user -->
 6     <insert id="insert" parameterType="user">
 7     insert into user(name,age) values(#{name},#{age})
 8     </insert>
 9 
10     <!-- 根据id删除学生 -->
11     <delete id="delete" parameterType="int">
12     delete  from user where id=#{id}
13     </delete>
14 
15     <!-- 根据id修改学生信息 -->
16     <update id="update" parameterType="user">
17     update user set name=#{name},age=#{age} where id=#{id}
18     </update>
19 
20     <!-- 根据id查询 -->
21     <select id="getById" parameterType="int" resultType="user">
22     select * from user where id=#{id}
23     </select>
24 
25     <!-- 查询所有 -->
26     <select id="list" parameterType="int" resultType="user">
27     select * from user
28     </select>
29 
30 </mapper>

UserMapper.xml

4.控制层UserController

 1 package com.beilin.controller;
 2 
 3 import com.beilin.entity.User;
 4 import com.beilin.mapper.UserMapper;
 5 import org.springframework.beans.factory.annotation.Autowired;
 6 import org.springframework.web.bind.annotation.*;
 7 
 8 import java.util.List;
 9 
10 @RestControlle

首页上一页 1 2 3 下一页尾页 2/3/3
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】

上一篇：什么是SEO？SEO能做什么！	下一篇：IIS 程序池优化配置方案