Spring boot integrates the Jasypt security framework and encrypts the content of configuration files
Reprinted in ( https://zhiku8.com/springboot-jasypt.html)
We are clear text in the yml or properties configuration files of the spring boot project, so the security is relatively low. We all know that the configuration file contains some database connection user name and password, some third-party key and other information. So let's be careful. ...
Posted by searchman on Sat, 30 Nov 2019 14:09:47 -0800
Flyway execution error:'user_variables_by_thread'table does not have SELECT privilege problem solving
Share a recent problem encountered throughout Flyway and some solutions.If you don't know Flyway yet, I suggest you take a look at this article first Use Flyway in Spring Boot to manage database versions
Problem Description
The version information used for the project described in the problem appears as follows:
Spring Boot: 2.1.3
Flyway:5.2.4 ...
Posted by Fizzgig on Thu, 28 Nov 2019 18:19:51 -0800
The principle and Simulation of mysql database connection pool
What is a database connection pool?
When the system uses JDBC technology to access the database, it will create a connection object, and the creation process of the object is very resource consuming, and the time to create the object is also very long. Assuming that the system has 10000 accesses a day, then 10000 connection objects will be crea ...
Posted by Dowdy on Thu, 28 Nov 2019 04:52:55 -0800
Reading and writing data in Mybatis
The nature of data reading and writing
No matter which ORM framework, the essence of data reading and writing is to encapsulate JDBC. Its main purpose is to simplify the development process of JDBC, so that developers pay more attention to business. The following is the core process of JDBC:
Register JDBC driver (Class.forName("XXX") ...
Posted by harman on Tue, 26 Nov 2019 00:54:05 -0800
springboot multiple data sources, the simplest way to integrate
brief introduction
I believe that if you have configured too many data sources or are about to configure too many data sources, you will find the following solutions on the Internet:
1. Use AOP slice to switch dynamic data source
2. Use basePackages of MapperScan to configure different mapper directories and template s
3. Database agent middle ...
Posted by DeathfireD on Mon, 25 Nov 2019 23:50:08 -0800
mybatis Lecture--Tags and TypeHandler Use
[TOC]
Quote
The first two sections describe the Mybatis environment setup and the lifecycle of its components.These are our essential skills to get started with Mybatis.With the padding from the first two articles, we're going to dig into Mybatis today and fill the hole we buried before.
XML Configuration Label
overview
<?xml version="1.0" ...
Posted by Profector on Mon, 25 Nov 2019 18:26:41 -0800
SSM framework integration environment construction
1. Jar package for spring framework, jar package for mybatis, jar package for spring MVC, integration jar package, database connection pool package
2. The tool I use is IDEA
jar package required for integration:
Write profile
db.properties
jdbc.driver=com.mysql.cj.jdbc.Driver //Remember to add cj
jdbc.url=jdbc ...
Posted by Steve Mellor on Mon, 25 Nov 2019 13:27:19 -0800
Spark - upgraded data source JDBC 2
In the data source of spark, only Append, Overwrite, ErrorIfExists, Ignore are supported. But almost all of our online businesses need the upsert function, that is, the existing data must not be overwritten. In mysql, we use: ON DUPLICATE KEY UPDATE. Is there such an implementation? Official: sorry, no, dounine: I have it. You can ...
Posted by smordue on Fri, 22 Nov 2019 07:03:24 -0800
Know Your Own and Know Your Own: Persistent Evolution
Introduction
When it comes to the word "persistence", people who operate databases every day are certainly familiar with it.
In persistence, the two giants that have caught the attention of developers are Hibernate and MyBatis, and many developers often compare them.Google is a comparison of the two.
Hibernate and MyBatis, like java ...
Posted by ClanCC on Thu, 21 Nov 2019 12:14:01 -0800
druid configuration of ssm+maven Ali open source project
What is Druid?
Druid is the best database connection pool in the Java language. Druid can provide powerful monitoring and extension functions.
Project configuration
1. Add dependency
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<vers ...
Posted by yujikaido on Wed, 20 Nov 2019 10:05:13 -0800