Programmer Think

An insert operation Take the simple operation of saving a record to the table as an example. Follow this example to track how the MySQL statement executes. To save a user record to the table: sqlSession.insert("x.y.insertUser", user); First of all, we need to look at the sqlsession ා insert method, and find the specific implementation in the D ...

Seata serve installation package Download the Seata Server package, all I have is version 0.9.0 https://github.com/seata/seata/releases wget https://github.com/seata/seata/releases/download/v0.9.0/seata-server-0.9.0.tar.gz Link: https://pan.baidu.com/s/1jlBwCEYM3hn7zQiSpwRijg password: 56vm After 0.9.0 of the official website, there is no ...

Preface CRUD operation on database has a certain history ① JDBC - > ② dbutils - > ③ jdbctemplate - > ④ - > hibernate - > ⑤ mybatis - > ⑥ JPA+SpringData So many dao layers are used to realize their own advantages and disadvantages, and to seek the best dao scheme of the project. But the framework will work, ...

One. Remember to build the connection foundation before getting the database 1. driver 2. connection 3. statement 4. resultSet //1 Class.forName(ConfigUtil.getValue("driver")); //2 Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/resource_integrate","root","root");//The three paramete ...

Introduction Dynamic SQL: dynamic SQL. In this section, we will learn from the official documents of MyBatis. Description The official description is as follows: One of the most powerful features of MyBatis has always been its Dynamic SQL capabilities. If you have any experience with JDBC or any similar framework, you understand how painful it ...

First, make sure you have PostgreSQL installed. You can refer to my article PostgreSQL literacy tutorial. Create a new JPA project using Eclipse: The Platform selects eclipse link as one of the provider s of JPA. The automatically generated project in Eclipse is shown below: Overwrite the automatically generated xml with the contents of the ...

Original Link: http://www.yiidian.com/jdbc/jdbc-callablestatement.html 1 CallableStatement interface The CallableStatement interface is used to call stored procedures and functions. By using stored procedures and functions, we can write business logic on the database, which will improve performance because they are precompiled. 2 What is the di ...

order This paper mainly studies MySQL plugin of skywalking skywalking-plugin.def skywalking-6.6.0/apm-sniffer/apm-sdk-plugin/mysql-8.x-plugin/src/main/resources/skywalking-plugin.def mysql-8.x=org.apache.skywalking.apm.plugin.jdbc.mysql.v8.define.ConnectionImplCreateInstrumentation mysql-8.x=org.apache.skywalking.apm.plugin.jdbc.mysql.v8.define ...

This section introduces the analysis of import tag, which is used to introduce new resource files, such as redis, jdbc and other configuration files for a spring.xml. It is mainly to introduce the idea of recursive loading to the readers, including the idea that the beans tag also uses recursion, but be ...

The content of the content 1. Database connection pool * concept and function         * C3P0         * Druid * Custom JDBC tool class     2. Spring JDBC : JDBC Template 3. Transaction control in Srping##Database connection pool 1. Concept: in fact, it is a container (Collection) for database connecti ...