[JAVA+oracle] database comprehensive experiment -- educational administration management system

preface This experiment used javaswing, which has not been written for a long time, in which the use of various components took some time to review; The biggest problem I encountered was how to connect java and oracle. This problem made me work all night. At the beginning, I used eclipse, and the code was no problem. I couldn't connect with li ...

Added by velkymx on Fri, 28 Jan 2022 07:58:45 +0200

MySql learning notes

MySql learning notes 1, SQL, DB, DBMS DB: the database actually exists as a file on the hard diskDBMS: database management system, softwareSQL: Structured Query Language 2, Watch Table - table is the basic unit of database. All data is stored in the tableA table includes rows and columns: Line: called data and recordColumns: called field ...

Added by khaldryck on Fri, 28 Jan 2022 03:08:30 +0200

MyBatis framework quick start

1. Preparatory work Download mybatis: https://github.com/mybatis/mybatis-3/releases Download mysql driver: https://mvnrepository.com/artifact/mysql/mysql-connector-java Here I use the latest version of mybatis-3.5.9 and mysql-connector-java-8.0.22 jar. 2. Build development environment (1) Create mysql database and tables Database name: ...

Added by Frozenlight777 on Fri, 28 Jan 2022 02:27:03 +0200

Learning diary [Redis]

Redis 1. Purchase and arrange ECS (https://i.loli.net/2021/06/22/j8ReENFV5G3mtyq.png)] 2. Download and install redis [the external chain image transfer fails. The source station may have an anti-theft chain mechanism. It is recommended to save the image and upload it directly (img-uqcogsbr-1624360166546)( https://i.loli.net/2021/06/22/4sDk5 ...

Added by Otoom on Thu, 27 Jan 2022 18:43:57 +0200

Oracle FAQ

Type of problem: literal does not match format stringField content display NAView all columns in the tableORA-00904: invalid identifier is invalid(full) year must be between -4713 and 9999, and not be 0Judge whether oracle is not emptydate format picture ends before converting entire input Demand: query by using date as criteria The tables ...

Added by arun4444 on Thu, 27 Jan 2022 17:10:34 +0200

sql injection Journal

Pre school instructions In MySQL version 5.0 and above, information is defined by default to facilitate management_ Schema database is used to store database meta information, including table schemata (database name), table (table name) and columns (field name and column name) Basic syntax learning of sql statements https://www.w3school.com.c ...

Added by piyushsharmajec on Thu, 27 Jan 2022 14:46:16 +0200

Deployment of primary and standby clusters of Dameng database

1, Network configuration: Database server name db0 (host) db1 (standby) dmm (monitor) Business service name dm_server Service IP 192.168.222.129 192.168.222.128 Heartbeat IP 10.10.1.115 10.10.1.116 10.10.1.117 PORT_NUM 5236 MAL_PORT 7336 MAL_DW_PORT 7536 MAL_INST_DW_PORT 7436 MAL_INST_PORT (consistent with PORT_NUM) ...

Added by awais_ciit on Thu, 27 Jan 2022 14:09:15 +0200

Qt uses MVC and database singleton mode to realize login function

1, Briefly describe MVC and singleton mode 1. MVC design pattern Function: effectively separate data and user interface.Composition: model layer (representing data), view layer (representing user interface), control layer controller (defining user operations on the interface). 2. MVC frame diagram 3. Use MVC architecture to realize the pro ...

Added by rocket on Thu, 27 Jan 2022 12:59:03 +0200

Python linkage CSV and MySQL + a requirement implementation

Python linked CSV and MySQL 1, Make sure MySQL is available After MySQL is installed (the simplest installation method is to download the installation package from the official website and then install it step by step), it's time to operate ~ % mysql --version % zsh: command not found: mysql Copy code command not found: mysql appears most ...

Added by argyrism on Thu, 27 Jan 2022 10:22:28 +0200

Super easy to use database design document generation tool

Original statement: This article is original by the author (Magic good), which can be used as learning reference reprint, but the source should be indicated. It is forbidden to use it in commercial and other ways without permission, otherwise you will bear the consequences! Preface overview With the increasing complexity of development scen ...

Added by Kuraden on Thu, 27 Jan 2022 10:06:37 +0200