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