Some modifications of the Java Project database migrating from Oracle to Java in MySQL

Java Project database migrated from Oracle to MySQL:

MySQL connection URL in the role of Useunicode=true&characterencoding=utf-8: http://blog.csdn.net/afgasdg/article/details/6941712.

Pom.xml File Dependency modified: http://mvnrepository.com/artifact/mysql/mysql-connector-java/6.0.6.

=========================================================================================================

References to primary key IDs in the original mapper file:

1) Delete the primary key ID field and the use of the sequence in Oracle;

2) in the corresponding MySQL table, set the primary key ID to self-increment, and note the type, length settings.

----------------------------

Bulk INSERT modifications in the Mapper file:

The corresponding Oracle is a cyclic generated stored procedure statement;

The corresponding MySQL is the second half of the cyclic generation of the assigned sentence.

=========================================

Some modifications of the Java Project database migrating from Oracle to Java in MySQL