JDBC learning notes 02 [detailed explanation of ResultSet class, JDBC login case exercise, detailed explanation of PreparedStatement class]

Dark horse programmer - JDBC document (Tencent micro cloud) JDBC notes pdf: https://share.weiyun.com/Kxy7LmRmJDBC learning notes 01 [JDBC quick start, detailed explanation of various classes of JDBC, CRUD exercise of JDBC][day01]JDBC learning notes 02 [detailed explanation of ResultSet class, JDBC login case exercise, detailed explanation of P ...

Posted by lelelow on Mon, 25 Apr 2022 03:04:53 +0300

MySQL log management, backup and recovery of database

Study preparation: first create a table (I use the previous table here) mysql -u root -p create database school; use school; create table class( id int(10) not null, name varchar(20) not null, sex char(2) not null, cardid varchar(20) not null, phone varchar(11), address varchar(50)); desc class; insert into class values ('1','zhangsan', ...

Posted by omniuni on Mon, 25 Apr 2022 00:29:16 +0300

[Mysql] ORDER BY sort and retrieve data

Sorting query results is a very common requirement. We can use the ORDER BY clause to achieve the purpose The ORDER BY clause takes the name of one or more columns and sorts the output accordingly Typically, the columns used in the ORDER BY clause will be the columns selected for display. However, in fact, this is not necessary. It is complet ...

Posted by jbol on Sun, 24 Apr 2022 19:05:29 +0300

Java project: enterprise personnel system (java+SpringBoot+Vue+ElementUI+maven+mysql)

Source code acquisition: download from "resources" on the blog home page! Project introduction The functions of the personnel management system include six modules: personnel communication, employee information, personnel evaluation, rewards and punishments, training management, salary management, statistical analysis, and system ...

Posted by clarencek on Sat, 23 Apr 2022 10:15:17 +0300

Java Software Development: Custom MyBatis persistence layer framework

1 framework overview 1.1 what is a framework Framework is the reusable design of the whole or part of the system, which is expressed as a group of abstract components and the method of interaction between component instances; Another definition holds that a framework is an application skeleton that can be customized by application develop ...

Posted by dearsina on Thu, 21 Apr 2022 03:42:25 +0300

springboot integrates Mycat to realize read-write separation

  Environment construction Demo with windows version of mycat Step 1: Download Mycat Download mycat address:https://github.com/MyCATApache/Mycat-download/tree/master/1.4-RELEASE  After downloading for a long time, I can't use it. Share a compressed package I collected before Link: https://pan.baidu.com/s/1B_pYJA1vSqLKlrBunTUBUw   Ext ...

Posted by adaykin on Thu, 21 Apr 2022 01:20:53 +0300

MYSQL basic statement - basic operation of database

catalogue preface 1, Install MYSQL as an RPM package 1. Install required packages 2. Test database connection 3. MYSQL configure security Wizard 2, Basic operation of database 1. View database 2. Create database 3. Directory of database 4. Select the database to operate on 5. Delete database preface MYSQL service overview: MySQ ...

Posted by markjoe on Wed, 20 Apr 2022 19:29:00 +0300

[MySQL core statement query] required for data analysts

This article data analyst must see! Last time I talked about the basics of database and mysql. This time, let's learn some of the most commonly used core query statements in MySQL. The framed part is the focus of this section 1, Single table query SELECT Field name FROM Table name WHERE condition [GROUP BY Field name HAVING condition ORDER ...

Posted by Jaspal on Wed, 20 Apr 2022 16:58:51 +0300

The 10th Session of mysql - shardingsphere JDBC table and database splitting practice of mysql+springboot

As a back-end development, there should be more than a few people who have used mycat. Talk about the problems encountered by the author using mycat! A separate service is required. For the concept that we only have a series of connection addresses, sometimes we don't know when we hang up (because it is deployed by operation and maintenance, an ...

Posted by salmon on Wed, 20 Apr 2022 13:22:14 +0300

Database statements - getting started

database mysql database Create table - data type + Integer type int + Floating point type double + Date type date/timestamp + String type char varchar * variable varchar(n) The maximum length of characters must be given n Use: user name, password, ID number. n= 40 40 Bytes, 20 characters * Immutable is char ...

Posted by loganbest on Wed, 20 Apr 2022 07:21:11 +0300