Skip to content

Commit 16a41f1

Browse files
dunwudunwu
committed
feat: 更新示例代码
1 parent 0b97adc commit 16a41f1

27 files changed

Lines changed: 791 additions & 469 deletions

File tree

‎codes/javadb/javadb-h2/pom.xml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -14,7 +14,7 @@
1414
<maven.compiler.source>${java.version}</maven.compiler.source>
1515
<maven.compiler.target>${java.version}</maven.compiler.target>
1616

17-
<junit.version>4.12</junit.version>
17+
<junit.version>4.13.1</junit.version>
1818
</properties>
1919

2020
<dependencies>
@@ -39,7 +39,7 @@
3939
<dependency>
4040
<groupId>com.h2database</groupId>
4141
<artifactId>h2</artifactId>
42-
<version>1.4.197</version>
42+
<version>2.0.206</version>
4343
<scope>test</scope>
4444
</dependency>
4545
<!-- database end -->

‎codes/javadb/javadb-hbase/pom.xml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -15,7 +15,7 @@
1515
<maven.compiler.target>${java.version}</maven.compiler.target>
1616

1717
<hbase.version>1.3.1</hbase.version>
18-
<junit.version>4.12</junit.version>
18+
<junit.version>4.13.1</junit.version>
1919
<dunwu.version>0.5.7</dunwu.version>
2020
</properties>
2121

‎codes/javadb/javadb-mysql/pom.xml‎

Lines changed: 14 additions & 93 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
<?xml version="1.0" encoding="UTF-8"?>
22
<project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0"
3-
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
3+
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
44
<modelVersion>4.0.0</modelVersion>
55

66
<parent>
@@ -15,111 +15,32 @@
1515
<version>1.0.0</version>
1616
<packaging>jar</packaging>
1717

18-
<properties>
19-
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
20-
<java.version>1.8</java.version>
21-
<maven.compiler.source>${java.version}</maven.compiler.source>
22-
<maven.compiler.target>${java.version}</maven.compiler.target>
23-
24-
<spring.version>4.3.13.RELEASE</spring.version>
25-
<logback.version>1.2.3</logback.version>
26-
<junit.version>4.12</junit.version>
27-
</properties>
28-
2918
<dependencies>
3019
<dependency>
3120
<groupId>org.springframework.boot</groupId>
3221
<artifactId>spring-boot-starter-jdbc</artifactId>
3322
</dependency>
34-
<!-- db begin -->
35-
<dependency>
36-
<groupId>mysql</groupId>
37-
<artifactId>mysql-connector-java</artifactId>
38-
<version>8.0.21</version>
39-
</dependency>
40-
<dependency>
41-
<groupId>org.apache.commons</groupId>
42-
<artifactId>commons-pool2</artifactId>
43-
<version>2.5.0</version>
44-
</dependency>
45-
<!-- db end -->
46-
47-
<!-- log start -->
48-
<dependency>
49-
<groupId>ch.qos.logback</groupId>
50-
<artifactId>logback-classic</artifactId>
51-
</dependency>
52-
<!-- log end -->
53-
54-
<!-- spring begin -->
5523
<dependency>
56-
<groupId>org.springframework</groupId>
57-
<artifactId>spring-context-support</artifactId>
24+
<groupId>org.springframework.boot</groupId>
25+
<artifactId>spring-boot-starter-test</artifactId>
26+
<scope>test</scope>
5827
</dependency>
5928
<dependency>
60-
<groupId>org.springframework</groupId>
61-
<artifactId>spring-test</artifactId>
62-
<scope>test</scope>
29+
<groupId>mysql</groupId>
30+
<artifactId>mysql-connector-java</artifactId>
6331
</dependency>
64-
<!-- spring end -->
65-
66-
<!-- test begin -->
6732
<dependency>
68-
<groupId>junit</groupId>
69-
<artifactId>junit</artifactId>
33+
<groupId>org.projectlombok</groupId>
34+
<artifactId>lombok</artifactId>
7035
</dependency>
71-
<!-- test end -->
7236
</dependencies>
7337

74-
<dependencyManagement>
75-
<dependencies>
76-
<dependency>
77-
<groupId>org.springframework</groupId>
78-
<artifactId>spring-framework-bom</artifactId>
79-
<version>${spring.version}</version>
80-
<type>pom</type>
81-
<scope>import</scope>
82-
</dependency>
83-
84-
<!-- database begin -->
85-
<dependency>
86-
<groupId>redis.clients</groupId>
87-
<artifactId>jedis</artifactId>
88-
<version>${jedis.version}</version>
89-
</dependency>
90-
<!-- database end -->
91-
92-
<!-- log begin -->
93-
<dependency>
94-
<groupId>ch.qos.logback</groupId>
95-
<artifactId>logback-parent</artifactId>
96-
<version>${logback.version}</version>
97-
<type>pom</type>
98-
<scope>import</scope>
99-
</dependency>
100-
<!-- log end -->
101-
102-
<!-- test begin -->
103-
<dependency>
104-
<groupId>junit</groupId>
105-
<artifactId>junit</artifactId>
106-
<version>${junit.version}</version>
107-
<scope>test</scope>
108-
</dependency>
109-
<!-- test end -->
110-
</dependencies>
111-
</dependencyManagement>
112-
11338
<build>
114-
<finalName>${project.artifactId}</finalName>
115-
<resources>
116-
<resource>
117-
<filtering>true</filtering>
118-
<directory>src/main/resources</directory>
119-
<includes>
120-
<include>logback.xml</include>
121-
</includes>
122-
</resource>
123-
</resources>
39+
<plugins>
40+
<plugin>
41+
<groupId>org.springframework.boot</groupId>
42+
<artifactId>spring-boot-maven-plugin</artifactId>
43+
</plugin>
44+
</plugins>
12445
</build>
12546
</project>

‎codes/javadb/javadb-mysql/src/main/java/io/github/dunwu/javadb/SpringBootDataJdbcApplication.java‎

Lines changed: 45 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,45 @@
1+
package io.github.dunwu.javadb;
2+
3+
import lombok.extern.slf4j.Slf4j;
4+
import org.springframework.boot.CommandLineRunner;
5+
import org.springframework.boot.SpringApplication;
6+
import org.springframework.boot.autoconfigure.SpringBootApplication;
7+
import org.springframework.jdbc.core.JdbcTemplate;
8+
9+
import java.sql.Connection;
10+
import javax.sql.DataSource;
11+
12+
@Slf4j
13+
@SpringBootApplication
14+
public class SpringBootDataJdbcApplication implements CommandLineRunner {
15+
16+
private final JdbcTemplate jdbcTemplate;
17+
18+
public SpringBootDataJdbcApplication(JdbcTemplate jdbcTemplate) {
19+
this.jdbcTemplate = jdbcTemplate;
20+
}
21+
22+
public static void main(String[] args) {
23+
SpringApplication.run(SpringBootDataJdbcApplication.class, args);
24+
}
25+
26+
@Override
27+
public void run(String... args) throws Exception {
28+
DataSource dataSource = jdbcTemplate.getDataSource();
29+
30+
Connection connection;
31+
if (dataSource != null) {
32+
connection = dataSource.getConnection();
33+
} else {
34+
log.error("连接数据源失败！");
35+
return;
36+
}
37+
38+
if (connection != null) {
39+
log.info("数据源 Url: {}", connection.getMetaData().getURL());
40+
} else {
41+
log.error("连接数据源失败！");
42+
}
43+
}
44+
45+
}

‎codes/javadb/javadb-mysql/src/main/java/io/github/dunwu/javadb/User.java‎

Lines changed: 63 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,63 @@
1+
package io.github.dunwu.javadb;
2+
3+
import lombok.AllArgsConstructor;
4+
import lombok.Data;
5+
import lombok.NoArgsConstructor;
6+
import lombok.ToString;
7+
8+
import java.util.Objects;
9+
10+
/**
11+
* 用户实体，对应 user 表
12+
*
13+
* @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
14+
* @since 2019-11-18
15+
*/
16+
@Data
17+
@ToString
18+
@NoArgsConstructor
19+
@AllArgsConstructor
20+
public class User {
21+
22+
private Long id;
23+
24+
private String name;
25+
26+
private Integer age;
27+
28+
private String address;
29+
30+
private String email;
31+
32+
public User(String name, Integer age, String address, String email) {
33+
this.name = name;
34+
this.age = age;
35+
this.address = address;
36+
this.email = email;
37+
}
38+
39+
@Override
40+
public int hashCode() {
41+
return Objects.hash(id, name);
42+
}
43+
44+
@Override
45+
public boolean equals(Object o) {
46+
if (this == o) {
47+
return true;
48+
}
49+
50+
if (!(o instanceof User)) {
51+
return false;
52+
}
53+
54+
User user = (User) o;
55+
56+
if (id != null && id.equals(user.id)) {
57+
return true;
58+
}
59+
60+
return name.equals(user.name);
61+
}
62+
63+
}

‎codes/javadb/javadb-mysql/src/main/java/io/github/dunwu/javadb/UserDao.java‎

Lines changed: 41 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,41 @@
1+
package io.github.dunwu.javadb;
2+
3+
import org.springframework.jdbc.core.JdbcTemplate;
4+
5+
import java.util.List;
6+
7+
/**
8+
* user 表 Dao 接口
9+
*
10+
* @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
11+
* @since 2019-11-18
12+
*/
13+
public interface UserDao {
14+
15+
// DML
16+
// -------------------------------------------------------------------
17+
void insert(User user);
18+
19+
void batchInsert(List<User> users);
20+
21+
void deleteByName(String name);
22+
23+
void deleteAll();
24+
25+
void update(User user);
26+
27+
Integer count();
28+
29+
List<User> list();
30+
31+
User queryByName(String name);
32+
33+
JdbcTemplate getJdbcTemplate();
34+
35+
// DDL
36+
// -------------------------------------------------------------------
37+
void truncate();
38+
39+
void recreateTable();
40+
41+
}

‎codes/javadb/javadb-mysql/src/main/java/io/github/dunwu/javadb/UserDaoExecutor.java‎

Lines changed: 36 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,36 @@
1+
package io.github.dunwu.javadb;
2+
3+
import lombok.extern.slf4j.Slf4j;
4+
import org.springframework.stereotype.Component;
5+
6+
import java.util.List;
7+
import javax.annotation.PostConstruct;
8+
9+
/**
10+
* @author <a href="mailto:forbreak@163.com">Zhang Peng</a>
11+
* @since 2020-10-11
12+
*/
13+
@Slf4j
14+
@Component
15+
public class UserDaoExecutor {
16+
17+
private final UserDao userDao;
18+
19+
public UserDaoExecutor(UserDao userDao) {
20+
this.userDao = userDao;
21+
}
22+
23+
@PostConstruct
24+
public void method() {
25+
if (userDao != null) {
26+
log.info("Connect to datasource success.");
27+
} else {
28+
log.error("Connect to datasource failed!");
29+
return;
30+
}
31+
32+
List<User> list = userDao.list();
33+
list.forEach(item -> log.info(item.toString()));
34+
}
35+
36+
}

0 commit comments

Comments
 (0)