springboot 入门 您所在的位置:网站首页 mapper和mapperscan springboot 入门

springboot 入门

#springboot 入门| 来源: 网络整理| 查看: 265

新建springboot项目

2. 3. pom.xml

4.0.0 org.springframework.boot spring-boot-starter-parent 2.7.10 com.example demo7 0.0.1-SNAPSHOT demo7 Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-jdbc org.springframework.boot spring-boot-starter-web com.alibaba druid-spring-boot-starter 1.1.10 org.mybatis.spring.boot mybatis-spring-boot-starter 2.3.0 mysql mysql-connector-java 5.1.46 org.springframework.boot spring-boot-starter-test test junit junit test org.springframework.boot spring-boot-maven-plugin 配置文件 application.properties mybatis.config-location=classpath:mybatis/mybatis-config.xml mybatis.mapper-locations=classpath:mybatis/mapper/*.xml mybatis.type-aliases-package=com.example.demo7.model spring.datasource.url=jdbc:mysql://localhost:3306/springboot?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true spring.datasource.username=root spring.datasource.password=root #spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.driver-class-name=com.mysql.jdbc.Driver 项目结构 mybatis-config.xml UserMapper.xml id, userName, passWord, user_sex, nick_name SELECT FROM users SELECT FROM users WHERE id = #{id} INSERT INTO users (userName,passWord,user_sex) VALUES (#{userName}, #{passWord}, #{userSex}) UPDATE users SET userName = #{userName}, passWord = #{passWord}, nick_name = #{nickName} WHERE id = #{id} DELETE FROM users WHERE id =#{id} demo7-model-User.java package com.example.demo7.model; import com.example.demo7.enums.UserSexEnum; import java.io.Serializable; public class User implements Serializable { private static final long serialVersionUID = 1L; private Long id; private String userName; private String passWord; private UserSexEnum userSex; private String nickName; public User() { super(); } public User(String userName, String passWord, UserSexEnum userSex) { super(); this.passWord = passWord; this.userName = userName; this.userSex = userSex; } public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getPassWord() { return passWord; } public void setPassWord(String passWord) { this.passWord = passWord; } public UserSexEnum getUserSex() { return userSex; } public void setUserSex(UserSexEnum userSex) { this.userSex = userSex; } public String getNickName() { return nickName; } public void setNickName(String nickName) { this.nickName = nickName; } @Override public String toString() { // TODO Auto-generated method stub return "userName " + this.userName + ", pasword " + this.passWord + "sex " + userSex.name(); } } demo7-mapper-UserMapper.java package com.example.demo7.mapper; import com.example.demo7.model.User; import java.util.List; public interface UserMapper { List getAll(); User getOne(Long id); void insert(User user); void update(User user); void delete(Long id); } demo7-web-UserController.java package com.example.demo7.web; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import com.example.demo7.model.User; import com.example.demo7.mapper.UserMapper; @RestController public class UserController { @Autowired(required = false) private UserMapper userMapper; @RequestMapping("/he") public String hello(){ return "he"; } @RequestMapping("/getUsers") public List getUsers() { List users=userMapper.getAll(); return users; } @RequestMapping("/getUser") public User getUser(Long id) { User user=userMapper.getOne(id); return user; } @RequestMapping("/add") public void save(User user) { userMapper.insert(user); } @RequestMapping(value="update") public void update(User user) { userMapper.update(user); } @RequestMapping(value="/delete/{id}") public void delete(@PathVariable("id") Long id) { userMapper.delete(id); } } demo7-enums-UserSexEnum.java package com.example.demo7.enums; public enum UserSexEnum { MAN, WOMAN } Demo7Application package com.example.demo7; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication @MapperScan("com.example.demo7.mapper") public class Demo7Application { public static void main(String[] args) { SpringApplication.run(Demo7Application.class, args); } } resources-mybatis-mapper-UserMapper.xml id, userName, passWord, user_sex, nick_name SELECT FROM users SELECT FROM users WHERE id = #{id} INSERT INTO users (userName,passWord,user_sex) VALUES (#{userName}, #{passWord}, #{userSex}) UPDATE users SET userName = #{userName}, passWord = #{passWord}, nick_name = #{nickName} WHERE id = #{id} DELETE FROM users WHERE id =#{id} 运行项目 请求接口测试效果 http://localhost:8080/he 返回 “he” http://localhost:8080/getUsers

[{"id":1,"userName":"aa1","passWord":"a123456","userSex":"MAN","nickName":"pt"}]

http://localhost:8080/getUser

{ "id": 1, "userName": "aa1", "passWord": "a123456", "userSex": "MAN", "nickName": "pt" }

http://localhost:8080/add

请求参数: userName:bb1 passWord:b123456 userSex:WOMAN nickName:je 返回数据:

原文地址:https://www.cnblogs.com/jigr/p/17265673.html



【本文地址】

公司简介

联系我们

今日新闻

    推荐新闻

    专题文章
      CopyRight 2018-2019 实验室设备网 版权所有