在Spring Boot中配置Apache Derby的问题通常涉及到以下几个方面:
org.apache.derby
derby
10.15.2.0
spring.datasource.url=jdbc:derby:memory:testdb;create=true
spring.datasource.driverClassName=org.apache.derby.jdbc.EmbeddedDriver
spring.datasource.username=
spring.datasource.password=
@Configuration
public class DataSourceConfig {
@Value("${spring.datasource.url}")
private String url;
@Value("${spring.datasource.driverClassName}")
private String driverClassName;
@Bean
public DataSource dataSource() {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(driverClassName);
dataSource.setUrl(url);
return dataSource;
}
}
@Service
public class UserService {
private final JdbcTemplate jdbcTemplate;
public UserService(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public void createUserTable() {
jdbcTemplate.execute("CREATE TABLE users (id INT, name VARCHAR(255))");
}
public void insertUser(int id, String name) {
jdbcTemplate.update("INSERT INTO users (id, name) VALUES (?, ?)", id, name);
}
public List getAllUserNames() {
return jdbcTemplate.queryForList("SELECT name FROM users", String.class);
}
}
以上就是在Spring Boot中配置Apache Derby的一般步骤和示例代码。