网站后台管理系统摘要怎么写,wordpress 应用商店,大连凯杰建设有限公司网站,网站建设it前言
学习SpringBoot整合mybatis mysql配置#xff0c;首先需要了解什么是ORM(对象映射关系)框架#xff0c;ORM#xff08;Object Relational Mapping#xff09;对象关系映射#xff0c;是 一种为了解决面向对象与关系型数据库不匹配而出现的技术#xff0c;使开发者…前言
学习SpringBoot整合mybatis mysql配置首先需要了解什么是ORM(对象映射关系)框架ORMObject Relational Mapping对象关系映射是 一种为了解决面向对象与关系型数据库不匹配而出现的技术使开发者能够用面向对象的方式使用关系型数据库。
学习配置
建表
CREATE TABLE sys_user (id int NOT NULL AUTO_INCREMENT COMMENT 主键,name varchar(100) DEFAULT NULL COMMENT 用户名,password varchar(255) DEFAULT NULL COMMENT 密码,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8mb3;创建一个简单的用户信息表来作为数据库操作基础。
pom配置
dependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-web/artifactId/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-jdbc/artifactId/dependencydependencygroupIdorg.mybatis.spring.boot/groupIdartifactIdmybatis-spring-boot-starter/artifactIdversion2.2.0/version/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-devtools/artifactIdscoperuntime/scopeoptionaltrue/optional/dependencydependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdscoperuntime/scope/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependencydependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/scope/dependency
/dependenciesCRUD
简单的编写一下java代码来完成数据库的操作方法
domain(java-数据库映射实体)
import lombok.Data;
import java.io.Serializable;/*** author yanzy* date 2021/6/15 21:52* since v1.0*/
Data
public class SysUser implements Serializable {private Long id;private String name;private String password;
}mapper(数据库操作接口)
import com.zy.study.domain.SysUser;/*** author Yanzy*/
public interface SysUserMapper {int deleteByPrimaryKey(Long id);int insert(SysUser record);int insertSelective(SysUser record);SysUser selectByPrimaryKey(Long id);int updateByPrimaryKeySelective(SysUser record);int updateByPrimaryKey(SysUser record);
}service (业务接口 和 业务接口实现)
import com.zy.study.domain.SysUser;/*** author yanzy* date 2021/6/15 21:53* since v1.0*/
public interface SysUserService {int deleteByPrimaryKey(Long id);int insert(SysUser record);int insertSelective(SysUser record);SysUser selectByPrimaryKey(Long id);int updateByPrimaryKeySelective(SysUser record);int updateByPrimaryKey(SysUser record);
}import com.zy.study.domain.SysUser;
import com.zy.study.mapper.SysUserMapper;
import com.zy.study.service.SysUserService;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;/*** author yanzy* date 2021/6/15 21:54* since v1.0*/
Service
AllArgsConstructor
public class SysUserServiceImpl implements SysUserService {private final SysUserMapper sysUserMapper;Overridepublic int deleteByPrimaryKey(Long id) {return sysUserMapper.deleteByPrimaryKey(id);}Overridepublic int insert(SysUser record) {return sysUserMapper.insert(record);}Overridepublic int insertSelective(SysUser record) {return sysUserMapper.insertSelective(record);}Overridepublic SysUser selectByPrimaryKey(Long id) {return sysUserMapper.selectByPrimaryKey(id);}Overridepublic int updateByPrimaryKeySelective(SysUser record) {return sysUserMapper.updateByPrimaryKeySelective(record);}Overridepublic int updateByPrimaryKey(SysUser record) {return sysUserMapper.updateByPrimaryKey(record);}
}springboot配置
yml配置文件
spring:# 数据源配置datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://192.168.31.10:3308/test?useUnicodetruecharacterEncodingutf8zeroDateTimeBehaviorconvertToNulluseSSLtrueserverTimezoneGMT%2B8username: rootpassword: root
# mybatis配置
mybatis:# mapper.xml映射路径mapper-locations: classpath:mapper/*.xml# 数据库表映射实体所在包路径type-aliases-package: com.zy.study.domain启动类
// 启动类需增加扫描mapper接口的注解, 不然会报错
MapperScan(com.zy.study.mapper)
SpringBootApplication
public class StudyProject02Application {public static void main(String[] args) {SpringApplication.run(StudyProject02Application.class, args);}
}测试
编写一个简单的测试类这里使用springboot-test的方式测试不需要web启动服务编写controller就可以完成测试。
SpringBootTest
class StudyProject02ApplicationTests {// 注入实例Autowiredprivate SysUserService sysUserService;Testvoid contextLoads() {// 调用查询方法, 验证数据源是否配置成功.SysUser sysUser sysUserService.selectByPrimaryKey(1L);System.out.println(sysUser.toString());}
}测试结果如下可以正常获取到数据库数据这里其他方法先不做验证通过查询方法得知数据源已配置成功即可。
End
拜~
