org.mactor.framework.data.jdbc
Class JdbcUtil

java.lang.Object
  org.mactor.framework.data.jdbc.JdbcUtil

public class JdbcUtil
extends java.lang.Object

Constructor Summary

JdbcUtil(java.lang.String driver, java.lang.String url, java.lang.String username, java.lang.String password)

Method Summary

DataTable	execQuerySql(java.lang.String sql)
void	execScript(java.io.File file, boolean ignoreSqlException)
DataTable	execScriptQuery(java.io.File file)
java.lang.String	execSingleCellQuerySql(java.lang.String sql)
java.lang.String	execSingleCellScriptQuery(java.io.File file)
void	execUpdateSql(java.lang.String sql)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcUtil

public JdbcUtil(java.lang.String driver,
                java.lang.String url,
                java.lang.String username,
                java.lang.String password)

Method Detail

execSingleCellScriptQuery

public java.lang.String execSingleCellScriptQuery(java.io.File file)
                                           throws MactorException

Throws:

MactorException

execQuerySql

public DataTable execQuerySql(java.lang.String sql)
                       throws MactorException

Throws:

MactorException

execScriptQuery

public DataTable execScriptQuery(java.io.File file)
                          throws MactorException

Throws:

MactorException

execScript

public void execScript(java.io.File file,
                       boolean ignoreSqlException)
                throws MactorException

Throws:

MactorException

execUpdateSql

public void execUpdateSql(java.lang.String sql)
                   throws MactorException

Throws:

MactorException

execSingleCellQuerySql

public java.lang.String execSingleCellQuerySql(java.lang.String sql)
                                        throws MactorException

Throws:

MactorException