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&lt ...

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