gnu.caf.db.impl
Class SqlUtilOracle

java.lang.Object
  gnu.caf.db.impl.SqlUtilOracle

All Implemented Interfaces:

SqlUtil

Direct Known Subclasses:

DBManager2Oracle

public class SqlUtilOracle
extends java.lang.Object
implements SqlUtil

SqlUtil ÀÇ Oracle ±¸Çö Ŭ·¡½ºÀÓ.

Since:

1.0

Author:

ÀÌÈ£¼º

See Also:

SqlUtil

Field Summary

protected boolean	bDEBUG
protected java.sql.Connection	connection
protected javax.sql.DataSource	dataSource
protected boolean	isAutoCommit
protected java.lang.String	jndiDataSourceName
protected RowCallbackHandler	rowCallbackHandler
protected int	transaction

Constructor Summary

SqlUtilOracle()

Method Summary

void	clearParams(java.util.ArrayList params)
void	close() close 󸮸¦ ÇÔ.
void	commit() commit 󸮸¦ ÇÔ.
java.lang.String	executeQueryForFixedSequenceString(java.lang.String sql, int fixedLength) °íÁ¤±æÀÌÀÇ seqÀ» °¡Á®¿È.
java.lang.String	executeQueryForFixedSequenceString(java.lang.String sql, java.lang.Object[] params, int fixedLength) °íÁ¤±æÀÌÀÇ seq¸¦ °¡Á®¿È.
int	executeQueryForInt(java.lang.String sql) sql¿¡ ÇØ´çÇÏ´Â int ¸¦ ¹ÝȯÇÔ.
int	executeQueryForInt(java.lang.String sql, java.lang.Object[] params) sql¿¡ ÇØ´çÇÏ´Â int ¸¦ ¹ÝȯÇÔ.
java.util.List	executeQueryForList(java.lang.String sql) sql¿¡ ÇØ´çÇÏ´Â List ¸¦ ¹ÝȯÇÔ.
java.util.List	executeQueryForList(java.lang.String sql, java.lang.Object[] params) sql¿¡ ÇØ´çÇÏ´Â List°´Ã¼¸¦ ¹ÝȯÇÔ.
java.util.List	executeQueryForList(java.lang.String sql, java.lang.Object[] params, int startRow, int maxRows) sql¿¡ ÇØ´çÇÏ´Â List°´Ã¼¸¦ ¹ÝȯÇÔ.
java.util.Map	executeQueryForMap(java.lang.String sql) sql¿¡ ÇØ´çÇÏ´Â Map°´Ã¼¸¦ ¹ÝȯÇÔ.
java.util.Map	executeQueryForMap(java.lang.String sql, java.lang.Object[] params) sql¿¡ ÇØ´çÇÏ´Â Map°´Ã¼¸¦ ¹ÝȯÇÔ.
PagingList	executeQueryForPagingList(java.lang.String sql, int pageNo, int pageSize) sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ.
PagingList	executeQueryForPagingList(java.lang.String sql, java.lang.Object[] params, int pageNo, int pageSize) sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ.
int	executeUpdate(java.lang.String sql) sql¸¦ ½ÇÇàÇÔ.
int	executeUpdate(java.lang.String query, java.lang.Object[] params) sql¸¦ ½ÇÇàÇÔ.
void	executeUpdateClob(java.lang.String sql, java.lang.Object[] params, java.lang.String clobData) Clob µ¥ÀÌŸ¸¦ °»½ÌÀ» À§Çؼ­ »ç¿ëÇÔ.
void	executeUpdateClob(java.lang.String sql, java.lang.String clobData) Clob µ¥ÀÌŸ¸¦ °»½ÅÀ» À§Çؼ­ »ç¿ëÇÔ.
int	executeUpdateNCHAR(java.lang.String sql, java.lang.Object[] params) ´Ù±¹¾î 󸮸¦ À§ÇÏ¿© »ç¿ëÇÔ.
protected void	finalize()
boolean	getAutoCommit()
java.sql.Connection	getConnection() ¼³Á¤µÈ connection À» °¡Á®¿È.
java.sql.Connection	getConnection(java.lang.String jndiDataSourceName) JNDI ¿¡ µî·ÏµÈ dataSourceÀÇ connectionÀ» °¡Á®¿È.
java.sql.Connection	getConnection(java.lang.String className, java.lang.String url, java.lang.String username, java.lang.String password) ConnectionÀ» Á÷Á¢ ¼³Á¤ÇÒ ¶§ »ç¿ëÇÔ.
javax.sql.DataSource	getDataSource() dataSource¸¦ ¹ÝȯÇÔ.
java.lang.String	getJndiDataSourceName() JNDI DataSurceName À» ¹ÝȯÇÔ.
RowCallbackHandler	getRowCallbackHandler() java.sql.ResultSet °´Ã¼¸¦ 󸮽à »ç¿ëÇÒ handler°´Ã¼¸¦ ¹ÝȯÇÔ.
boolean	isDebug()
static java.util.Properties	loadParams(java.lang.String file) This method reads the properties file:Connection.properties which is passed as the parameter to it and load it into a java Properties object and returns it.
static void	main(java.lang.String[] args)
java.sql.CallableStatement	prepareCall(java.lang.String sql)
void	rollback() rollback 󸮸¦ ÇÔ.
void	setAutoCommit(boolean autocommit) Æ®·£Àè¼Ç 󸮸¦ À§ÇØ autoCommit ¼³Á¤À» ÇÔ.
void	setConnection(java.sql.Connection connection) sqlUtil ¿¡¼­ »ç¿ëÇÒ connectionÀ» ¼³Á¤ÇÔ.
void	setDataSource(javax.sql.DataSource dataSource) dataSource¸¦ ¼³Á¤ÇÔ.
void	setDebug(boolean b)
void	setJndiDataSourceName(java.lang.String jndiDataSourceName) JNDI DataSourceName À» ¼³Á¤ÇÔ.
void	setRowCallbackHandler(RowCallbackHandler rowCallbackHandler) java.sql.ResultSet °´Ã¼¸¦ 󸮽à »ç¿ëÇÒ handler°´Ã¼¸¦ ¼³Á¤ÇÔ.

Methods inherited from class java.lang.Object

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

Field Detail

bDEBUG

protected boolean bDEBUG

isAutoCommit

protected boolean isAutoCommit

transaction

protected int transaction

connection

protected java.sql.Connection connection

dataSource

protected javax.sql.DataSource dataSource

jndiDataSourceName

protected java.lang.String jndiDataSourceName

rowCallbackHandler

protected RowCallbackHandler rowCallbackHandler

Constructor Detail

SqlUtilOracle

public SqlUtilOracle()

Method Detail

setDebug

public void setDebug(boolean b)

isDebug

public boolean isDebug()

getConnection

public java.sql.Connection getConnection(java.lang.String className,
                                         java.lang.String url,
                                         java.lang.String username,
                                         java.lang.String password)
                                  throws java.sql.SQLException

ConnectionÀ» Á÷Á¢ ¼³Á¤ÇÒ ¶§ »ç¿ëÇÔ.

Specified by:

getConnection in interface SqlUtil

Parameters:

className -

url -

username -

password -

Returns:

Connection

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

¼³Á¤µÈ connection À» °¡Á®¿È.

Connection °´Ã¼¸¦ ¹ÝȯÇÏ´Â ±âÁØÀº dataSource, connection ±âÁØÀ¸·Î connectionÀ» °¡Á®¿Â´Ù. dataSource °¡ ¼³Á¤µÇ¾îÀÖ´Â °æ¿ì¿¡´Â dataSource¿¡ ÇØ´çÇÏ´Â connectionÀ» ¹ÝȯÇÔ.

Specified by:

getConnection in interface SqlUtil

Returns:

Connection

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection(java.lang.String jndiDataSourceName)
                                  throws java.sql.SQLException

JNDI ¿¡ µî·ÏµÈ dataSourceÀÇ connectionÀ» °¡Á®¿È.

Specified by:

getConnection in interface SqlUtil

Parameters:

jndiDataSourceName -

Returns:

Connection

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)

executeUpdateClob

public void executeUpdateClob(java.lang.String sql,
                              java.lang.String clobData)
                       throws java.sql.SQLException

Clob µ¥ÀÌŸ¸¦ °»½ÅÀ» À§Çؼ­ »ç¿ëÇÔ. ÇÑ°³Ä÷³¿¡ ´ëÇÏ¿©¸¸ »ç¿ëÇÔ.

Specified by:

executeUpdateClob in interface SqlUtil

Parameters:

sql -

clobData -

Throws:

java.sql.SQLException

java.io.IOException

executeUpdateClob

public void executeUpdateClob(java.lang.String sql,
                              java.lang.Object[] params,
                              java.lang.String clobData)
                       throws java.sql.SQLException

Clob µ¥ÀÌŸ¸¦ °»½ÌÀ» À§Çؼ­ »ç¿ëÇÔ.

Specified by:

executeUpdateClob in interface SqlUtil

Parameters:

sql -

params -

clobData -

Throws:

java.sql.SQLException

java.io.IOException

executeQueryForFixedSequenceString

public java.lang.String executeQueryForFixedSequenceString(java.lang.String sql,
                                                           int fixedLength)
                                                    throws java.sql.SQLException

°íÁ¤±æÀÌÀÇ seqÀ» °¡Á®¿È.

Specified by:

executeQueryForFixedSequenceString in interface SqlUtil

Parameters:

sql -

fixedLength - °íÁ¤¹®ÀÚ¿­±æÀÌ

Returns:

String

Throws:

java.sql.SQLException

executeQueryForFixedSequenceString

public java.lang.String executeQueryForFixedSequenceString(java.lang.String sql,
                                                           java.lang.Object[] params,
                                                           int fixedLength)
                                                    throws java.sql.SQLException

°íÁ¤±æÀÌÀÇ seq¸¦ °¡Á®¿È.

Specified by:

executeQueryForFixedSequenceString in interface SqlUtil

Parameters:

sql -

params -

fixedLength -

Returns:

String

Throws:

java.sql.SQLException

executeQueryForInt

public int executeQueryForInt(java.lang.String sql)
                       throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â int ¸¦ ¹ÝȯÇÔ. Ä«¿îÆ® °è»êÀ» À§Çؼ­ »ç¿ëÇÔ.

Specified by:

executeQueryForInt in interface SqlUtil

Parameters:

sql -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForInt

public int executeQueryForInt(java.lang.String sql,
                              java.lang.Object[] params)
                       throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â int ¸¦ ¹ÝȯÇÔ. Ä«¿îÆ® °è»êÀ» À§Çؼ­ »ç¿ëÇÔ.

Specified by:

executeQueryForInt in interface SqlUtil

Parameters:

sql -

params -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForMap

public java.util.Map executeQueryForMap(java.lang.String sql)
                                 throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â Map°´Ã¼¸¦ ¹ÝȯÇÔ. ÇÑ°³µ¥ÀÌŸ¸¦ ¹ÝȯÇÏ´Â °æ¿ì»ç¿ëÇÔ.

Specified by:

executeQueryForMap in interface SqlUtil

Parameters:

sql -

Returns:

Map

Throws:

java.sql.SQLException

executeQueryForMap

public java.util.Map executeQueryForMap(java.lang.String sql,
                                        java.lang.Object[] params)
                                 throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â Map°´Ã¼¸¦ ¹ÝȯÇÔ. ÇÑ°³µ¥ÀÌŸ¸¦ ¹ÝȯÇÏ´Â °æ¿ì»ç¿ëÇÔ.

Specified by:

executeQueryForMap in interface SqlUtil

Parameters:

sql -

params -

Returns:

Map

Throws:

java.sql.SQLException

executeQueryForList

public java.util.List executeQueryForList(java.lang.String sql,
                                          java.lang.Object[] params)
                                   throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â List°´Ã¼¸¦ ¹ÝȯÇÔ. ¿©·¯°³ÀÇ µ¥ÀÌŸ¸¦ ¹ÝȯÇÏ´Â °æ¿ì»ç¿ëÇÔ.

Specified by:

executeQueryForList in interface SqlUtil

Parameters:

sql -

params -

Returns:

List

Throws:

java.sql.SQLException

executeQueryForList

public java.util.List executeQueryForList(java.lang.String sql,
                                          java.lang.Object[] params,
                                          int startRow,
                                          int maxRows)
                                   throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â List°´Ã¼¸¦ ¹ÝȯÇÔ.
int min = ((int) (pageNo - 0.1) / groupSize) * groupSize * pageSize + 1;
ÆäÀÌÁö¹øÈ£±âÁØÀ¸·Î ½ÇÇàÇÏ·Á¸é.. min = startRow, maxRows = pageSize

Specified by:

executeQueryForList in interface SqlUtil

Parameters:

sql -

params -

startRow - rs.next() ¸¦ ½ÇÇàÇϴ Ƚ¼ö...

maxRows - ÃÖ´ë°¡Á®¿À´Â ÇàÀÇ °¹¼ö.

Returns:

List

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String query,
                         java.lang.Object[] params)
                  throws java.sql.SQLException

sql¸¦ ½ÇÇàÇÔ.

Specified by:

executeUpdate in interface SqlUtil

Parameters:

query -

params -

Returns:

int

Throws:

java.sql.SQLException

executeUpdateNCHAR

public int executeUpdateNCHAR(java.lang.String sql,
                              java.lang.Object[] params)
                       throws java.sql.SQLException

´Ù±¹¾î 󸮸¦ À§ÇÏ¿© »ç¿ëÇÔ. Oracle datatype ÀÌ NCHAR, NVARCHAR ÀÎ °æ¿ì¿¡ »ç¿ëÇÔ.

Specified by:

executeUpdateNCHAR in interface SqlUtil

Parameters:

sql -

params -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForPagingList

public PagingList executeQueryForPagingList(java.lang.String sql,
                                            java.lang.Object[] params,
                                            int pageNo,
                                            int pageSize)
                                     throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ. ÆäÀ̡󸮽à ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®¸¦ °¡Á®¿È. 󸮽à Àüü Ä«¿îÆ®¿Í ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®°´Ã¼¸¦ ¹ÝȯÇÔ. PagingList paginglist = executeQueryForPagingList(sql, params, 1, 10); int totalCount = paginglist.getTotalCount(); List list = paginglist.getList();

Specified by:

executeQueryForPagingList in interface SqlUtil

Parameters:

sql -

params -

pageNo -

pageSize -

Returns:

PagingList

Throws:

java.sql.SQLException

clearParams

public void clearParams(java.util.ArrayList params)

Specified by:

clearParams in interface SqlUtil

executeQueryForPagingList

public PagingList executeQueryForPagingList(java.lang.String sql,
                                            int pageNo,
                                            int pageSize)
                                     throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â PagingList °´Ã¼¸¦ ¹ÝȯÇÔ. ÆäÀ̡󸮽à ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®¸¦ °¡Á®¿È. 󸮽à Àüü Ä«¿îÆ®¿Í ÇØ´çÆäÀÌÁöÀÇ ¸®½ºÆ®°´Ã¼¸¦ ¹ÝȯÇÔ. PagingList paginglist = executeQueryForPagingList(sql, params, 1, 10); int totalCount = paginglist.getTotalCount(); List list = paginglist.getList();

Specified by:

executeQueryForPagingList in interface SqlUtil

Parameters:

sql -

pageNo -

pageSize -

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForList

public java.util.List executeQueryForList(java.lang.String sql)
                                   throws java.sql.SQLException

sql¿¡ ÇØ´çÇÏ´Â List ¸¦ ¹ÝȯÇÔ.

Specified by:

executeQueryForList in interface SqlUtil

Parameters:

sql -

Returns:

List

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException

sql¸¦ ½ÇÇàÇÔ.

Specified by:

executeUpdate in interface SqlUtil

Parameters:

sql -

Returns:

int

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

commit 󸮸¦ ÇÔ.
ex)
String sql = "update .... ";
SqlUtil sqlutil = new SqlUtil();
try{
sqlutil.getConnection("maags");
sqlutil.setAutoCommit(false);
sqlutil.executeUpdate(sql);
sqlutil.commit();
}catch(SQLException e) {
e.printStackTrace();
sqlutil.rollback();
}finally{
sqlutil.close();
}

Specified by:

commit in interface SqlUtil

Throws:

java.sql.SQLException

rollback

public void rollback()

rollback 󸮸¦ ÇÔ.
ex)
String sql = "update .... ";
SqlUtil sqlutil = new SqlUtil();
try{
sqlutil.getConnection("maags");
sqlutil.setAutoCommit(false);
sqlutil.executeUpdate(sql);
sqlutil.commit();
}catch(SQLException e) {
e.printStackTrace();
sqlutil.rollback();
}finally{
sqlutil.close();
}


Specified by:

rollback in interface SqlUtil

close

public void close()

close 󸮸¦ ÇÔ.

ex)
String sql = "update .... ";
SqlUtil sqlutil = new SqlUtil();
try{
sqlutil.getConnection("maags");
sqlutil.setAutoCommit(false);
sqlutil.executeUpdate(sql);
sqlutil.commit();
}catch(SQLException e) {
e.printStackTrace();
sqlutil.rollback();
}finally{
sqlutil.close();
}


Specified by:

close in interface SqlUtil

setAutoCommit

public void setAutoCommit(boolean autocommit)
                   throws java.sql.SQLException

Æ®·£Àè¼Ç 󸮸¦ À§ÇØ autoCommit ¼³Á¤À» ÇÔ.
ex)
String sql = "update .... ";
SqlUtil sqlutil = new SqlUtil();
try{
sqlutil.getConnection("maags");
sqlutil.setAutoCommit(false);
sqlutil.executeUpdate(sql);
sqlutil.commit();
}catch(SQLException e) {
e.printStackTrace();
sqlutil.rollback();
}finally{
sqlutil.close();
}


Specified by:

setAutoCommit in interface SqlUtil

Parameters:

autocommit -

Throws:

java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()

Specified by:

getAutoCommit in interface SqlUtil

setConnection

public void setConnection(java.sql.Connection connection)

sqlUtil ¿¡¼­ »ç¿ëÇÒ connectionÀ» ¼³Á¤ÇÔ.

Specified by:

setConnection in interface SqlUtil

Parameters:

connection -

getDataSource

public javax.sql.DataSource getDataSource()

dataSource¸¦ ¹ÝȯÇÔ.

Specified by:

getDataSource in interface SqlUtil

Returns:

DataSource

setDataSource

public void setDataSource(javax.sql.DataSource dataSource)

dataSource¸¦ ¼³Á¤ÇÔ.

Specified by:

setDataSource in interface SqlUtil

Parameters:

dataSource -

getRowCallbackHandler

public RowCallbackHandler getRowCallbackHandler()

java.sql.ResultSet °´Ã¼¸¦ 󸮽à »ç¿ëÇÒ handler°´Ã¼¸¦ ¹ÝȯÇÔ.

Specified by:

getRowCallbackHandler in interface SqlUtil

Returns:

RowCallbackHandler

setRowCallbackHandler

public void setRowCallbackHandler(RowCallbackHandler rowCallbackHandler)

java.sql.ResultSet °´Ã¼¸¦ 󸮽à »ç¿ëÇÒ handler°´Ã¼¸¦ ¼³Á¤ÇÔ.

Specified by:

setRowCallbackHandler in interface SqlUtil

getJndiDataSourceName

public java.lang.String getJndiDataSourceName()

JNDI DataSurceName À» ¹ÝȯÇÔ.

Specified by:

getJndiDataSourceName in interface SqlUtil

Returns:

String

setJndiDataSourceName

public void setJndiDataSourceName(java.lang.String jndiDataSourceName)

JNDI DataSourceName À» ¼³Á¤ÇÔ.

Specified by:

setJndiDataSourceName in interface SqlUtil

Parameters:

jndiDataSourceName -

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface SqlUtil

Throws:

java.sql.SQLException

finalize

protected void finalize()
                 throws java.lang.Throwable

Overrides:

finalize in class java.lang.Object

Throws:

java.lang.Throwable

loadParams

public static java.util.Properties loadParams(java.lang.String file)
                                       throws java.io.IOException

This method reads the properties file:Connection.properties which is passed as the parameter to it and load it into a java Properties object and returns it.

Parameters:

file - The name of the file having connection details.

Throws:

java.io.IOException