Student information management system based on Spring MVC + Spring + MyBatis

Resource download: https://download.csdn.net/download/weixin_44893902/45603211 Exercise point design: fuzzy query, delete, add 1, Language and environment Implementation language: JAVA language.Environment requirements: MyEclipse/Eclipse + Tomcat + MySql.Use technology: Jsp+Servlet+JavaBean or spring MVC + Spring + mybatis. 2, Realiz ...

Posted on Sun, 28 Nov 2021 22:36:28 -0500 by insanityonline

Lao Du MySQL 34 exercises

MYSQ Exercise Notes Data Course Structure DROP TABLE IF EXISTS EMP; DROP TABLE IF EXISTS DEPT; DROP TABLE IF EXISTS SALGRADE; CREATE TABLE DEPT (DEPTNO int(2) not null , DNAME VARCHAR(14) , LOC VARCHAR(13), primary key (DEPTNO) ); CREATE TABLE EMP (EMPNO int(4) not null , ENAME VARCHAR(10), JOB VARCHAR(9), MGR INT(4), ...

Posted on Sun, 28 Nov 2021 14:53:34 -0500 by EddieFoyJr

MySQL data table advanced operations and user permissions

1, Data table advanced operations 1. Clone the table and generate the data records of the data table into a new table Method 1: create table test1 like kfc; #Using the like method, copy the test1 table structure to generate the test2 table insert into test1 select * from kfc; Method 2: create table test2 (select * from kfc); ...

Posted on Sun, 28 Nov 2021 09:57:05 -0500 by graham

[advanced MySQL database] two major queries of interview questions (aggregate query and joint query)

Advanced MySQL 1, Aggregate query The functions and usage used in aggregate query are very similar to that of Excel. If you play NB in Excel, you can basically combine query, which is very easy. 😁😁🤗🤗 Aggregate query is related to rows. Merging query results according to row dimensions means merging multiple rows. 1.1 aggregate funct ...

Posted on Sun, 28 Nov 2021 09:42:39 -0500 by KCKTechs

MYSQL index analysis and optimization

MYSQL index analysis and optimization EXPLAIN MySQL provides an EXPLAIN command, which can analyze the SELECT statement and output the details of the SELECT execution for targeted optimization by developers. For example: EXPLAIN SELECT * from user WHERE id < 3; The output of the EXPLAIN command is roughly as follows: select_type R ...

Posted on Sat, 27 Nov 2021 22:18:58 -0500 by greatme

Transaction and index

affair Either all succeed or all fail Transaction principle: ACID principle, atomicity, consistency, isolation, persistence (dirty read, phantom read...) 1. Basic concepts Atomicity Either all succeed or all fail Consistency The data integrity before and after the transaction shall be consistent Isolation Transaction isolation is ...

Posted on Sat, 27 Nov 2021 21:23:21 -0500 by Blissey

Performance optimization of Mysql

Performance optimization of Mysql 1. Reference book: MYSQL 5.5 learning from scratchMySQL performance optimization can make MySQL run faster and save resources by reasonably arranging resources and adjusting system parameters. MySQL performance optimization includes query speed optimization, update speed optimization, MySQL server optimization ...

Posted on Sat, 27 Nov 2021 21:01:24 -0500 by electrix

JDBC usage details

introduction JDBC (Java DataBase Connectivity) is a method for Java to connect to a database; In fact, the essence is a set of interfaces customized by SUN company, which can realize the connection between Java and various databases, as shown in the following figure: Note: This paper uses IDEA demonstration, and the database uses MySQL datab ...

Posted on Sat, 27 Nov 2021 18:07:09 -0500 by heyjohnlim

Mysql Uninstall and Install

1. Mysql Uninstall Reference connection: https://blog.csdn.net/qq_41140741/article/details/81489531 Shortcut win+r Enter regedit to enter the registry and find HKEY_ LOCAL_ MACHINESYSTEMControlSet001ServicesEventlogApplication\MySQL Folder Delete Delete HKEY_ LOCAL_ MACHINESYSTEM\ControlSet002ServicesEventlogApplication\MySQL f ...

Posted on Sat, 27 Nov 2021 13:32:31 -0500 by krupapatel

DQL language learning

Alias the field during query (if there are special symbols in the alias, it is recommended to enclose the alias in double quotation marks / single quotation marks) select Column name 1 as Alias 1, Column name 2 as Alias 2 from Table name; select Column name 1 Alias 1, Column name 2 Alias 2 from Table name; ...

Posted on Fri, 26 Nov 2021 22:16:23 -0500 by midgar777