Programming VIP

Note: The links below are all based on mysql as an example, @Test is a Junit4 comment for testing, and the tool classes used are described in the previous section Post the table-building statement first for easy follow-up CREATE TABLE `fruit` ( `fruitName` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'Fruit Name', `id` int(11) NOT N ...

JDBC What is JDBC? It is a common interface (API) for SQL database access and operation independent of a specific database management system. Why provide a fixed interface? A: it is easy to operate and improve efficiency. Different databases can be programmed through this set of interfaces. After layering, programmers only need to program ...

Spring Boot learning Official website: https://spring.io/projects/spring-boot#overview file: https://docs.spring.io/spring-boot/docs/2.2.6.RELEASE/reference/html/ Reference video: [crazy God says Java] the latest tutorial of SpringBoot, IDEA version, is easy to understand_ Beep beep beep_ bilibili Project complete reference code: lexi ...

1. What is Spring JdbcTemplate Spring JdbcTemplate, also known as Spring JDBC module, is mainly responsible for database resource management and error detection to simplify the operation of the database. Spring JdbcTemplate is an object provided in the spring framework. It is a simple encapsulation of the original cumbersome JDBC API object. ...

Java JDBC learning JDBC (Java DataBase Connectivity) java database connection ● is a Java API for executing SQL statements, which can provide unified access to a variety of relational databases. It is composed of a group of classes and interfaces written in Java language. With JDBC,java developers only need to write a program once to access di ...

7: Database connection pool 7.1 necessity of JDBC database connection pool When developing web programs based on database, the traditional mode basically follows the following steps: Establish database connection in the main program (such as servlet and beans)Perform sql operationsDisconnect database Problems in the development of this m ...

1.1 introducing pom dependency When introducing SpringBoot and SpringCloud versions, pay special attention to their compatibility Reference: https://spring.io/projects/spring-cloud <!--introduce springboot Parent project dependency--> <!--Introduce dependency: It can be omitted version Tag to get some reasonable ...

1, PreparedStatement 1.1 SQL injection Before sql execution, problems may arise if you splice the sql statement string and the filled data When the user inputs special data with sql statements and splices it with the original sql, the execution results of the sql statements may be inconsistent with the expectations, resulting in program erro ...

I jdbc connection pool The connection between the program and the database is the underlying technology. Each connection is time-consuming, and after it is used up, the connection must be closed to release resources. In fact, it is a waste of time to connect and release repeatedly. Therefore, a connection pool technology is introduced to manag ...

1. Element 1: Driver interface implementation class 1.1 introduction to Driver interface java. sql. The driver interface is the interface that all JDBC drivers need to implement. This interface is provided for database manufacturers. Different database manufacturers provide different implementations. In the program, you do not need to direc ...