[size=medium]数据库的事务平时很少用到,只有评价线的一个修改隐私的功能用到了事务处理。今天写了个java关于mysql的事务处理类,实现了事务的一些功能。
运行之后输出结果:
id:1
name:tina
age:25
sex:female
mysql数据库里tina_test表为:
[img]http://dl.iteye.com/upload/attachment/0081/6619/ce342a26-2ff3-358a-a534-96f71b041f94.jpg[/img]
[/size]
package com.tina.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author tina.wyn
*
*/
public class TestCommit {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost/mysql";
conn = DriverManager.getConnection(url, "root", "");
boolean autoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
Statement stmt=conn.createStatement();
stmt.executeUpdate("insert into tina_test values(1,'tina',25,'female')");
stmt.executeUpdate("insert into tina_test values(2,'mark',28,'male')");
ResultSet rSet = stmt.executeQuery("select * from tina_test");
while (rSet.next()) {
System.out.println("\tid:" + rSet.getInt(1));
System.out.println("\tname:" + rSet.getString(2));
System.out.println("\tage:"+rSet.getInt(3));
System.out.println("\tsex:"+rSet.getString(4));
//提交事务
conn.commit();
//恢复原来的提交模式
conn.setAutoCommit(autoCommit);
stmt.close();
}
} catch (Exception e) {
System.out.println("操作失败,任务撤销!" +e);
try {
//回滚,取消上述操作
conn.rollback();
} catch (Exception e1) {
e1.printStackTrace();
}
finally{
try {
if (conn!=null) {
conn.close();
}
}catch (SQLException e1) {
e1.printStackTrace();
}
}
}
}
}
运行之后输出结果:
id:1
name:tina
age:25
sex:female
mysql数据库里tina_test表为:
[img]http://dl.iteye.com/upload/attachment/0081/6619/ce342a26-2ff3-358a-a534-96f71b041f94.jpg[/img]
[/size]