yml configuration file in SpringBoot
1. Writing format of yml configuration file
The format is a property name separated by '.' in a normal configuration file, which is': 'and newline.
Example:
//Common format
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
//yml format
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
Note:
1. The annotation format i ...
Posted by incarnate on Wed, 06 Nov 2019 06:08:44 -0800
Spring boot implements simple addition, deletion, modification and query as well as conditional paging
condition
Use Spring boot, mybatis and mysql to realize the following functions
User list
User increase
Information modification
Information view
User search
paging
ps: the page engine uses the thmeleaf engine recommended by Spring boot
The renderings are as follows
step
...
Posted by Kainproductions on Mon, 04 Nov 2019 09:11:38 -0800
springboot-006-SpringBoot and data access
1. JDBC
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</depend ...
Posted by ziv on Mon, 04 Nov 2019 08:11:34 -0800
Import of sqoop | Hive|Hbase
Import data (cluster as object)
In Sqoop, the concept of "import" refers to the transfer of data from non big data cluster (RDBMS) to big data cluster (HDFS, HIVE, HBASE). It is called "import", that is, using the import keyword.
1 RDBMS to HDFS
1) make sure the Mysql service is turned on normally
2) create a new table i ...
Posted by Anders_Scales on Mon, 04 Nov 2019 07:26:50 -0800
[Hive] install Hive on Mac
I. installation
Hive installation: brew install hive
mysql installation: brew install mysql
Start MySQL: bash mysql.server start
2. Metabase configuration
Hive uses derby as the metabase by default. Here we use mysql to store metadata, and do some initialization configuration below
Log in to mysql: mysql -u root ...
Posted by jd307 on Sat, 02 Nov 2019 21:50:35 -0700
oracle's advanced use of [6] jdbc to access oracle stored procedures and functions
After learning the stored procedures and stored functions, this paper will explain how to access the stored procedures and stored functions of oracle through jdbc.
1 precondition
oracle has been installed, scott users have also unlocked [the author uses oracle 11g]
jdk installed and environment variables configured
Proficient ...
Posted by wilded1 on Sat, 02 Nov 2019 00:27:12 -0700
Jdbc native database connection
I haven't used the native database connection method for a long time, and I almost forget it. I'll take notes for this article.
Later, we use some advanced frameworks to operate the database, such as dbutil + c3p0, hibernate, JDBC template, etc. the advanced framework is also built on the basis of the bottom layer.
So ...
Posted by binarymonkey on Fri, 01 Nov 2019 06:46:41 -0700
Spring Cloud gateway service zuul three dynamic routing
zuul dynamic routing
Gateway service is the only access to traffic. Don't stop the service. So dynamic routing is particularly necessary.
Database dynamic routing is based on event refresh mechanism to modify zuul's routing properties.
DiscoveryClientRouteLocator
You can see that DiscoveryClientRouteLocator is the core processing class of the ...
Posted by Skepsis on Wed, 30 Oct 2019 17:58:38 -0700
The implementation of Mysql database operation based on JDBC JAVA language on IDEA: linking, searching, inserting, modifying and deleting records
On the JDBC operation of Mysql database
The general way of JAVA operating database
1. Loading drive
The purpose of loading driver is to make Java have the ability to link the specified database.
Java load driver only needs one line of code
//1. Loading drive
Class.forName("com.mysql.jdbc.Driver"); ...
Posted by joePHP on Wed, 30 Oct 2019 10:27:24 -0700
Fix Swing -- SQL test tool writing
Be careful:
1. The scope of use of the modifier private public protect is the current class, all classes, the same package and its subclasses; the use of static final;
2. The form of variable used for text is as this.settitle ("swing SQL test");
3. Do not write business logic code in ...
Posted by samusk on Wed, 30 Oct 2019 07:38:16 -0700