|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface SqlUtil
sql 󸮸¦ À§ÇÑ ÀϹÝÀûÀÎ ¸Þ¼Òµå¸¦ Á¤ÀÇÇÑ interface Ŭ·¡½º
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 |
---|
java.sql.Connection getConnection(java.lang.String className, java.lang.String url, java.lang.String username, java.lang.String password) throws java.sql.SQLException
className
- url
- username
- password
-
java.sql.SQLException
java.sql.Connection getConnection() throws java.sql.SQLException
¼³Á¤µÈ connection À» °¡Á®¿È.
Connection °´Ã¼¸¦ ¹ÝȯÇÏ´Â ±âÁØÀº dataSource, connection ±âÁØÀ¸·Î connectionÀ» °¡Á®¿Â´Ù. dataSource °¡ ¼³Á¤µÇ¾îÀÖ´Â °æ¿ì¿¡´Â dataSource¿¡ ÇØ´çÇÏ´Â connectionÀ» ¹ÝȯÇÔ.
java.sql.SQLException
java.sql.Connection getConnection(java.lang.String jndiDataSourceName) throws java.sql.SQLException
jndiDataSourceName
-
java.sql.SQLException
void executeUpdateClob(java.lang.String sql, java.lang.String clobData) throws java.sql.SQLException
sql
- clobData
-
java.sql.SQLException
java.io.IOException
void executeUpdateClob(java.lang.String sql, java.lang.Object[] params, java.lang.String clobData) throws java.sql.SQLException
sql
- params
- clobData
-
java.sql.SQLException
java.io.IOException
java.lang.String executeQueryForFixedSequenceString(java.lang.String sql, int fixedLength) throws java.sql.SQLException
sql
- fixedLength
- °íÁ¤¹®ÀÚ¿±æÀÌ
java.sql.SQLException
java.lang.String executeQueryForFixedSequenceString(java.lang.String sql, java.lang.Object[] params, int fixedLength) throws java.sql.SQLException
sql
- params
- fixedLength
-
java.sql.SQLException
int executeQueryForInt(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
int executeQueryForInt(java.lang.String sql, java.lang.Object[] params) throws java.sql.SQLException
sql
- params
-
java.sql.SQLException
java.util.Map executeQueryForMap(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
java.util.Map executeQueryForMap(java.lang.String sql, java.lang.Object[] params) throws java.sql.SQLException
sql
- params
-
java.sql.SQLException
java.util.List executeQueryForList(java.lang.String sql, java.lang.Object[] params) throws java.sql.SQLException
sql
- params
-
java.sql.SQLException
java.util.List executeQueryForList(java.lang.String sql, java.lang.Object[] params, int startRow, int maxRows) throws java.sql.SQLException
sql
- params
- startRow
- rs.next() ¸¦ ½ÇÇàÇϴ Ƚ¼ö...maxRows
- ÃÖ´ë°¡Á®¿À´Â ÇàÀÇ °¹¼ö.
java.sql.SQLException
int executeUpdate(java.lang.String query, java.lang.Object[] params) throws java.sql.SQLException
query
- params
-
java.sql.SQLException
int executeUpdateNCHAR(java.lang.String sql, java.lang.Object[] params) throws java.sql.SQLException
sql
- params
-
java.sql.SQLException
PagingList executeQueryForPagingList(java.lang.String sql, java.lang.Object[] params, int pageNo, int pageSize) throws java.sql.SQLException
sql
- params
- pageNo
- pageSize
-
java.sql.SQLException
void clearParams(java.util.ArrayList params)
PagingList executeQueryForPagingList(java.lang.String sql, int pageNo, int pageSize) throws java.sql.SQLException
sql
- pageNo
- pageSize
-
java.sql.SQLException
java.util.List executeQueryForList(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
int executeUpdate(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
void commit() throws java.sql.SQLException
java.sql.SQLException
void 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();
}
void 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();
}
void setAutoCommit(boolean autocommit) throws java.sql.SQLException
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();
}
autocommit
-
java.sql.SQLException
boolean getAutoCommit()
void setConnection(java.sql.Connection connection)
connection
- javax.sql.DataSource getDataSource()
void setDataSource(javax.sql.DataSource dataSource)
dataSource
- RowCallbackHandler getRowCallbackHandler()
void setRowCallbackHandler(RowCallbackHandler rowCallbackHandler)
java.lang.String getJndiDataSourceName()
void setJndiDataSourceName(java.lang.String jndiDataSourceName)
jndiDataSourceName
- java.sql.CallableStatement prepareCall(java.lang.String sql) throws java.sql.SQLException
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |