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 classJDBCTest {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();

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

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

TimeUnit.SECONDS.sleep(5);

connection.commit();

System.out.println("Thread 1 after "+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();

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

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

TimeUnit.SECONDS.sleep(10);

connection.commit();

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

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

}catch(InterruptedException e) {

e.printStackTrace();

}

}

}).start();

}

}