Collation stage 1-9 in Mysql

mysql's collation roughly means character sorting. First, characters are inherently size-insensitive, so a rule of character order is required for character >, =, <operations.collation does this either by setting the character order of a table or by setting the character order of a field separately.A character ty ...

Posted by bailo81 on Fri, 01 May 2020 18:36:33 -0700

2.1 mybatis? Helloworld01 (native programming)

To learn mybatis, you can follow the official website to learn http://www.mybatis.org/mybatis-3/configuration.html ා properties There are two ways to write mybatis? HelloWorld 2.2 Mybatis? Helloworld02 (interface programming) Now, the second way is commonly used: interface programming Let's look at the first way: Step: Import jar packa ...

Posted by areid on Fri, 01 May 2020 18:08:20 -0700

For those new features that may be annoying in 11gR2, a list helps you get rid of the hassle of upgrading 11gR2

There are many friends who can't take the courage to upgrade to 11gR2 because the potential features of 11gR2 may cause trouble for the stable operation of the system after upgrade. In fact, some features introduced by Oracle in the development of new RDBMS software have good ideas, but often these ideas will bring variables to the stable Appli ...

Posted by newjsguy on Fri, 01 May 2020 17:53:49 -0700

PostgreSQL black technology - recursive dichotomy for Chinese character segmentation

PostgreSQL black technology - recursive dichotomy for Chinese character segmentation This article is PostgreSQL fuzzy query In the improved version, the number and English words are extracted separately without segmentation. 1. Create a punctuation function in the clear text At present, the punctuation I can think ...

Posted by rajbal on Fri, 01 May 2020 17:33:16 -0700

unity3d and php background simple interaction

Environmental Science: Unity2017.3.0f3 Mysql5.7.20 Wampserver64 Create a new folder named unity in the www directory of Wampserver64. 1. unity3d requests php by get 1. Code on unity side using UnityEngine; using System.Collections; public class phpUnity1 : MonoBehaviour { private string url = "http://localhost/unity/phpunity1.ph ...

Posted by subesc on Fri, 01 May 2020 17:04:34 -0700

Java learning notes 22 (Date class, DateFormat class)

Date, time and date class. Here we talk about the util package, not the sql package Date: indicates a specific time instant, accurate to milliseconds (1000 milliseconds = 1 second) Time and date operations are based on milliseconds Time origin: January 1, 1970, 0:00:00, 0:00, 0:00 Get the millisecond value of the current time: public class Dat ...

Posted by acrayne on Thu, 30 Apr 2020 23:44:30 -0700

7 Mycat principle analysis DDL statement processing

Previously, we have talked about how to judge the sql type by Mycat, and then handle it differently for different types of sql [Mycat principle analysis - SQL statement processing] , let's take a look at the DDL statement and how Mycat handles it. In combination with the code in ServerParse.java, let's take a look at t ...

Posted by tommyy on Thu, 30 Apr 2020 20:08:06 -0700

To write JAVA to Xiaobai to link MySQL database (JDBC):

As a review and summary note, I have listed several jdbc steps, followed by a simple example, in which the try block is handled by the reader /* *1. Download the driver package: com.mysql.jdbc.Driver. There are a lot of download resources on the Internet. You can find duniang yourself, which will not be provided here; * *2. Import the drive ...

Posted by tomas.srna on Thu, 30 Apr 2020 14:14:05 -0700

The use of JDBC and SQL injection

Basic JDBC usage: package demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.junit.Test; /** * Test query class for all users * */ public class QueryAll { @Test public void testQueryAll(){ Connection conn= nul ...

Posted by gat on Thu, 30 Apr 2020 08:28:14 -0700

SQL ite3 database C language simple operation basic data search (3)

SQL ite3 database C language simple operation basic data search (3) Overview: the creation, addition, deletion, and modification of sqlite3 database have all been mentioned. Today, it is the search of the database and the application of the core of database comparison. If the previous API is used for execution, because there is a return value ...

Posted by csj16 on Thu, 30 Apr 2020 00:17:15 -0700