|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object gnu.caf.db.impl.RchRowSaveUpdate
public class RchRowSaveUpdate
µ¥ÀÌŸ Àüȯ¿ë Rch¿ëµµ·Î »ç¿ëÇϸç, list¿¡ ÇØ´çÇÏ´Â sqlID¸¦ ½ÇÇàÇÏ¿©
±× ÇØ´ç list ¿¡ ´ëÇÏ¿© º°µµÀÇ executeUpdate sqlID¸¦ ½ÇÇàÇÏ´Â °æ¿ì¿¡
»ç¿ëÇÑ´Ù. rs.next() ¸¶´Ù executeUpdate sqlID°¡ ½ÇÇàµÊ. °á°ú°ªÀº nullÀ» ¸®ÅÏÇÔ.
String sqlFilename = "convert_tra_reg_no/Q_data_init";
String tableName = "mgrp_mmbr";
String listSqlID = "list_"+tableName;
String executeSqlID = "save_"+tableName;
DBManager2 dbmanager = new DBManager2Oracle();
Attribute params = new Attribute();
try{
dbmanager.getConnection(TargetServer.className, TargetServer.url, TargetServer.username, TargetServer.password);
dbmanager.setAutoCommit(false);
RchRowSaveUpdate.queryForList(dbmanager, sqlFilename, listSqlID, params)
.executeUpdate(sqlFilename, executeSqlID);
dbmanager.commit();
}catch(Exception e) {
e.printStackTrace();//¿¡·¯Ã³¸®.
dbmanager.rollback();
}finally {
dbmanager.close();
}
RowCallbackHandler
Method Summary | |
---|---|
void |
executeUpdate(java.lang.String sqlFilename,
java.lang.String sqlID)
¸®½ºÆ®ÀÇ °¢ ·Î¿ìº°·Î sqlID¿¡ ÇØ´çÇÏ´Â Äõ¸®°¡ executeUpdate °¡ ½ÇÇàµÊ. |
java.lang.String |
getDatePattern()
|
java.util.List |
getRsList(java.sql.ResultSet rs,
int startRow,
int maxRows)
ResultSet ¿¡ ´ëÇÏ¿© firstRow¿¡ ÇØ´çÇÏ´Â ¸¸Å rs.next() ó¸®ÈÄ maxResults ¸¸Å µ¥ÀÌŸ¸¦ ó¸®ÈÄ List¸¦ ¹ÝȯÇÔ. |
boolean |
isDate2String()
|
static RchRowSaveUpdate |
queryForList(DBManager2 dbmanager,
java.lang.String sqlFilename,
java.lang.String sqlID,
Attribute params)
|
RchRowSaveUpdate |
setDate2String(boolean date2String)
Row󸮽à ¼³Á¤°ªÀÌ trueÀΰæ¿ì DateŸÀÔ¿¡ ´ëÇÏ¿© StringÀ¸·Î ÀÚµ¿º¯È¯ÇÔ. |
RchRowSaveUpdate |
setDatePattern(java.lang.String datePattern)
setDatePattern - µðÆúÆ®°ªÀº yyyy-MM-dd HH:mm:ss |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public java.util.List getRsList(java.sql.ResultSet rs, int startRow, int maxRows) throws java.sql.SQLException
RowCallbackHandler
getRsList
in interface RowCallbackHandler
java.sql.SQLException
RowCallbackHandler.getRsList(ResultSet, int, int)
public static RchRowSaveUpdate queryForList(DBManager2 dbmanager, java.lang.String sqlFilename, java.lang.String sqlID, Attribute params)
public void executeUpdate(java.lang.String sqlFilename, java.lang.String sqlID) throws java.sql.SQLException
sqlID
-
java.sql.SQLException
public java.lang.String getDatePattern()
public boolean isDate2String()
public RchRowSaveUpdate setDate2String(boolean date2String)
date2String
-
public RchRowSaveUpdate setDatePattern(java.lang.String datePattern)
datePattern
-
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |