1、jdbc.properties?
jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql:///studb jdbc.user=root jdbc.pwd=1234562、beans.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd"><!--導入jdbc.properties--><context:property-placeholder location="classpath:jdbc.properties"/><!--創建數據源連接處--><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="driverClassName" value="${jdbc.driver}"/><property name="url" value="${jdbc.url}"/><property name="username" value="${jdbc.user}"/><property name="password" value="${jdbc.pwd}"/><property name="initialSize" value="5"/><property name="maxWait" value="5000"/></bean><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"/></bean></beans>3、Student.java
package com.atguigu.pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @AllArgsConstructor @NoArgsConstructor public class Student {private Integer id;private String name;private String gender;private Integer age;private String classBean; }4、JdbcTemplateTest.java
package com.atguigu; import com.atguigu.pojo.Student; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.BeanPropertyRowMapper; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowMapper; import org.springframework.test.context.junit.jupiter.SpringJUnitConfig; import javax.sql.DataSource; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; @SpringJUnitConfig(locations = "classpath:beans.xml") public class JdbcTemplateTest {@Autowiredprivate DataSource dataSource;@Autowiredprivate JdbcTemplate jdbcTemplate;//測試連接數據庫@Testpublic void TestConnection() throws SQLException {System.out.println(dataSource.getConnection()==null?"連接失敗":"連接成功");//連接成功}//測試插入操作@Testpublic void InsertTest() {Student s1= new Student(0, "阿碧", "女", 18, "Java1班");String sql = "insert into students values(0,?,?,?,?)";jdbcTemplate.update(sql, s1.getName(), s1.getGender(), s1.getAge(), s1.getClassBean());}//演示刪除學生信息測試方法@Testpublic void DeleteTest() {String sql = "delete from students where id=?";jdbcTemplate.update(sql, 0);}//演示查詢單個字段值@Testpublic void QueryTest() {String sql = "select name from students where id=?";String name = jdbcTemplate.queryForObject(sql, String.class, 8);System.out.println("name = " + name);//name = 吳十}//演示查詢單個實體對象@Testpublic void QueryObjectTest() {String sql = "select * from students where id=?";Student s = jdbcTemplate.queryForObject(sql, new RowMapper<Student>() {@Overridepublic Student mapRow(ResultSet rs, int rowNum) throws SQLException {return new Student(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5));}}, 8);System.out.println("s = " + s);//s = Student(id=8, name=吳十, gender=男, age=19, classBean=高中二班)}//演示查詢單個實體對象@Testpublic void QueryObjectLambdaTest() {String sql = "select * from students where id=?";Student s = jdbcTemplate.queryForObject(sql,(rs,rowNum)->new Student(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getInt(4), rs.getString(5)), 8);System.out.println("s = " + s);//s = Student(id=8, name=吳十, gender=男, age=19, classBean=高中二班)}//演示查詢實體對象列表@Testpublic void QueryObjectListTest() {String sql = "select id,name,gender,age,class as classBean from students";List<Student> studentList = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(Student.class));studentList.forEach(System.out::println);//Student(id=1, name=張三, gender=男, age=20, classBean=高中一班)//Student(id=2, name=李四, gender=男, age=19, classBean=高中二班)//Student(id=3, name=王五, gender=女, age=18, classBean=高中一班)//Student(id=4, name=趙六, gender=女, age=20, classBean=高中三班)//Student(id=5, name=劉七, gender=男, age=19, classBean=高中二班)//Student(id=6, name=陳八, gender=女, age=18, classBean=高中一班)//Student(id=7, name=楊九, gender=男, age=20, classBean=高中三班)//Student(id=8, name=吳十, gender=男, age=19, classBean=高中二班)} }5、studb.sql
create database studb;use studb;CREATE TABLE students (id INT PRIMARY KEY,name VARCHAR(50) NOT NULL,gender VARCHAR(10) NOT NULL,age INT,class VARCHAR(50) );INSERT INTO students (id, name, gender, age, class) VALUES(1, '張三', '男', 20, '高中一班'),(2, '李四', '男', 19, '高中二班'),(3, '王五', '女', 18, '高中一班'),(4, '趙六', '女', 20, '高中三班'),(5, '劉七', '男', 19, '高中二班'),(6, '陳八', '女', 18, '高中一班'),(7, '楊九', '男', 20, '高中三班'),(8, '吳十', '男', 19, '高中二班');6、父工程pom.xml?
<properties><maven.compiler.source>17</maven.compiler.source><maven.compiler.target>17</maven.compiler.target><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><spring.version>6.0.6</spring.version><junit.version>5.3.1</junit.version><lombok.version>1.18.20</lombok.version><mysql.version>8.0.25</mysql.version><druid.version>1.2.8</druid.version></properties><dependencyManagement><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>${lombok.version}</version></dependency><dependency><groupId>org.junit.jupiter</groupId><artifactId>junit-jupiter-api</artifactId><version>${junit.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version><scope>test</scope></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>${druid.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency></dependencies></dependencyManagement>?7、子工程pom.xml
<dependencies><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId></dependency><dependency><groupId>org.junit.jupiter</groupId><artifactId>junit-jupiter-api</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId></dependency>
spring-jdbc-template是Spring框架中提供的一個JDBC模板，簡化了開發者對JDBC API的調用。你可以使用它來執行各種JDBC操作，如查詢、插入、更新、刪除等。下面是使用spring-jdbc-template的步驟：
- 添加spring-jdbc依賴
首先需要在Maven或Gradle項目中添加spring-jdbc依賴。
<dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.3.6</version> </dependency>
- 配置數據源
配置使用的數據源，在Spring配置文件中添加以下配置。
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver"/><property name="url" value="jdbc:mysql://localhost:3306/test"/><property name="username" value="root"/><property name="password" value="root"/> </bean>
- 配置JdbcTemplate
配置JdbcTemplate，配置JdbcTemplate時需要注入數據源。
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource"/> </bean>
- 使用JdbcTemplate
最后，你可以在Java代碼中使用JdbcTemplate。
@Autowired private JdbcTemplate jdbcTemplate;public void insert(User user) {String sql = "INSERT INTO users (name, age) VALUES (?, ?)";jdbcTemplate.update(sql, user.getName(), user.getAge()); }以上是使用spring-jdbc-template的步驟，你可以根據項目的需要來調整代碼實現，具體的JDBC操作方法可以在Spring的官方文檔中查找。
)
