Spring boot and kotlin use jdbctemplate to connect mysql database

Some examples of web layer were introduced before, including building restful API and rendering web view using thymeleaf template engine, but these contents are not enough to build a dynamic application. Generally, we need content for both app and web applications, and the content is usually stored in various types of databases. After receiving the access request, the server needs to access the database to obtain and process it into the form of data presented to users.

This article introduces an example of configuring data sources based on spring boot and writing data access through jdbctemplate.

Data source configuration

When accessing the database, we need to configure a data source first. Here are several different database configuration methods.

First of all, in order to connect to the database, you need to introduce JDBC support in build The following configurations are introduced into gradle:

Connect data source

Taking MySQL database as an example, first introduce the dependency package of MySQL connection in build Add to gradle:

Complete build gradle

In Src / main / resources / application Configuring data source information in YML

Connecting to JNDI data sources

When you deploy an application on an application server and want the data source to be managed by the application server, you can use the following configuration method to introduce JNDI data sources.

If you don't know much about JNDI, please refer to https://baike.baidu.com/item/JNDI/3792442?fr=aladdin

The jdbctemplate described above is only the most basic operations. For more information on the use of other data access operations, please refer to the jdbctemplate API