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