Spring Boot中使用jdbctemplate 操作MYSQL数据库实例

时间:2021-10-07 10:49:48

最近在学习使用Spring Boot连接数据库,今天学习了使用jdbctemplate 操作MYSQL数据库,下面就留个笔记

不废话,先来代码

pom文件:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 
 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
 
 <modelVersion>4.0.0</modelVersion>
 
 
 
 <groupId>test</groupId>
 
 <artifactId>test</artifactId>
 
 <version>0.0.1-SNAPSHOT</version>
 
 <packaging>jar</packaging>
 
 
 
 <name>test</name>
 
 <url>http://maven.apache.org</url>
 
 
 
 <properties>
 
  <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
 
 </properties>
 
  
 
 <dependencies>
 
  <dependency>
 
    <groupId>org.springframework.boot</groupId>
 
    <artifactId>spring-boot-starter</artifactId>
 
    <version>1.4.2.RELEASE</version>
 
  </dependency>
 
  <dependency>
 
    <groupId>org.springframework.boot</groupId>
 
    <artifactId>spring-boot-starter-jdbc</artifactId>
 
    <version>1.4.2.RELEASE</version>
 
  </dependency>
 
   
 
  <dependency>
 
    <groupId>mysql</groupId>
 
    <artifactId>mysql-connector-java</artifactId>
 
    <version>5.1.21</version>
 
   </dependency>
 
  
 
 </dependencies>
 
</project>

配置文件:application.properties(springboot框架默认使用这个名字,放在resources下面)

?
1
2
3
4
5
6
7
8
9
10
11
spring.datasource.url=jdbc:mysql://localhost:3306/service_lucky_draw?autoReconnect=true&useUnicode=true&characterEncoding=utf-8
 
spring.datasource.username=root
 
spring.datasource.password=1234
 
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
 
spring.application.name = @pom.artifactId@
 
server.port=33333

启动类:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
package versionUpdate;
 
import java.util.List;
 
import java.util.Map;
 
import org.apache.log4j.Logger;
 
import org.springframework.beans.factory.annotation.Autowired;
 
import org.springframework.boot.CommandLineRunner;
 
import org.springframework.boot.SpringApplication;
 
import org.springframework.boot.autoconfigure.SpringBootApplication;
 
import org.springframework.jdbc.core.JdbcTemplate;
 
@SpringBootApplication
 
public class ApplicationMain implements CommandLineRunner {
 
  private Logger log = Logger.getLogger(ApplicationMain.class);
 
  @Autowired
 
  private JdbcTemplate jdbcTemplate;
 
  public static void main(String[] args) {
 
    SpringApplication springApplication = new SpringApplication(ApplicationMain.class);
 
    springApplication.run(args);
 
  }
 
  @Override
 
  public void run(String... args) throws Exception {
 
    String queryMerchandiseInfoSql = "SELECT id,worth,channel_id,template_id FROM merchandise_info";
 
    List<Map<String, Object>> list = jdbcTemplate.queryForList(queryMerchandiseInfoSql);
 
    log.debug(list);
 
  }
 
}

至此一个简单的SpringBoot+Jdbctemplate+MYSQL的DEMO搭建完成;

如果不想在启动类里面直接进行数据库操作,可以按照下面的方式:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
package versionUpdate;
 
import org.springframework.beans.factory.annotation.Autowired;
 
import org.springframework.jdbc.core.JdbcTemplate;
 
import org.springframework.stereotype.Component;
 
/** 获取jdbctemplate实例 */
 
@Component
 
public class EnterJdbcTemplate {  
 
  private static JdbcTemplate jdbcTemplate;
 
  @Autowired
 
  public EnterJdbcTemplate(JdbcTemplate jdbcTemplate) {
 
    this.jdbcTemplate = jdbcTemplate;
 
  }  
 
  public static JdbcTemplate getJdbcTemplate(){
 
    return jdbcTemplate;
 
  }  
 
}
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
package versionUpdate;
 
import org.springframework.jdbc.core.JdbcTemplate;
 
/** 操作数据库 */
 
public class Movedata extends EnterJdbcTemplate{
 
   
 
  public Movedata(JdbcTemplate jdbcTemplate) {
 
    super(jdbcTemplate);
 
  }
 public static void ccc(){
 
    System.out.println("++++++++++++++++++"+getJdbcTemplate().queryForMap("SELECT * FROM channel_info WHERE channel_id = ? ","cccc"));
 
  }
 
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。

原文链接:http://www.cnblogs.com/ning-blogs/p/6078703.html