gnu.caf.db
Interface SqlUtil

All Known Subinterfaces:

DBManager2

All Known Implementing Classes:

DBManager2MSSQL, DBManager2Oracle, SqlUtilOracle

public interface SqlUtil

sql 󸮸¦ À§ÇÑ ÀϹÝÀûÀÎ ¸Þ¼Òµå¸¦ Á¤ÀÇÇÑ interface Ŭ·¡½º

Since:

1.0

Author:

ÀÌÈ£¼º

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) ´Ù±¹¾î 󸮸¦ À§ÇÏ¿© »ç¿ëÇÔ.
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°´Ã¼¸¦ ¹ÝȯÇÔ.
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	setJndiDataSourceName(java.lang.String jndiDataSourceName) JNDI DataSourceName À» ¼³Á¤ÇÔ.
void	setRowCallbackHandler(RowCallbackHandler rowCallbackHandler) java.sql.ResultSet °´Ã¼¸¦ 󸮽à »ç¿ëÇÒ handler°´Ã¼¸¦ ¼³Á¤ÇÔ.

Method Detail

getConnection

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À» Á÷Á¢ ¼³Á¤ÇÒ ¶§ »ç¿ëÇÔ.

Parameters:

className -

url -

username -

password -

Returns:

Connection

Throws:

java.sql.SQLException

getConnection

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

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

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

Returns:

Connection

Throws:

java.sql.SQLException

getConnection

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

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

Parameters:

jndiDataSourceName -

Returns:

Connection

Throws:

java.sql.SQLException

executeUpdateClob

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

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

Parameters:

sql -

clobData -

Throws:

java.sql.SQLException

java.io.IOException

executeUpdateClob

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

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

Parameters:

sql -

params -

clobData -

Throws:

java.sql.SQLException

java.io.IOException

executeQueryForFixedSequenceString

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

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

Parameters:

sql -

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

Returns:

String

Throws:

java.sql.SQLException

executeQueryForFixedSequenceString

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

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

Parameters:

sql -

params -

fixedLength -

Returns:

String

Throws:

java.sql.SQLException

executeQueryForInt

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

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

Parameters:

sql -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForInt

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

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

Parameters:

sql -

params -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForMap

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

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

Parameters:

sql -

Returns:

Map

Throws:

java.sql.SQLException

executeQueryForMap

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

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

Parameters:

sql -

params -

Returns:

Map

Throws:

java.sql.SQLException

executeQueryForList

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

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

Parameters:

sql -

params -

Returns:

List

Throws:

java.sql.SQLException

executeQueryForList

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

Parameters:

sql -

params -

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

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

Returns:

List

Throws:

java.sql.SQLException

executeUpdate

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

sql¸¦ ½ÇÇàÇÔ.

Parameters:

query -

params -

Returns:

int

Throws:

java.sql.SQLException

executeUpdateNCHAR

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

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

Parameters:

sql -

params -

Returns:

int

Throws:

java.sql.SQLException

executeQueryForPagingList

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();

Parameters:

sql -

params -

pageNo -

pageSize -

Returns:

PagingList

Throws:

java.sql.SQLException

clearParams

void clearParams(java.util.ArrayList params)

executeQueryForPagingList

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();

Parameters:

sql -

pageNo -

pageSize -

Returns:

PagingList

Throws:

java.sql.SQLException

executeQueryForList

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

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

Parameters:

sql -

Returns:

List

Throws:

java.sql.SQLException

executeUpdate

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

sql¸¦ ½ÇÇàÇÔ.

Parameters:

sql -

Returns:

int

Throws:

java.sql.SQLException

commit

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();
}

Throws:

java.sql.SQLException

rollback

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();
}


close

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();
}


setAutoCommit

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();
}


Parameters:

autocommit -

Throws:

java.sql.SQLException

getAutoCommit

boolean getAutoCommit()

setConnection

void setConnection(java.sql.Connection connection)

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

Parameters:

connection -

getDataSource

javax.sql.DataSource getDataSource()

dataSource¸¦ ¹ÝȯÇÔ.

Returns:

DataSource

setDataSource

void setDataSource(javax.sql.DataSource dataSource)

dataSource¸¦ ¼³Á¤ÇÔ.

Parameters:

dataSource -

getRowCallbackHandler

RowCallbackHandler getRowCallbackHandler()

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

Returns:

RowCallbackHandler

setRowCallbackHandler

void setRowCallbackHandler(RowCallbackHandler rowCallbackHandler)

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

getJndiDataSourceName

java.lang.String getJndiDataSourceName()

JNDI DataSurceName À» ¹ÝȯÇÔ.

Returns:

String

setJndiDataSourceName

void setJndiDataSourceName(java.lang.String jndiDataSourceName)

JNDI DataSourceName À» ¼³Á¤ÇÔ.

Parameters:

jndiDataSourceName -

prepareCall

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

Throws:

java.sql.SQLException