Enum, generics, reflection, JDBC integration
brief introduction
Environmental preparation
Project directory
jar package used
Database connection configuration
JDBC configuration file
Run tests
brief introduction
JDBC (Java database connectivity) is a Java API used to execute SQL statements. It can provide unified access to a variety of relationa ...
Added by asdf on Sun, 03 May 2020 15:38:15 +0300
Create table exception related to search path (HGDB)
The database objects created by HGDB are related to the value of the variable search [u path]. When creating objects, if no mode is specified, these objects will be created in the default mode, which is called pubulic. One exception is that another pattern first appears in search [u path. The following problem is thrown ...
Added by etones on Sun, 03 May 2020 11:31:52 +0300
Registration form of computer room charging system
Preface
The charge system of the computer room has entered the registration window. I feel that the computer room is the same as many places of the students, but because the computer room is completed by myself, and the help from the outside is less, I have to sort out the logic by myself and design the code by myself (most of them are to fin ...
Added by Stevis2002 on Sun, 03 May 2020 03:38:23 +0300
Java learning notes 51 (integrated project: home accounting system)
This case almost uses all the contents of the first 50 articles to realize a simple family accounting software
Function: add, delete, modify, query by criteria
Required jar package:
commons-dbcp-1.4.jar
commons-pool-1.5.6.jar
mysql-connector-java-5.1.37-bin.jar
commons-dbutils-1.6.jar
Database table creation:
/*
Create database
Name gjp
...
Added by yashvant on Sat, 02 May 2020 22:52:29 +0300
Simple operation of php and mysql
mysql is a fast, reliable and easy-to-use database system running on the server, which is often combined with php for web development.
There are two ways for php to connect to mysql:
mysql i ('i 'means improved): only for mysql
pdo (php data objects): can be used in many databases
mysqli connection mode can be divide ...
Added by hightechredneck on Sat, 02 May 2020 00:52:55 +0300
11gRAC local data file migration to ASM
Environment related:
OS: CentOS release 6.6
RAC: 11.2.0.4.0 dual node ASM Library
1. Cause of failure
Today, four data files are added in batches. add datafile '+ DATADG' in the second to fourth data file add SQL misses' + '. After oracle successfully adds the first data file, it is found that the second data fil ...
Added by grahamb314 on Fri, 01 May 2020 22:00:41 +0300
[machine room] query - combination
In terms of the basic information maintenance of students, the combination query code is the same,
Enter the conditions in the first line and click query;
If the first combination relationship is selected, you can only query by entering the second line of conditions;
Similarly, if you continue to select the second combination condition, co ...
Added by SwarleyAUS on Fri, 01 May 2020 21:30:53 +0300
Spring boot project uses redis database as cache
1. Import the jar package and build the project with maven and springboot:
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-redis</artifactId>
</dependency>
<dependency>
<groupId>org.springfr ...
Added by blueguitar on Fri, 01 May 2020 14:59:23 +0300
Complete experiment: statistical feature calculation of monitoring data based on spectral data
1. EXPERIMENTAL DATA
Links: https://pan.baidu.com/s/1CSgRQ8OXe50ya_DwkLX8yw
Extraction Code: kexq
2. Experimental Background
1.1 Experimental Background
(1) On-line monitoring of power equipment
On-line monitoring of power equipment refers to the continuous or periodic automatic monitoring and detection of the condition of power equipment with ...
Added by nuxy on Fri, 01 May 2020 11:58:03 +0300
Get database metadata
MySQL provides a variety of methods to obtain database metadata (information about the database and various objects in it):
*Various SHOW statements, such as SHOW DATABASES or SHOW TABLES;
*Information? Table in schema database;
*Command line programs, such as mysqlshow or mysqldump.
Use SHOW statement to get metadata
-- List accessible ...
Added by riyaz123 on Thu, 30 Apr 2020 21:47:29 +0300