SpringBoot用JdbcTemplates操作Mysql實例代碼詳解

第SpringBoot用JdbcTemplates操作Mysql實例代碼詳解目錄1、創(chuàng)建SpringBootWeb應(yīng)用2、修改pom.xml文件3、設(shè)置Web應(yīng)用的上下文路徑以及數(shù)據(jù)源配置信息4、創(chuàng)建實體類5、創(chuàng)建數(shù)據(jù)訪問層6、創(chuàng)建業(yè)務(wù)層7、創(chuàng)建控制器類覺得有幫助或需要源碼請點贊關(guān)注收藏后評論區(qū)留言或者私信

JDBC模板是Spring對數(shù)據(jù)庫的操作再JDBC基礎(chǔ)上做了封裝，建立了一個JDBC存取框架，在SpringBoot應(yīng)用中，如果使用JdbcTemplate操作數(shù)據(jù)庫，那么只需要在pom.xml文件中添加spring-boot-starter-jdbc模塊，即可通過@Autowired注解依賴注入JdbcTemplate對象，然后調(diào)用JdbcTemplate提供的方法操作數(shù)據(jù)庫

下面通過實例講解如何在SpringBoot應(yīng)用中使用JdbcTemplate操作數(shù)據(jù)庫

1、創(chuàng)建SpringBootWeb應(yīng)用

此處不再贅述詳情可參考我這篇構(gòu)建SpringBoot應(yīng)用

2、修改pom.xml文件

在文件中添加MYSQL連接器和spring-boot-starter-jdbc模塊具體代碼如下

xmlversion="1.0"encoding="UTF-8"

-projectxsi:schemaLocation="/POM/4.0.0/xsd/maven-4.0.0.xsd"xmlns:xsi="/2001/XMLSchema-instance"xmlns="/POM/4.0.0"

modelVersion4.0.0/modelVersion

-parent

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-parent/artifactId

version2.1.7.RELEASE/version

relativePath/

!--lookupparentfromrepository--

/parent

groupIdcom.ch/groupId

artifactIdch6_5/artifactId

version0.0.1-SNAPSHOT/version

namech6_5/name

descriptionDemoprojectforSpringBoot/description

-properties

java.version11/java.version

/properties

-dependencies

-dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-web/artifactId

/dependency

!--添加MySQL依賴--

-dependency

groupIdmysql/groupId

artifactIdmysql-connector-java/artifactId

version5.1.45/version

!--MySQL8.x時，請使用8.x的連接器--

/dependency

!--添加jdbc依賴--

-dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-jdbc/artifactId

/dependency

-dependency

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-starter-test/artifactId

scopetest/scope

/dependency

/dependencies

-build

-plugins

-plugin

groupIdorg.springframework.boot/groupId

artifactIdspring-boot-maven-plugin/artifactId

/plugin

/plugins

/build

/project

3、設(shè)置Web應(yīng)用的上下文路徑以及數(shù)據(jù)源配置信息

在perties文件中配置如下內(nèi)容

server.servlet.context-path=/ch6_5

spring.datasource.url=jdbc:mysql://localhost:3306/springbootjpacharacterEncoding=utf8

spring.datasource.username=root

spring.datasource.password=root

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.jackson.serialization.indent-output=true

4、創(chuàng)建實體類

創(chuàng)建名為com.ch.ch6_5.entity的包并在該包中出啊關(guān)鍵MyUser實體類代碼如下

packagecom.ch.ch6_5.entity;

publicclassMyUser{

privateIntegerid;

privateStringusername;

privateStringpassword;

publicIntegergetId(){

returnid;

publicvoidsetId(Integerid){

this.id=id;

publicStringgetUsername(){

returnusername;

publicvoidsetUsername(Stringusername){

this.username=username;

publicStringgetPassword(){

returnpassword;

publicvoidsetPassword(Stringpassword){

this.password=password;

}

5、創(chuàng)建數(shù)據(jù)訪問層

創(chuàng)建名為com.ch.ch6_5.repository的包并創(chuàng)建接口和其實現(xiàn)類

接口代碼如下

packagecom.ch.ch6_5.repository;

importjava.util.List;

importcom.ch.ch6_5.entity.MyUser;

publicinterfaceMyUserRepository{

publicintsaveUser(MyUsermyUser);

publicintdeleteUser(Integerid);

publicintupdateUser(MyUsermyUser);

publicListMyUserfindAll();

publicMyUserfindUserById(Integerid);

}

實現(xiàn)類代碼如下

packagecom.ch.ch6_5.repository;

importjava.util.List;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.jdbc.core.BeanPropertyRowMapper;

importorg.springframework.jdbc.core.JdbcTemplate;

importorg.springframework.jdbc.core.RowMapper;

importorg.springframework.stereotype.Repository;

importcom.ch.ch6_5.entity.MyUser;

@Repository

publicclassMyUserRepositoryImplimplementsMyUserRepository{

@Autowired

privateJdbcTemplatejdbcTemplate;

@Override

publicintsaveUser(MyUsermyUser){

Stringsql="insertintouser(username,password)values(,)";

Objectargs[]={

myUser.getUsername(),

myUser.getPassword()

returnjdbcTemplate.update(sql,args);

@Override

publicintdeleteUser(Integerid){

Stringsql="deletefromuserwhereid=";

Objectargs[]={

returnjdbcTemplate.update(sql,args);

@Override

publicintupdateUser(MyUsermyUser){

Stringsql="updateusersetusername=,password=whereid=";

Objectargs[]={

myUser.getUsername(),

myUser.getPassword(),

myUser.getId()

returnjdbcTemplate.update(sql,args);

6、創(chuàng)建業(yè)務(wù)層

創(chuàng)建名為com.ch.ch6_5.service的包并創(chuàng)建接口和實現(xiàn)類

接口代碼如下

packagecom.ch.ch6_5.service;

importjava.util.List;

importcom.ch.ch6_5.entity.MyUser;

publicinterfaceMyUserService{

publicintsaveUser(MyUsermyUser);

publicintdeleteUser(Integerid);

publicintupdateUser(MyUsermyUser);

publicListMyUserfindAll();

publicMyUserfindUserById(Integerid);

}

實現(xiàn)類代碼如下

packagecom.ch.ch6_5.service;

importjava.util.List;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.stereotype.Service;

importcom.ch.ch6_5.entity.MyUser;

importcom.ch.ch6_5.repository.MyUserRepository;

@Service

publicclassMyUserServiceImplimplementsMyUserService{

@Autowired

privateMyUserRepositorymyUserRepository;

@Override

publicintsaveUser(MyUsermyUser){

publicListMyUserfindAll(){

returnmyUserRepository.findAll();

@Override

publicMyUserfindUserById(Integerid){

returnmyUserRepository.findUserById(id);

}

7、創(chuàng)建控制器類

創(chuàng)建名為c