JDBC links to local MySQL databases, creates table structures, and adds data and queries

First, we need to download the JDBC jar package. In this project, jar is placed in the lib directory. You can use my mysql-connector-java-5.1.42-bin.jar package directly. Then add a Main, link MySQL database with JDBC, create table structure, add data and query data Specific code: public class Main{ public static void main(String[] a ...

Posted on Wed, 19 Jun 2019 12:14:32 -0700 by ramjai

About nginx_auth_mysql authentication module

My previous blog "Installation and configuration of httpd 2.x, mod_auth_mysql module and support for aes encryption" As mentioned in the article mod_auth_mysql Module is a third-party authentication module for Apache httpd. In this article, we will introduce a module corresponding to Nginx. nginx_auth_mysql. Dead workdownload nginx_au ...

Posted on Wed, 19 Jun 2019 11:36:04 -0700 by allenmak

Android connects to MySql database through JDBC

Android connects to MySql database through JDBC Adding Access Permissions to Networks in android Add permissions to Android Manifest file ... </application> <uses-permission android:name="android.permission.INTERNET" /> </manifest> Close Windows Firewall (Click on the control panel, find the Windows firew ...

Posted on Wed, 19 Jun 2019 10:56:12 -0700 by lj11

Article title mybatis project construction process with source download

Integrated environment: IntelliJ IDEA 2016.3.2 JRE: 1.8.0_112-release-408-b6 x86_64 Install mysql locally, create database user.db, and create a new table named Person The TABLE statement is as follows: CREATE TABLE `Person` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `userName` varchar(255) DEFAULT NULL, `age` int(11) DEFAUL ...

Posted on Tue, 18 Jun 2019 18:24:36 -0700 by jamiller

Use of mongodb in Spring boot

MongoDB is a product between relational database and non-relational database, which has the most abundant functions and resembles relational database. The data structure he supports is very loose and is similar to json's bjson format, so it can store more complex data types. Mongo's greatest feature is that the query language he supports is ver ...

Posted on Sat, 15 Jun 2019 17:53:36 -0700 by AmiraSan

MYSQL must read notes

Chapter 9 Searching with Regular Expressions Chapter X Creation of Calculating Fields Chapter 11 Use of Data Processing Functions Chapter XII Summary Data 12.1 Aggregate Function We often need to aggregate data rather than actually retrieve it, providing an aggregation function for MySQL. Determines the number of rows in the tab ...

Posted on Sat, 15 Jun 2019 17:28:00 -0700 by rxero

Hibernate uses annotations for ORM mapping instances

In the previous blog, we mapped entity classes and tables through xml configuration files, but in the past two years, more projects have used annotations to map some stable entity classes to ORM, which makes programming more concise and simple. In fact, there are not too many changes in the process of ORM mapping using annotations and xml mappi ...

Posted on Sat, 15 Jun 2019 16:23:12 -0700 by cscheuble

MySQL transaction (mysql TRANSACTION) (1)

I recently encountered Mysql transaction problems. First check and learn. What is a transaction? I haven't found the most standard definition document, but I feel that the most standard in Wikipedia is below the Wikipedia. Definition: A database transaction usually contains a sequence of read/write operations to the database. Its exist ...

Posted on Sat, 15 Jun 2019 13:46:44 -0700 by nepeaNMedia

Simple Principle and Realization Method of Master-slave Replication of MYSQL Database

1. Principle of master-slave replication Affecting the operation of MySQL-A database, after the execution of the database, it will be written to the local log system A, and real-time database operation events in the log system will be sent to MySQL-B through the 3306 port of MySQL-A through the network, then written to the local system log ...

Posted on Fri, 14 Jun 2019 15:53:17 -0700 by jgetner

MySQL -- Common Functions

Character function Function name Effect CONCAT() Character Connection CANCAT_WS("delimiter", "value", "value",...) Character join with specified delimiter FORMAT() NumberFormatter LOWER() Convert to lowercase UPPER() uppercase LEFT() Interception from the left RIGHT() Interception ...

Posted on Fri, 14 Jun 2019 13:49:03 -0700 by DRTechie