SpringBoot from getting started to giving up, Chapter 4, integrating JDBC Druid Mybatis
SpringBoot from getting started to giving up, Chapter 4
I. springboot integrates JDBC and DRUID
1,POM
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
&l ...
Added by hthighway on Thu, 14 Nov 2019 16:41:21 +0200
Java connects to SQL Server through JDBC
Download Microsoft JDBC Driver 4.0 for SQL Server
Download here: http://www.microsoft.com/zh-cn/download/details.aspx?id=11774
1.
Create a new folder on disk E, named sqljdbc 42, and copy sqljdbc 42.jar into it.
Right click my computer properties advanced system settings environment variable, double-click the CLASSPATH variable (or select C ...
Added by franknu on Tue, 12 Nov 2019 19:53:02 +0200
Idea + mybatis Generator + Oracle reverse code generation
Mybatis generator can automatically generate dao, entity and mapper files corresponding to database tables. Here, take oracle as an example
My project directory is as follows:
Create dao and entity files under demo and mapper under resource, and the automatically generated files will be in these three folders.
I. create a new ...
Added by Diego17 on Sun, 10 Nov 2019 23:00:47 +0200
Best practice | RDS & POLARDB archiving to X-Pack Spark computing
The X-Pack Spark service provides Redis, Cassandra, MongoDB, HBase and RDS storage services with the ability of complex analysis, streaming processing, warehousing and machine learning through external computing resources, so as to better solve user data processing related scenario problems.
RDS & polardb sub table archiving to X-Pack S ...
Added by cyber_ghost on Thu, 07 Nov 2019 08:55:51 +0200
2. hbase -- integrate Phoenix to implement SQL like operation hbase
I. Phoenix overview
1, introductionPhoenix can be understood as the query engine of HBase, Phoenix, a project open-source by saleforce.com, and then donated to Apache. It is equivalent to a Java middleware to help developers, such as using jdbc to access relational databases, and accessing NoSql database HBase.
phoenix, the table and data of o ...
Added by zubinkasad on Tue, 05 Nov 2019 02:24:38 +0200
SQL statement precompile (query)
SQL statement precompile
Pre compilation of SQL statements can prevent SQL injection and improve security because SQL statements have been precompiled before the program runs. Before the first operation of the database, SQL statements have been analyzed, compiled and optimized by the database. The corre ...
Added by Scummy12 on Thu, 31 Oct 2019 10:05:39 +0200
JDBC SQL injection and transactions
First, prepare the database data, and fill in the data in the database.
Independent abstract method, reuse.
First, initialize the interface (define a method)
Second, verify the user name and password (define another method)
package com.bjpowernode.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
impor ...
Added by shatztal on Wed, 30 Oct 2019 09:32:06 +0200
Using logstash to synchronize MySQL data to ES
Summary
But without special business requirements, the official logstash has its advantages.
when using logstash, we should first understand its characteristics, and then decide whether to use i ...
Added by ztealmax on Tue, 22 Oct 2019 21:17:59 +0300
SSM implementation of paging fuzzy query
SSM implementation of paging fuzzy query
I. preparations
1,pom.xml
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test< ...
Added by launchcode on Tue, 22 Oct 2019 18:40:46 +0300
Springboot2.x + ShardingSphere to realize database and table division
In the previous article, we talked about the read-write separation based on Mysql8 (there is a link at the end of the article). This time, we talked about the implementation process of the sub database and sub table.
conceptual analysis
Vertical fragmentation
According to the way of business split, it is called vertical split, also known as ver ...
Added by Revos on Thu, 17 Oct 2019 13:01:48 +0300