Implementation of Paging Technology in jsp

Paging purposes: In order to prevent the server from reading out all the data of the database at one time and improve efficiency. (The database data exists in the form of files, and it is slow to read from the hard disk) Two representations of restricted queries need to be used: limit n: Query n data fr ...

Posted on Wed, 02 Oct 2019 03:28:26 -0700 by tymlls05

Spring boot ~ mybatis enumeration mapping

In mybatis and mybatis plus, if your entity field is an enumeration type and the data table is an integer type, it needs to be processed during storage. By default, the enumerated element names are spliced into the SQL statement. Because the data table is an int type, there will be an exception in insertion and other operations. Add Enumeration ...

Posted on Wed, 02 Oct 2019 03:06:46 -0700 by kml2katz

Dynamic loading database connection pool

Background: For the problem of loading data sources that need to be configured in the database for SQL statements, it is impossible to load dynamically configured databases directly using external database connection pools. The simple way is to use JDBC to get configuration information separately t ...

Posted on Tue, 01 Oct 2019 18:11:56 -0700 by ajfton

Transaction Management in Spring 4-Spring: Transaction Isolation Level

Transaction Management in Spring Transaction Manager in Spring Experimental code Table in MySQL book table book_stock table account table Two interfaces BookShopDao.java public interface BookShopDao { //Getting the unit price of a book by its number public int findBookPr ...

Posted on Tue, 01 Oct 2019 04:22:34 -0700 by amarquis

SQL rewriting of sharding-jdbc

[Cite Official Website] In scenarios containing tables, the logical table name in the table configuration needs to be rewritten to the real table name obtained after routing. Sublibrary only does not require table name rewriting. In addition, it also includes supplement and paging information correction, as shown in the figure:       This ...

Posted on Tue, 01 Oct 2019 02:49:07 -0700 by jwalsh

MyBatis Plus-8 - Customize Global Operations

Customize global operations According to AutooSql Injector of Mybatis Plus, you can customize all kinds of sql you want to inject into the whole world, which is equivalent to customizing the method of automatic injection of Mybatis Plus. Previously, SQL statements that needed to be configured in xml are now injected when the mybatis environmen ...

Posted on Mon, 30 Sep 2019 17:59:42 -0700 by beinerts

PostgreSQL DBA(92) - PG 12 Improving VACUUM

The VACUUM command has been enhanced in PG 12 to provide new Option options. This section describes one of the options: INDEX_CLEANUP. PG 11 vacuum command [xdb@localhost ~]$ psql -d testdb -p 5433psql (11.2)Type "help" for help.testdb=# \help vacuum;Command:     VACUUMDescription: garbage-collect and optionally analyze a databaseSyntax:VACUUM ...

Posted on Mon, 30 Sep 2019 16:53:42 -0700 by tentaguasu

Implementing Registration Function with Database

The results are as follows: register.jsp on the registration page reads as follows: <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <meta charset="UTF-8"/> <title>register</title> <link rel="stylesheet" type="text/ ...

Posted on Mon, 30 Sep 2019 02:27:43 -0700 by SEVIZ

Synchronized saving of FreeSql navigation properties

Write before FreeSql supports.net framework 4.5+,.net core 2.1+, open source ORM under a.net platform.With over 3100+, unit testing is attracting new developers and continuing to evolve. Like EFCore, we have navigation objects that support OneToOne (one-to-one), [ManyToOne], [OneToMany], [ParentChild], [ManyToMany], either by convention or by h ...

Posted on Sun, 29 Sep 2019 19:03:26 -0700 by cedricm

mybatis-mapper File Details

Table structure: CREATE TABLE customer (id int(11) NOT NULL COMMENT'Enterprise User ID',name varchar(45) DEFAULT NULL COMMENT'Name',Logo varchar (80) DEFAULT''COMMENT' Enterprise Identity,Descrivarchar (500) DEFAULT''COMMENT' Bus Description,Is_enable tinyint (1) DEFAULT'0'COMMENT'enabled 1 = enabled 0 = not enabled',phone varchar(20) DEFAULT N ...

Posted on Fri, 27 Sep 2019 04:20:34 -0700 by tinyashcities