package com.comm.db;

import java.sql.*;
import java.util.*;

import javax.sql.*;

import com.comm.*;
import com.comm.vo.*;

public interface DBMgrInterface {
    public void setDatasource(DataSource ds) throws AppException;

    public void begin() throws SQLException;

    public void commit() throws SQLException;

    public void rollback() throws SQLException;

    public Connection getConnection() throws SQLException;

    public int execute(String sql, Vector param) throws SQLException;

    public int execute(String sql, Vector param
                       , Connection conn) throws SQLException;

    public int[] executeBatch(String sql, Vector param) throws SQLException;

    public int[] executeBatch(Vector sqls) throws SQLException;

    public int[] executeBatch(Vector sqls, Connection conn) throws SQLException;

    public int[] executeBatch(String sql, Vector params
                              , Connection conn) throws SQLException;

    public int execute(String sql) throws SQLException;

    public Vector getResult(String sql, Vector param) throws SQLException;

    public Vector getResult(String sql) throws SQLException;

    public ListVO getResult(String sql, Vector param
                            , ListVO lvo) throws SQLException;

    public int getRowCount(String sqlStr, Vector param) throws SQLException;

    public int getRowCount(String sqlStr) throws SQLException;

    public String toOracleDarkString(String s);

    public String toOracleString(String number);

    public Object toOracleString(Object object);

    public String toOracleDarkString(Object object);

    public String getSQLString(Vector v);

    public String getSQLInt(Vector v);

    public Vector convertResultset(ResultSet rs) throws
            SQLException;

}