办公用品网站建设市场定位,有一个网站叫浪什么,太原线上推广公司,成都必去的10个景点springbootmybatis连接数据库实现增删改查功能创建表创建项目实体类DAO接口写sql的XML文件Service层Controller启动类结果目录结构参考博客创建表
create table user(id int ,name varchar(30),pwd varchar(40)
)insert into user values(2,hxf,789101),(3,hlm,789102),(4,hzh…
springbootmybatis连接数据库实现增删改查功能创建表创建项目实体类DAO接口写sql的XML文件Service层Controller启动类结果目录结构参考博客创建表
create table user(id int ,name varchar(30),pwd varchar(40)
)insert into user values(2,hxf,789101),(3,hlm,789102),(4,hzh,789103),(1,hy,789110)现在的表内容
目标的内容 创建项目 我的POM文件依赖
dependencies!--mysql--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.18/version/dependency!--druid连接池--dependencygroupIdcom.alibaba/groupIdartifactIddruid/artifactIdversion1.1.22/version/dependency!--mybatis--dependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion2.1.4/version/dependencydependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.6/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.16.18/versionscopeprovided/scope/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency/dependencies
yml文件
server:port: 8080
spring:datasource:username: rootpassword: 5****6url: jdbc:mysql://localhost:3306/test?serverTimezoneUTCuseUnicodetruecharacterEncodingutf8driver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSource
mybatis:# mapper文件mapper-locations: dao/*Dao.xml实体类
package com.example.demo.vo;import lombok.AllArgsConstructor;
import lombok.Data;Data
AllArgsConstructor
public class User {private int id;private String name;private String pwd;
}
DAO接口
package com.example.demo.dao;
import com.example.demo.vo.User;
import java.util.List;
public interface UserDao {public ListUser selectUser();int insertUser(User user);int deleteUser(String name);int updateUser(String name);
}
写sql的XML文件
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.example.demo.dao.UserDaoinsert idinsertUser parameterTypecom.example.demo.vo.Userinsert into user values(#{id},#{name},#{pwd})/insertupdate idupdateUser parameterTypestringupdate user set pwd 789100 where NAME hy/updatedelete iddeleteUser parameterTypestringdelete from user where name #{name}/deleteselect idselectUser resultTypecom.example.demo.vo.UserSELECT * FROM user order by pwd/select
/mapper
Service层
package com.example.demo.service;
import com.example.demo.dao.UserDao;
import com.example.demo.vo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;Service
public class UserService {Autowiredprivate UserDao userDao;public ListUser selectUser() {return userDao.selectUser();}public void addUser(User user){userDao.insertUser(user);}public void deleteUser(String name){userDao.deleteUser(name);}public void updateUser(String name){userDao.updateUser(name);}
}
Controller
package com.example.demo.controller;import com.example.demo.service.UserService;
import com.example.demo.vo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.Iterator;
import java.util.List;RestController
RequestMapping(/test)
public class UserController {Autowired(required false)private UserService userService;GetMapping(/query)public String query(){String result;ListUser userList userService.selectUser();IteratorUser iterator userList.iterator();while(iterator.hasNext()){User next iterator.next();result next.toString();}return result;// for (User user : usersList) {
// result user.toString();
// }
// return result;}GetMapping(/add)public String addUser(){userService.addUser(new User(5,hss,789104));return add ok;}GetMapping(/delete)public String deleteUser(){userService.deleteUser(hzb);return delete ok;}GetMapping(/update)public String updateUser(){userService.updateUser(hy);return update ok;}
}
启动类
package com.example.demo;import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplication
MapperScan(com.example.demo.dao)
public class DemoApplication {public static void main(String[] args) {SpringApplication.run(DemoApplication.class, args);}
}
结果
用postman查询localhost:8080/test/query 添加localhost:8080/test/add 删除:localhost:8080/test/delete 修改:localhost:8080/test/update 最终结果localhost:8080/test/query
目录结构 参考博客
项目创建: https://blog.csdn.net/wshjk/article/details/123879847
查询SpringbootMybatis的查询demo: https://blog.csdn.net/dkm123456/article/details/123029848
增删改参考: https://blog.csdn.net/m0_57060979/article/details/124567138
本文是学习记录博主还是菜鸡一个不足之处还望大佬指出。
