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

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

下面通過實例講解如何在SpringBoot應用中使用JdbcTemplate操作數據庫

1、創建SpringBootWeb應用

此處不再贅述詳情可參考我這篇構建SpringBoot應用

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、設置Web應用的上下文路徑以及數據源配置信息

在perties文件中配置如下內容

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、創建實體類

創建名為com.ch.ch6_5.entity的包并在該包中出啊關鍵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、創建數據訪問層

創建名為com.ch.ch6_5.repository的包并創建接口和其實現類

接口代碼如下

packagecom.ch.ch6_5.repository;

importjava.util.List;

importcom.ch.ch6_5.entity.MyUser;

publicinterfaceMyUserRepository{

publicintsaveUser(MyUsermyUser);

publicintdeleteUser(Integerid);

publicintupdateUser(MyUsermyUser);

publicListMyUserfindAll();

publicMyUserfindUserById(Integerid);

}

實現類代碼如下

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、創建業務層

創建名為com.ch.ch6_5.service的包并創建接口和實現類

接口代碼如下

packagecom.ch.ch6_5.service;

importjava.util.List;

importcom.ch.ch6_5.entity.MyUser;

publicinterfaceMyUserService{

publicintsaveUser(MyUsermyUser);

publicintdeleteUser(Integerid);

publicintupdateUser(MyUsermyUser);

publicListMyUserfindAll();

publicMyUserfindUserById(Integerid);

}

實現類代碼如下

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、創建控制器類

創建名為c