jdbc mysql 锁_mysql数据库行级锁的使用（二）

packagecom.robert.RedisTest;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.Calendar;importjava.util.concurrent.TimeUnit;public classJDBCCountLockTest {private static String jdbcUrl = "jdbc:mysql://localhost:3306/test";private static String username = "test";private static String password = "test";public static voidmain(String[] args) {new Thread(newRunnable(){public voidrun(){try{

Class.forName("com.mysql.jdbc.Driver");

Connection connection=DriverManager.getConnection(jdbcUrl,username,password);

connection.setAutoCommit(false);

Statement st=connection.createStatement();

st.executeQuery("select count(1) num from table_name where mobile_phone = '13651969037' and rule_id='39' for update");

TimeUnit.SECONDS.sleep(5);

connection.commit();

System.out.println("Thread 1 commit "+Calendar.getInstance().getTime());

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

}catch(InterruptedException e) {

e.printStackTrace();

}

}

}).start();new Thread(newRunnable(){public voidrun(){try{

Class.forName("com.mysql.jdbc.Driver");

Connection connection=DriverManager.getConnection(jdbcUrl,username,password);

connection.setAutoCommit(false);

Statement st=connection.createStatement();

TimeUnit.SECONDS.sleep(1);

st.executeQuery("select * from table_name where id=4139 for update");

System.out.println("Thread 2 executeQuery finish "+Calendar.getInstance().getTime());

String update_sql_1= "update table_name set rule_id='40' where id = '4139'";

st.executeUpdate(update_sql_1);

System.out.println("Thread 2 executeUpdate finish "+Calendar.getInstance().getTime());

connection.commit();

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

e.printStackTrace();

}catch(InterruptedException e) {

e.printStackTrace();

}

}

}).start();

}

}