An sql query tree structure data

Current problem: how to query the data of provinces, cities, districts and counties in the same table through an SQL statement, And the provincial level includes all the city level lists, and the city level includes the county level data. Idea: using nested query of mybatis collection The data format is as follows: Java entity classes are ...

Posted on Wed, 01 Apr 2020 00:22:45 -0700 by Nukeum66

[transfer] Mybatis Plus plug in registration machine

Analysis version 2.83 First look at the following code public static synchronized boolean refValid() { if (!validated) { validated = true; try { String key = MybatisSetting.getInstance().getKey(); //KEY String result = MybatisSetting.getInstance().getResult(); //RESULT if ((StringUtils.isBl ...

Posted on Mon, 30 Mar 2020 09:39:52 -0700 by manx

Mybatis Spring: integrating mybatis and Spring mode 1: SqlSessionTemplate

Mybatis Spring will help you integrate mybatis code seamlessly into Spring. It will allow mybatis to participate in Spring's transaction management, create mapper and SqlSession and inject them into bean s, and convert mybatis's exception to Spring's DataAccessException. Preparation, entity class, mapper interface, mybatis configuration file ...

Posted on Sun, 29 Mar 2020 07:04:56 -0700 by mhsjrotc

Build a simple SMM framework

SSM Framework Integration Spring + Spring MVC + MyBatis Spring MVC implements the MVC design pattern, MyBatis implements the data persistence layer, and Spring manages the creation and dependency injection of Spring MVC and MyBatis-related objects. Create a Maven project, pom.xml <?xml version="1.0" encoding="UTF-8"?> <project xmlns ...

Posted on Fri, 27 Mar 2020 09:13:42 -0700 by NME

Spring boot uses mybatis plus form to update null value

Background of problem Use mybatis plus for database interaction. The default setting is to enable null without updating. After adding data, edit the page to clear the field value (date type, int type, in order to avoid the default value passing in, all model s are initialized to null with the packing type). Null value cannot be updated to the d ...

Posted on Sat, 21 Mar 2020 07:12:50 -0700 by kevin99

Install mysql8 on win10 and configure master-slave replication

Recently, I am studying spring boot, and I want to organize a blog about spring boot integrating mybatis and configuring the master-slave database. However, mysql master-slave database is not configured on the computer win10 system. So it took a few days to get it right. Record it here. The first step is to install two mysql8 on win10. I found ...

Posted on Sat, 21 Mar 2020 05:44:02 -0700 by elbowgrease

Common Mapper Advanced Example: Why hasn't it been updated for a long time?

A few days ago I noticed someone was on GitHub three months ago Is this project no longer maintained? And then I looked at it Generic Mapper Content and time of last update: Although PR was merged, there was no release. The release information for the last release is as follows: That is, no new version ...

Posted on Mon, 16 Mar 2020 17:32:58 -0700 by cemzafer

SpringBoot Integrates SpringSecurity Sample Implementation Separate Permission Annotation + JWT Logon Authentication

SpringSecurity is a security framework for Java enterprise applications, which mainly includes user authentication and user authorization. Compared to Shiro, Security is more powerful, it can easily expand to meet more security control requirements, but it also has a higher learning cost.Both frameworks ...

Posted on Sun, 15 Mar 2020 19:19:12 -0700 by BarmyArmy

Three implementation methods of mybatis: pure xml configuration

** The implementation of mybatis: pure xml configuration ** First, First, add mybatis related dependency <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.1</version> </dependency> &lt ...

Posted on Sun, 15 Mar 2020 04:11:52 -0700 by brownca

Mybatis - XML configuration

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <!-- global variable --> <properties> <property name="driver" value= ...

Posted on Sat, 14 Mar 2020 22:28:53 -0700 by johnseito