dboperation.java

struts+iabtis的入门例子

/**
 * 
 */
package com.egt.bean;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;

/**
 * @author zhaidong
 *
 */
public class DBOperation
{
	private final String resource = "com/ibatis/xml/OracleMapConfig.xml";
	private SqlMapClient sqlMap = null;
    public DBOperation(){
        Reader reader = null;
        try 
        {
            reader = Resources.getResourceAsReader(resource);
        } 
        catch (IOException ex)
        {
            ex.printStackTrace();
        }
        sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
    }
    
    public Object selectObj(String sqlID,Object obj){
        Object result = null;
        try 
        {
            sqlMap.startTransaction();
            result = sqlMap.queryForObject(sqlID,obj);
            sqlMap.commitTransaction();
        } 
        catch (SQLException ex)
        {
            ex.printStackTrace();
        }
        return result;
    }
}