|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectframework.db.RecordSet
public class RecordSet
µ¥ÀÌŸº£À̽º Äõ¸®¸¦ ¼öÇàÇÑ ÈÄ ±× °á°ú¿¡ ´ëÇÑ Á¢±Ù ±â¹ÝÀ» Á¦°øÇϴ Ŭ·¡½ºÀÌ´Ù.
Constructor Summary | |
---|---|
RecordSet(java.sql.ResultSet rs)
RecordSetÀÇ »ý¼ºÀÚ |
|
RecordSet(java.sql.ResultSet rs,
int curpage,
int pagesize)
ÁÖ¾îÁø ¹üÀ§¿¡ Æ÷ÇԵǴ »õ·Î¿î RecordSet °´Ã¼¸¦ »ý¼ºÇÑ´Ù |
Method Summary | |
---|---|
int |
findColumn(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â columnÀÇ À§Ä¡¸¦ ±¸ÇÑ´Ù. |
boolean |
firstRow()
RecordSetÀÇ Ã³À½À¸·Î À̵¿ÇÑ´Ù. |
java.lang.Object |
get(int column)
ÇöÀç pointing µÈ rowÀÇ column µ¥ÀÌÅ͸¦ Àд´٠|
java.lang.Object |
get(int row,
java.lang.String column)
Recordset µ¥ÀÌŸ¸¦ ¾ò¾î¿Â´Ù. |
java.lang.Object |
get(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
java.math.BigDecimal |
getBigDecimal(int row,
java.lang.String column)
RecordSetÀÇ Column °ªÀ» BigDecimal ·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
java.math.BigDecimal |
getBigDecimal(java.lang.String column)
RecordSetÀÇ Column °ªÀ» BigDecimal ·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
int |
getColumnCount()
ÁÖ¾îÁø Äõ¸® ¼öÇà ÈÄ °á°ú columnÀÇ °¹¼ö¸¦ ±¸ÇÑ´Ù |
java.lang.String |
getColumnLabel(int index)
Äõ¸® ¼öÇà¿¡ ÀÇÇØ ¾ò¾îÁø °á°úÀÇ Æ¯Á¤ columnÀÇ À̸§À» ¾ò´Â´Ù |
java.lang.String[] |
getColumns()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ Ä÷³¸íÀ» String[] ·Î ¹Ýȯ |
java.lang.String[] |
getColumnsInfo()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ Ä÷³ÀÇ ¼º°ÝÀ» String[] ·Î ¹Ýȯ |
int[] |
getColumnsScale()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ Ä÷³ÀÇ ¼Ò¼ýÁ¡ ¾Æ·¡ »çÀÌÁ int[] ·Î ¹Ýȯ |
int[] |
getColumnsSize()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ Ä÷³ÀÇ SizeÀ» int[] ·Î ¹Ýȯ |
int[] |
getColumnsSizeReal()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ Ä÷³ÀÇ ½ÇÁ¦ Size(¼ýÀÚ¼Ó¼º¿¡ »ç¿ë)À» int[] ·Î ¹Ýȯ |
int |
getCurrentRow()
ÇöÀç ÂüÁ¶Çϰí ÀÖ´Â rowÀÇ À§Ä¡¸¦ ±¸ÇÑ´Ù. |
java.sql.Date |
getDate(int column)
ÇöÀç ÇàÀÇ RecordSetÀÇ Date °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå YYYY-MM-DD ·Î ¹Ýȯ |
java.sql.Date |
getDate(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» DateÇüÀ¸·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå YYYY-MM-DD ·Î ¹Ýȯ |
java.sql.Date |
getDate(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ DateÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù YYYY-MM-DD·Î ¹Ýȯ |
double |
getDouble(int column)
ÇöÀç ÇàÀÇ RecordSetÀÇ double °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
double |
getDouble(int row,
java.lang.String column)
RecordSetÀÇ Column °ªÀ» double ·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
double |
getDouble(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ doubleÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
float |
getFloat(int column)
ÇöÀç ÇàÀÇ RecordSetÀÇ float °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
float |
getFloat(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» float·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
float |
getFloat(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ floatÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
int |
getInt(int column)
ÇöÀçÇàÀÇ RecordSetÀÇ int °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
int |
getInt(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» int·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
int |
getInt(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ intÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
int |
getInteger(int column)
ÇöÀçÇàÀÇ RecordSetÀÇ int °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
int |
getInteger(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» int·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
java.lang.Integer |
getInteger(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ intÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
long |
getLong(int column)
ÇöÀç ÇàÀÇ RecordSetÀÇ long °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
long |
getLong(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» long ÇüÀ¸·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
long |
getLong(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ longÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
int |
getRowCount()
ÁÖ¾îÁø Äõ¸® ¼öÇà ÈÄ °á°ú rowÀÇ °¹¼ö¸¦ ±¸ÇÑ´Ù |
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
getRows()
ÁÖ¾îÁø Äõ¸®¸¦ ¼öÇà ÈÄ °á°ú¸¦ ArrayList ·Î ¹Ýȯ |
java.lang.String |
getString(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» StringÀ¸·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
java.lang.String |
getString(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ StringÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù |
java.sql.Timestamp |
getTimestamp(int column)
ÇöÀç ÇüÀÇ RecordSetÀÇ Timestamp °ªÀ» ¹ÝȯÇÏ´Â ¸Þ¼Òµå |
java.sql.Timestamp |
getTimestamp(int row,
java.lang.String column)
RecordSetÀÇ column °ªÀ» TimestampÇüÀ¸·Î ¹ÝȯÇÏ´Â ¸Þ¼Òµå YYYY-MM-DD ·Î ¹Ýȯ |
java.sql.Timestamp |
getTimestamp(java.lang.String name)
ÀÎÀÚ·Î ÀüÇØÁø À̸§À» °¡Áö´Â ÇöÀç pointingµÈ rowÀÇ DateÇü column µ¥ÀÌÅ͸¦ ±¸ÇÑ´Ù YYYY-MM-DD·Î ¹Ýȯ |
boolean |
isEmpty()
·¹ÄÚµå ¼ö°¡ 0 ÀÎÁö check |
boolean |
isFirst()
RecordSetÀÇ Ã³À½rowÀÎÁö ¾Æ´ÑÁö ¿©ºÎ ÆÇ´Ü. |
boolean |
isLast()
RecordSetÀÇ ¸¶Áö¸·rowÀÎÁö ¾Æ´ÑÁö ¿©ºÎ ÆÇ´Ü. |
java.util.Iterator<java.util.Map<java.lang.String,java.lang.Object>> |
iterator()
ÀÌÅÍ·¹ÀÌÅ͸¦ ¹ÝȯÇÑ´Ù. |
boolean |
lastRow()
RecordSetÀÇ ¸¶Áö¸·À¸·Î À̵¿ÇÑ´Ù. |
boolean |
moveRow(int row)
ÇØ´çÇÏ´Â ÇÏ´Â row·Î À̵¿ |
boolean |
nextRow()
RecordSet¿¡¼ ÇöÀç rowÀÇ ´ÙÀ½ row·Î À̵¿ÇÑ´Ù. |
boolean |
preRow()
RecordSetÀÇ ÇöÀç rowÀÇ ÀÌÀü row·Î À̵¿ÇÑ´Ù. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public RecordSet(java.sql.ResultSet rs) throws java.sql.SQLException
java.sql.SQLException
public RecordSet(java.sql.ResultSet rs, int curpage, int pagesize) throws java.sql.SQLException
rs
- Äõ¸® ½ÇÇà°á°úcurpage
- ÇöÀç Ç¥½ÃÇÒ ÆäÀÌÁöpagesize
- ÇÑ ÆäÀÌÁö¿¡ Ç¥½ÃÇÒ µ¥ÀÌÅÍ °¹¼ö
java.sql.SQLException
Method Detail |
---|
public java.lang.String[] getColumns()
public int[] getColumnsSize()
public int[] getColumnsSizeReal()
public int[] getColumnsScale()
public java.lang.String[] getColumnsInfo()
public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getRows()
public int getColumnCount()
public int getRowCount()
public int getCurrentRow()
public java.lang.String getColumnLabel(int index) throws java.lang.IllegalArgumentException, java.lang.NullPointerException
index
- ¾ò°íÀÚ ÇÏ´Â Ä÷³ À§Ä¡, ù¹øÂ° Ä÷³Àº 1
java.lang.IllegalArgumentException
java.lang.NullPointerException
public boolean firstRow()
public boolean isFirst()
public boolean isLast()
public boolean lastRow()
public boolean nextRow()
public boolean preRow()
public boolean moveRow(int row)
public java.lang.Object get(int row, java.lang.String column)
row
- cnt : start 1column
- namepublic java.lang.String getString(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public int getInt(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public int getInteger(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public long getLong(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public double getDouble(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public java.math.BigDecimal getBigDecimal(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public java.math.BigDecimal getBigDecimal(java.lang.String column)
column
- column number, ù¹øÂ° columnÀº 1
public float getFloat(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public java.sql.Date getDate(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public java.sql.Timestamp getTimestamp(int row, java.lang.String column)
row
- row number, ù¹øÂ° row´Â 1column
- column number, ù¹øÂ° columnÀº 1
public java.lang.Object get(int column)
column
- column number, ù¹øÂ° column Àº 1
public int getInt(int column)
column
- column number, ù¹øÂ° columnÀº 1
public int getInteger(int column)
column
- column number, ù¹øÂ° columnÀº 1
public long getLong(int column)
column
- column number, ù¹øÂ° columnÀº 1
public float getFloat(int column)
column
- column number, ù¹øÂ° columnÀº 1
public double getDouble(int column)
column
- column number, ù¹øÂ° columnÀº 1
public java.sql.Date getDate(int column)
column
- column number, ù¹øÂ° columnÀº 1
public java.sql.Timestamp getTimestamp(int column)
column
-
public java.lang.Object get(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public int getInt(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public java.lang.Integer getInteger(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public long getLong(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public java.lang.String getString(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public float getFloat(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public double getDouble(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public java.sql.Date getDate(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public java.sql.Timestamp getTimestamp(java.lang.String name) throws ColumnNotFoundException
name
- ÀаíÀÚ ÇÏ´Â column À̸§
ColumnNotFoundException
public int findColumn(java.lang.String name) throws ColumnNotFoundException
name
- column À̸§
ColumnNotFoundException
public boolean isEmpty()
public java.util.Iterator<java.util.Map<java.lang.String,java.lang.Object>> iterator()
iterator
in interface java.lang.Iterable<java.util.Map<java.lang.String,java.lang.Object>>
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |