怎样在项目中开启JDBC事物控制

首先，先建一个datebase.properties文件，用于读取配置文件，里面装的代码如下：

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/smbms?useUnicode=true&characterEncoding=utf-8
user=root
password=123456

smbms为mysql的数据库实例，user为mysql的用户名，password为mysql的密码

下面是一个Dao的测试类：

package com.smbms.dao.user;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.smbms.tools.ConfigManager;

public class UserDao2 {
	public int add(){
		int updateRows=0;
		String driver=ConfigManager.getInstance().getValue("driver");
		String url=ConfigManager.getInstance().getValue("url");
		String user=ConfigManager.getInstance().getValue("user");
		String password=ConfigManager.getInstance().getValue("password");
		
		Connection connection=null;
		PreparedStatement pstm=null;
		try {
			Class.forName(driver);
			connection=DriverManager.getConnection(url, user, password);
			connection.setAutoCommit(false);//开启JDBC事物控制
			String sql="insert into smbms_users (userid,username) values(?,?)";
			pstm=connection.prepareStatement(sql);
			pstm.setInt(1, 34);
			pstm.setString(2, "小双");
			updateRows=pstm.executeUpdate();
			connection.commit();
			if(updateRows>0){
				System.out.println("add success!");
			}else{
				System.out.println("add failed!");
			}
		} catch (Exception e) {
			e.printStackTrace();
			try {
				connection.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		}finally{
			try {
				pstm.close();
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
		return updateRows;
	}
	public static void main(String[] args){
		UserDao2 userDao2=new UserDao2();
		userDao2.add();
	}

}