前提
最近在某个公司实习,框架使用的是springmvc+spring+mybatis,具体名字就不说了,所有事务都没有用无法回滚,导师叫我和db人员对接,我就写了一个Jdbc的原生的测试测试代码如下:
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//url写测试中间件的,这里我替换了
String url="jdbc:mysql://localhost:3306/taotao?characterEncoding=utf-8";
String username="root";
String passwd="123456";
Connection conn= null;
try {
conn = DriverManager.getConnection(url, username, passwd);
} catch (SQLException e) {
e.printStackTrace();
}
try{
conn.setAutoCommit(false);
PreparedStatement pstmt = conn.prepareStatement("insert into lztt (text) VALUES (?)") ;
pstmt.execute("start TRANSACTION ");
pstmt.setString(1,"memeda");
pstmt.executeUpdate();
PreparedStatement pstmt1 = conn.prepareStatement("insert into lztt (text) VALUES (?)") ;
pstmt1.setString(1,"dsajdijsaoidjiosajdoisajdoijsaoidjsaoijdoisajidjsoajdijsaidjsajdsad");
pstmt1.executeUpdate();