使用mysql驱动连接tidb_jdbc与TiDB数据库交互的过程

// 加载驱动程序

Class.forName(driver);//连接数据库

Connection conn =DriverManager.getConnection(url, user, password);==>(cmd=mysql.ComQuery)/* mysql-connector-java-6.0.6 ( Revision: 3dab84f4d9bede3cdd14d57b99e9e98a02a5b97d ) */

SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client,

@@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results,

@@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout,

@@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet,

@@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size,

@@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone,

@@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout

==>(cmd=mysql.ComQuery)SET NAMES utf8

==>(cmd=mysql.ComQuery)SET character_set_results = NULL

==>(cmd=mysql.ComQuery)SET autocommit=1

//关闭自动提交

conn.setAutoCommit(false);==>(cmd=mysql.ComQuery)SET autocommit=0

//创建statement用来执行SQL语句

Statement stmt =conn.createStatement();//要执行的SQL语句

ResultSet rs1 = stmt.executeQuery("select * from nation");==>(cmd=mysql.ComQuery)select *from nation

ResultSet rs2= stmt.executeQuery("select * from region");==>(cmd=mysql.ComQuery)select *from region//提交

conn.commit();==>(cmd=mysql.ComQuery)commit//关闭连接rs1.close();

rs2.close();

stmt.close();

conn.close();==>(cmd=mysql.ComQuery)rollback

==>(cmd=mysql.ComQuit))