testutil.java

java写的blog

/*
 * Created on 2004-9-30
 * Author: Xuefeng, Copyright (C) 2004, Xuefeng.
 */
package org.crystalblog.util;

import java.sql.Connection;
import java.sql.Statement;

import org.crystalblog.dao.ibatis.SqlConfig;

import com.ibatis.sqlmap.client.SqlMapClient;

/**
 * TODO Description here...
 * 
 * @author Xuefeng
 */
public abstract class TestUtil {

    private static SqlMapClient sqlMap = SqlConfig.getSqlMapInstance();

    public static void executeSQL(String sql) {
        try {
            sqlMap.startTransaction();
            Connection conn = sqlMap.getCurrentConnection();
            Statement sm = conn.createStatement();
            sm.executeUpdate(sql);
            sm.close();
            conn.commit();
            conn.close();
            sqlMap.commitTransaction();
        }
        catch(Exception e) {
            e.printStackTrace();
        }
        finally {
            try {
                sqlMap.endTransaction();
            }catch(Exception e) {}
        }
    }
}