[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