【Spring Data Access】 Spring jdbc Embedded Database

今天药忘吃喽~ 2022-05-08 23:40 161阅读 0赞

# Spring jdbc Embedded Database #

内置的数据库对测试很有用，spring默认提供了H2, HSQL, Derby等类型的数据支撑，

下面介绍基于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:jdbc="http://www.springframework.org/schema/jdbc" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd">
    
        <jdbc:embedded-database id="dataSource" generate-name="true" type="HSQL"/>
    
        
        <jdbc:initialize-database data-source="dataSource" enabled="true" ignore-failures="DROPS" separator=";">
            
            <jdbc:script location="classpath:schema.sql" separator=";"/>
            <jdbc:script location="classpath:data.sql"/>
        </jdbc:initialize-database>
    </beans>

结合具体的例子来感受一下:

1 schema.sql

create table user( id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 100, INCREMENT BY 1) PRIMARY KEY, name varchar(20), age int);

2 data.sql

insert into user(name, age) values('alice', 20),('bob', 18);

3 User.java

public class User { private Long id; private String name; private int age; public User() { } public User(Long id, String name) { this.id = id; this.name = name; } public User(String name, int age) { this.name = name; this.age = age; } public Long getId() { return id; } public void setId(Long id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } @Override public String toString() { return "User{" + "id=" + id + ", name='" + name + '\'' + ", age=" + age + '}'; } }

4 EmbeddedDatabaseSample.java

import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; import javax.sql.DataSource; /** * @author jiangjian */ public class EmbeddedDatabaseSample { public static void main(String[] args) { ApplicationContext ac = new ClassPathXmlApplicationContext("classpath:dataaccess/jdbc/step14_embedded_database/spring.xml"); JdbcTemplate jdbcTemplate = new JdbcTemplate(ac.getBean(DataSource.class)); jdbcTemplate.query("select * from user", (rs, rowNum) -> { User user = new User(); user.setId(rs.getLong("id")); user.setName(rs.getString("name")); user.setAge(rs.getInt("age")); return user; }).forEach(System.out::println); } }

结果如下:  
![在这里插入图片描述][70]

[70]: /images/20220509/bfeb62a8e2204fc28eeb5a5b49cbefa8.png