abstractquerier.java

oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码oa源码

/*
 * AbstractQuerier.java
 *
 * Created on 2007年3月1日, 下午2:16
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package com.huashi.util;

import com.huashi.util.jdbc.ConnectionUtil;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

/**
 *
 * @author dell
 */
public abstract class AbstractQuerier implements Querier {
    
    Connection connection = null;
    Statement statement = null;
    ResultSet resultSet = null;
    
    Map parameters = new HashMap();
    
    String sql = "";
    
    String[] columnLabels = {};
    
    public String getColumnLabel(int column) {
        try {
            return columnLabels[column];
        } catch (Exception ex) {
            return "";
        }
    }

    public ResultSet getResultSet() {
        return resultSet;
    }

    public void setConnection(Connection conn) {
        this.connection = conn;
    }

    public void close() {
        ConnectionUtil.closeStatement(statement);
        ConnectionUtil.closeConnection(connection);
    }

    public void setParameters(Map params) {
        parameters.putAll(params);
    }

    public void setParameter(Object name, Object value) {
        parameters.put(name, value);
    }

    public Object getParameter(Object name) {
        return parameters.get(name);
    }

    public ResultSetMetaData getResultSetMetaData() {
        ResultSetMetaData meta = null;
        if (resultSet != null) {
            try {
                meta = resultSet.getMetaData();
            } catch (SQLException ex) {
                meta = null;
            }
        }
        return meta;
    }
    
    protected abstract void buildStatement() throws SQLException;
    

}