public interface RowSet extends ResultSet
RowSetã€ã³ã¿ãã§ãŒã¹ã§ã¯JavaBeansããããã£ã®çµãæäŸããŸãããããã®ããããã£ã«ãã£ãŠãRowSetã€ã³ã¹ã¿ã³ã¹ãJDBCããŒã¿ã»ãœãŒã¹ã«æ¥ç¶ãããã®ããŒã¿ã»ãœãŒã¹ããããŒã¿ãèªã¿åãããã«æ§æã§ããŸãã å€ãèšå®ããã¡ãœãã(setIntãsetBytesãsetStringãªã©)ã§ã¯ãå
¥åãã©ã¡ãŒã¿ãè¡ã»ããã®ã³ãã³ãã»ããããã£ã«æž¡ãæ¹æ³ãæäŸããŸãã ãã®ã³ãã³ãã¯ãè¡ã»ãããéåžžã¯é¢ä¿ããŒã¿ããŒã¹ããèªèº«ã®ããŒã¿ãååŸãããšãã«äœ¿çšããSQLã¯ãšãªãŒã§ãã
RowSetã€ã³ã¿ãã§ãŒã¹ã§ã¯JavaBeansã€ãã³ãããµããŒãããŠãããè¡ã»ããã«ã€ãã³ããçºçãããšã(å€ã®å€æŽãªã©)ã«ãã¢ããªã±ãŒã·ã§ã³ã®ã»ãã®ã³ã³ããŒãã³ãã«éç¥ããããšãã§ããŸãã
JDBC APIã®ã»ãã®éšåã䜿çšããŠå®è£
ããããã«ããŠããç¹ã§ãRowSetã€ã³ã¿ãã§ãŒã¹ã¯ç¬ç¹ã§ãã èšãæãããšãRowSetã®å®è£
ãšã¯ãJDBCãã©ã€ãã®æäžéšã§å®è¡ããããœãããŠã§ã¢ã®ã¬ã€ã€ãŒã§ãã RowSetã€ã³ã¿ãã§ãŒã¹ã®å®è£
ã¯ãJDBC補åã®äžéšãšããŠRowSetã®å®è£
ãæäŸããããšããJDBCãã©ã€ãã»ãã³ããŒãå§ããšããŠã誰ã§ãæäŸã§ããŸãã
RowSetãªããžã§ã¯ãã§ã¯ãããŒã¿ã»ãœãŒã¹ãšã®æ¥ç¶ãäœæãããªããžã§ã¯ãã®ã©ã€ãã»ãµã€ã¯ã«ãéããŠãã®æ¥ç¶ãä¿æããŸãããã®ãããªå Žåãæ¥ç¶ãããè¡ã»ãããšåŒã°ããŸãã ãŸããè¡ã»ããã¯ããŒã¿ã»ãœãŒã¹ãšæ¥ç¶ããŠããŒã¿ãååŸããæ¥ç¶ãéããããšãã§ããŸãã ãã®ãããªè¡ã»ããã¯æªæ¥ç¶ã®è¡ã»ãããšåŒã°ããŸãã æªæ¥ç¶ã®è¡ã»ããã§ã¯ãæªæ¥ç¶äžã«ããŒã¿ã«å€æŽãå ããŠãããããŒã¿ã®å
ã®ãœãŒã¹ã«å€æŽãéãæ»ãããšãã§ããŸãããããããã®ããã«ã¯æ¥ç¶ãããäžåºŠç¢ºç«ããå¿
èŠããããŸãã
åæãããè¡ã»ããã«ã¯ãé¢é£ä»ãããããªãŒããŒ(RowSetReaderãªããžã§ã¯ã)ãšã©ã€ã¿ãŒ(RowSetWriterãªããžã§ã¯ã)ããããŸãã ãªãŒããŒã¯ãããŒã¿ä»ãã§è¡ã»ãããçæããããã«ããŸããŸãªæ¹æ³ã§å®è£
ãããŠãããéé¢ä¿ããŒã¿ã»ãœãŒã¹ããããŒã¿ãååŸããããšãã§ããŸãã ã©ã€ã¿ãŒããŸãããŸããŸãªæ¹æ³ã§å®è£
ãããŠãããè¡ã»ããã®ããŒã¿ã«å ãããã倿Žãåºæ¬ãšãªãããŒã¿ã»ãœãŒã¹ãžéãæ»ãããšãã§ããŸãã
è¡ã»ããã䜿çšããã®ã¯ç°¡åã§ãã RowSetã€ã³ã¿ãã§ãŒã¹ã¯æšæºjava.sql.ResultSetã€ã³ã¿ãã§ãŒã¹ãæ¡åŒµãããã®ã§ãã RowSetMetaDataã€ã³ã¿ãã§ãŒã¹ã¯java.sql.ResultSetMetaDataã€ã³ã¿ãã§ãŒã¹ãæ¡åŒµãããã®ã§ãã ããã«ãããJDBC APIã«ç²ŸéããŠããéçºè
ãè¡ã»ããã䜿ãããã«ã¯ãæå°éã®æ°ããAPIãèŠããã°æžã¿ãŸãã ããã«ãJDBC ResultSetãªããžã§ã¯ããšãšãã«åäœãããµãŒãã»ããŒãã£è£œã®ãœãããŠã§ã¢ã»ããŒã«ããè¡ã»ããã䜿çšããŠåäœããããã«ããããšãç°¡åã«ã§ããŸãã
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE| 修食åãšå | ã¡ãœãã | 説æ |
|---|---|---|
void |
addRowSetListener(RowSetListener listener) |
æå®ããã€ãã³ãã»ãªã¹ããŒãç»é²ããŠããã®
RowSetãªããžã§ã¯ãã§çºçããã€ãã³ããéç¥ãããããã«ããŸãã |
void |
clearParameters() |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãçšã®ãã©ã¡ãŒã¿ã»ã»ãããã¯ãªã¢ããŸãã |
void |
execute() |
ãã®
RowSetãªããžã§ã¯ãã«ããŒã¿ãæ ŒçŽããŸãã |
String |
getCommand() |
ãã®
RowSetãªããžã§ã¯ãã®commandããããã£ãååŸããŸãã |
String |
getDataSourceName() |
ãã®
RowSetãªããžã§ã¯ãã®ããŒã¿ã»ãœãŒã¹ãç¹å®ããè«çåãååŸããŸãã |
boolean |
getEscapeProcessing() |
ãã®
RowSetãªããžã§ã¯ãã®ãšã¹ã±ãŒãã®åŠçãæå¹ãã©ãããååŸããŸãã |
int |
getMaxFieldSize() |
ããåå€ã§è¿ãããæå€§ãã€ãæ°ãååŸããŸãã
|
int |
getMaxRows() |
ãã®
RowSetãªããžã§ã¯ãã«å«ããããšã®ã§ããæå€§è¡æ°ãååŸããŸãã |
String |
getPassword() |
ããŒã¿ããŒã¹æ¥ç¶ã®äœæã«äœ¿çšãããã¹ã¯ãŒããååŸããŸãã
|
int |
getQueryTimeout() |
ãã©ã€ããæã®å®è¡ãåŸ
ã€æå€§ç§æ°ãååŸããŸãã
|
int |
getTransactionIsolation() |
ãã®
RowSetãªããžã§ã¯ãã®ãã©ã³ã¶ã¯ã·ã§ã³é®æã¬ãã«ã®èšå®ãååŸããŸãã |
Map<String,Class<?>> |
getTypeMap() |
ãã®
RowSetãªããžã§ã¯ãã«é¢é£ä»ããããSQLãŠãŒã¶ãŒå®çŸ©åã®ã«ã¹ã¿ã ã»ãããã³ã°ãããå Žåã«ã¯ããããæå®ããMapãªããžã§ã¯ããååŸããŸãã |
String |
getUrl() |
ãã®
RowSetãªããžã§ã¯ããæ¥ç¶ã確ç«ããã®ã«DataSourceãªããžã§ã¯ãã§ã¯ãªãDriverManagerã䜿çšããå Žåã«ãæ¥ç¶ãäœæããããã«äœ¿çšããurlããããã£ãååŸããŸãã |
String |
getUsername() |
ãã®
RowSetãªããžã§ã¯ãã®ããŒã¿ããŒã¹æ¥ç¶ãäœæããããã«äœ¿çšãããusernameãååŸããŸãã |
boolean |
isReadOnly() |
ãã®
RowSetãªããžã§ã¯ããèªåãå°çšãã©ããã確èªããŸãã |
void |
removeRowSetListener(RowSetListener listener) |
æå®ãããªã¹ããŒãããã®
RowSetãªããžã§ã¯ãã§ã€ãã³ããçºçãããšãã«éç¥ãããã³ã³ããŒãã³ãã®ãªã¹ãããåé€ããŸãã |
void |
setArray(int i, Array x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããArrayå€ã«èšå®ããŸãã |
void |
setAsciiStream(int parameterIndex, InputStream x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã |
void |
setAsciiStream(int parameterIndex, InputStream x, int length) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.InputStreamå€ã«èšå®ããŸãã |
void |
setAsciiStream(String parameterName, InputStream x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã
|
void |
setAsciiStream(String parameterName, InputStream x, int length) |
æå®ããããã©ã¡ãŒã¿ããæå®ããããã€ãæ°ãæã€æå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã
|
void |
setBigDecimal(int parameterIndex, BigDecimal x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.math.BigDeciamlå€ã«èšå®ããŸãã |
void |
setBigDecimal(String parameterName, BigDecimal x) |
æå®ããããã©ã¡ãŒã¿ããæå®ããã
java.math.BigDecimalå€ã«èšå®ããŸãã |
void |
setBinaryStream(int parameterIndex, InputStream x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã |
void |
setBinaryStream(int parameterIndex, InputStream x, int length) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.InputStreamå€ã«èšå®ããŸãã |
void |
setBinaryStream(String parameterName, InputStream x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã
|
void |
setBinaryStream(String parameterName, InputStream x, int length) |
æå®ããããã©ã¡ãŒã¿ããæå®ããããã€ãæ°ãæã€æå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã
|
void |
setBlob(int i, Blob x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããBlobå€ã«èšå®ããŸãã |
void |
setBlob(int parameterIndex, InputStream inputStream) |
æå®ããããã©ã¡ãŒã¿ã
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setBlob(int parameterIndex, InputStream inputStream, long length) |
æå®ããããã©ã¡ãŒã¿ã
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setBlob(String parameterName, Blob x) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.Blobãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setBlob(String parameterName, InputStream inputStream) |
æå®ããããã©ã¡ãŒã¿ã
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setBlob(String parameterName, InputStream inputStream, long length) |
æå®ããããã©ã¡ãŒã¿ã
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setBoolean(int parameterIndex, boolean x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava booleanå€ã«èšå®ããŸãã |
void |
setBoolean(String parameterName, boolean x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
booleanå€ã«èšå®ããŸãã |
void |
setByte(int parameterIndex, byte x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava byteå€ã«èšå®ããŸãã |
void |
setByte(String parameterName, byte x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
byteå€ã«èšå®ããŸãã |
void |
setBytes(int parameterIndex, byte[] x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããbyteå€ã®æå®ããJavaé
åå€ã«èšå®ããŸãã |
void |
setBytes(String parameterName, byte[] x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®ãã€ãé
åã«èšå®ããŸãã
|
void |
setCharacterStream(int parameterIndex, Reader reader) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããReaderãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setCharacterStream(int parameterIndex, Reader reader, int length) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.Readerå€ã«èšå®ããŸãã |
void |
setCharacterStream(String parameterName, Reader reader) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setCharacterStream(String parameterName, Reader reader, int length) |
æå®ããããã©ã¡ãŒã¿ããæå®ãããæåæ°ã§ããæå®ããã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setClob(int i, Clob x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããClobå€ã«èšå®ããŸãã |
void |
setClob(int parameterIndex, Reader reader) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setClob(int parameterIndex, Reader reader, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setClob(String parameterName, Clob x) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.Clobãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setClob(String parameterName, Reader reader) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setClob(String parameterName, Reader reader, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setCommand(String cmd) |
ãã®
RowSetãªããžã§ã¯ãã®commandããããã£ã«SQLã¯ãšãªãŒãèšå®ããŸãã |
void |
setConcurrency(int concurrency) |
ãã®
RowSetãªããžã§ã¯ãã®äžŠè¡æ§ããæå®ããäžŠè¡æ§ã¬ãã«ã«èšå®ããŸãã |
void |
setDataSourceName(String name) |
ãã®
RowSetãªããžã§ã¯ãã®ããŒã¿ã»ãœãŒã¹åããããã£ããæå®ããStringã«èšå®ããŸãã |
void |
setDate(int parameterIndex, Date x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Dateå€ã«èšå®ããŸãã |
void |
setDate(int parameterIndex, Date x, Calendar cal) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Dateå€ã«èšå®ããŸãã |
void |
setDate(String parameterName, Date x) |
ã¢ããªã±ãŒã·ã§ã³ãå®è¡ããŠããä»®æ³ãã·ã³ã®ããã©ã«ãã®ã¿ã€ã ãŸãŒã³ã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.Dateå€ã«èšå®ããŸãã |
void |
setDate(String parameterName, Date x, Calendar cal) |
æå®ããã
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Dateå€ã«èšå®ããŸãã |
void |
setDouble(int parameterIndex, double x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava doubleå€ã«èšå®ããŸãã |
void |
setDouble(String parameterName, double x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
doubleå€ã«èšå®ããŸãã |
void |
setEscapeProcessing(boolean enable) |
ãã®
RowSetãªããžã§ã¯ãã®ãšã¹ã±ãŒãã®åŠçããªã³ãŸãã¯ãªãã«èšå®ããŸãã |
void |
setFloat(int parameterIndex, float x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava floatå€ã«èšå®ããŸãã |
void |
setFloat(String parameterName, float x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
floatå€ã«èšå®ããŸãã |
void |
setInt(int parameterIndex, int x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava intå€ã«èšå®ããŸãã |
void |
setInt(String parameterName, int x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
intå€ã«èšå®ããŸãã |
void |
setLong(int parameterIndex, long x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava longå€ã«èšå®ããŸãã |
void |
setLong(String parameterName, long x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
longå€ã«èšå®ããŸãã |
void |
setMaxFieldSize(int max) |
åå€ã«è¿ãããæå€§ãã€ãæ°ããæå®ããããã€ãæ°ã«èšå®ããŸãã
|
void |
setMaxRows(int max) |
ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®
RowSetãªããžã§ã¯ãã«å«ããããšã®ã§ããæå€§ã®è¡æ°ããæå®ããå€ã«èšå®ããŸãã |
void |
setNCharacterStream(int parameterIndex, Reader value) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããReaderãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNCharacterStream(int parameterIndex, Reader value, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNCharacterStream(String parameterName, Reader value) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNCharacterStream(String parameterName, Reader value, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(int parameterIndex, NClob value) |
æå®ããããã©ã¡ãŒã¿ã
java.sql.NClobãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(int parameterIndex, Reader reader) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(int parameterIndex, Reader reader, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(String parameterName, NClob value) |
æå®ããããã©ã¡ãŒã¿ã
java.sql.NClobãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(String parameterName, Reader reader) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNClob(String parameterName, Reader reader, long length) |
æå®ããããã©ã¡ãŒã¿ã
Readerãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNString(int parameterIndex, String value) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
Stringãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNString(String parameterName, String value) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
Stringãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setNull(int parameterIndex, int sqlType) |
ãã®
RowSetãªããžã§ã¯ãã®SQLã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããSQL NULLã«èšå®ããŸãã |
void |
setNull(int paramIndex, int sqlType, String typeName) |
ãã®
RowSetãªããžã§ã¯ãã®SQLã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããSQL NULLã«èšå®ããŸãã |
void |
setNull(String parameterName, int sqlType) |
æå®ããããã©ã¡ãŒã¿ãSQL
NULLã«èšå®ããŸãã |
void |
setNull(String parameterName, int sqlType, String typeName) |
æå®ããããã©ã¡ãŒã¿ãSQL
NULLã«èšå®ããŸãã |
void |
setObject(int parameterIndex, Object x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããJava Objectã«èšå®ããŸãã |
void |
setObject(int parameterIndex, Object x, int targetSqlType) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããJava Objectã«èšå®ããŸãã |
void |
setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããæå®ããJava Objectã«èšå®ããŸãã |
void |
setObject(String parameterName, Object x) |
æå®ããããã©ã¡ãŒã¿ã®å€ããæå®ããããªããžã§ã¯ãã§èšå®ããŸãã
|
void |
setObject(String parameterName, Object x, int targetSqlType) |
æå®ããããã©ã¡ãŒã¿ã®å€ããæå®ããããªããžã§ã¯ãã§èšå®ããŸãã
|
void |
setObject(String parameterName, Object x, int targetSqlType, int scale) |
æå®ããããã©ã¡ãŒã¿ã®å€ããæå®ããããªããžã§ã¯ãã§èšå®ããŸãã
|
void |
setPassword(String password) |
ãã®
RowSetãªããžã§ã¯ãã®ããŒã¿ããŒã¹ã»ãã¹ã¯ãŒãããæå®ããStringã«èšå®ããŸãã |
void |
setQueryTimeout(int seconds) |
ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåã«ãã©ã€ããæã®å®è¡ãåŸ
ã€æå€§æéããæå®ããç§æ°ã«èšå®ããŸãã
|
void |
setReadOnly(boolean value) |
ãã®
RowSetãªããžã§ã¯ããèªåãå°çšãã©ããããæå®ããbooleanã«èšå®ããŸãã |
void |
setRef(int i, Ref x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããRefå€ã«èšå®ããŸãã |
void |
setRowId(int parameterIndex, RowId x) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.RowIdãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setRowId(String parameterName, RowId x) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.RowIdãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setShort(int parameterIndex, short x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava shortå€ã«èšå®ããŸãã |
void |
setShort(String parameterName, short x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
shortå€ã«èšå®ããŸãã |
void |
setSQLXML(int parameterIndex, SQLXML xmlObject) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.SQLXMLãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setSQLXML(String parameterName, SQLXML xmlObject) |
æå®ããããã©ã¡ãŒã¿ãæå®ããã
java.sql.SQLXMLãªããžã§ã¯ãã«èšå®ããŸãã |
void |
setString(int parameterIndex, String x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava Stringå€ã«èšå®ããŸãã |
void |
setString(String parameterName, String x) |
æå®ããããã©ã¡ãŒã¿ãæå®ãããJavaã®
Stringå€ã«èšå®ããŸãã |
void |
setTime(int parameterIndex, Time x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Timeå€ã«èšå®ããŸãã |
void |
setTime(int parameterIndex, Time x, Calendar cal) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Timeå€ã«èšå®ããŸãã |
void |
setTime(String parameterName, Time x) |
æå®ããããã©ã¡ãŒã¿ããæå®ããã
java.sql.Timeå€ã«èšå®ããŸãã |
void |
setTime(String parameterName, Time x, Calendar cal) |
æå®ããã
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Timeå€ã«èšå®ããŸãã |
void |
setTimestamp(int parameterIndex, Timestamp x) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Timestampå€ã«èšå®ããŸãã |
void |
setTimestamp(int parameterIndex, Timestamp x, Calendar cal) |
ãã®
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Timestampå€ã«èšå®ããŸãã |
void |
setTimestamp(String parameterName, Timestamp x) |
æå®ããããã©ã¡ãŒã¿ããæå®ããã
java.sql.Timestampå€ã«èšå®ããŸãã |
void |
setTimestamp(String parameterName, Timestamp x, Calendar cal) |
æå®ããã
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Timestampå€ã«èšå®ããŸãã |
void |
setTransactionIsolation(int level) |
ãã®
RowSetãªããžã§ã¯ãã®ãã©ã³ã¶ã¯ã·ã§ã³é®æã¬ãã«ãèšå®ããŸãã |
void |
setType(int type) |
ãã®
RowSetãªããžã§ã¯ãã®åããæå®ããåã«èšå®ããŸãã |
void |
setTypeMap(Map<String,Class<?>> map) |
ãã®
RowSetãªããžã§ã¯ãã®ããã©ã«ãã®åããããšããŠæå®ãããjava.util.Mapãªããžã§ã¯ããã€ã³ã¹ããŒã«ããŸãã |
void |
setURL(int parameterIndex, URL x) |
æå®ããããã©ã¡ãŒã¿ããæå®ããã
java.net.URLå€ã«èšå®ããŸãã |
void |
setUrl(String url) |
ãã®
RowSetãªããžã§ã¯ããDriverManagerã䜿ã£ãŠæ¥ç¶ãäœæãããšãã«äœ¿çšããURLãèšå®ããŸãã |
void |
setUsername(String name) |
ãã®
RowSetãªããžã§ã¯ãã®usernameããããã£ããæå®ããStringã«èšå®ããŸãã |
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNullisWrapperFor, unwrapString getUrl() throws SQLException
RowSetãªããžã§ã¯ããæ¥ç¶ã確ç«ããã®ã«DataSourceãªããžã§ã¯ãã§ã¯ãªãDriverManagerã䜿çšããå Žåã«ãæ¥ç¶ãäœæããããã«äœ¿çšããurlããããã£ãååŸããŸãã ããã©ã«ãå€ã¯nullã§ãã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetUrl(java.lang.String)void setUrl(String url) throws SQLException
RowSetãªããžã§ã¯ããDriverManagerã䜿ã£ãŠæ¥ç¶ãäœæãããšãã«äœ¿çšããURLãèšå®ããŸãã ãã®ããããã£ã®èšå®ã¯ãªãã·ã§ã³ã§ãã URLã䜿çšããå Žåã¯ãããŒã¿ããŒã¹ãžã®æ¥ç¶ã«è¡ã»ããã䜿çšãããåã«ããã®URLãåãå
¥ããJDBCãã©ã€ããããŒãããŸãã è¡ã»ããã§ã¯ãããŒã¿ãèªã¿æžããããšãã«ããã®URLãå
éšçã«äœ¿çšããŠãããŒã¿ããŒã¹æ¥ç¶ãäœæããŸãã URLãšããŒã¿ã»ãœãŒã¹åã®ãã¡ãæ°ããnull以å€ã®å€ãèšå®ãããæ¹ãæ¥ç¶ã®äœæã«äœ¿çšãããŸãã url - æååå€ãnullãå¯SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetUrl()String getDataSourceName()
RowSetãªããžã§ã¯ãã®ããŒã¿ã»ãœãŒã¹ãç¹å®ããè«çåãååŸããŸããsetDataSourceName(java.lang.String), setUrl(java.lang.String)void setDataSourceName(String name) throws SQLException
RowSetãªããžã§ã¯ãã®ããŒã¿ã»ãœãŒã¹åããããã£ããæå®ããStringã«èšå®ããŸãã
ããŒã¿ã»ãœãŒã¹åããããã£ã®å€ã¯ãããŒã ã»ãµãŒãã¹ã§ç»é²ãããDataSourceãªããžã§ã¯ããã«ãã¯ã¢ããããããã«äœ¿çšãããŸãã ååŸãããDataSourceãªããžã§ã¯ãã䜿ã£ãŠããã®ãªããžã§ã¯ãã衚ãããŒã¿ã»ãœãŒã¹ãžã®æ¥ç¶ãäœæã§ããŸãã
name - ãã®RowSetãªããžã§ã¯ãã®ããŒã¿ã»ãœãŒã¹ã®è«çåãnullãå¯SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetDataSourceName()String getUsername()
RowSetãªããžã§ã¯ãã®ããŒã¿ããŒã¹æ¥ç¶ãäœæããããã«äœ¿çšãããusernameãååŸããŸãã usernameããããã£ã¯ãå®è¡æã«executeã¡ãœãããåŒã³åºãåã«èšå®ãããŸãã éåžžãããã¯RowSetãªããžã§ã¯ãã®çŽååç¶æ
ã®äžéšã§ã¯ãããŸããã setUsername(java.lang.String)void setUsername(String name) throws SQLException
RowSetãªããžã§ã¯ãã®usernameããããã£ããæå®ããStringã«èšå®ããŸããname - ãŠãŒã¶ãŒåSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetUsername()String getPassword()
executeã¡ãœãããåŒã³åºãåã«èšå®ãããŸãã éåžžãããã¯RowSetãªããžã§ã¯ãã®çŽååç¶æ
ã®äžéšã§ã¯ãããŸããã setPassword(java.lang.String)void setPassword(String password) throws SQLException
RowSetãªããžã§ã¯ãã®ããŒã¿ããŒã¹ã»ãã¹ã¯ãŒãããæå®ããStringã«èšå®ããŸããpassword - ãã¹ã¯ãŒãã衚ãæååSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetPassword()int getTransactionIsolation()
RowSetãªããžã§ã¯ãã®ãã©ã³ã¶ã¯ã·ã§ã³é®æã¬ãã«ã®èšå®ãååŸããŸããConnection.TRANSACTION_READ_UNCOMMITTEDãConnection.TRANSACTION_READ_COMMITTEDãConnection.TRANSACTION_REPEATABLE_READããŸãã¯Connection.TRANSACTION_SERIALIZABLEã®ãã¡ã®1ã€setTransactionIsolation(int)void setTransactionIsolation(int level)
throws SQLException
RowSetãªããžã§ã¯ãã®ãã©ã³ã¶ã¯ã·ã§ã³é®æã¬ãã«ãèšå®ããŸããlevel - ãã©ã³ã¶ã¯ã·ã§ã³é®æã¬ãã«ãConnection.TRANSACTION_READ_UNCOMMITTEDãConnection.TRANSACTION_READ_COMMITTEDãConnection.TRANSACTION_REPEATABLE_READããŸãã¯Connection.TRANSACTION_SERIALIZABLEã®ãã¡ã®1ã€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetTransactionIsolation()Map<String,Class<?>> getTypeMap() throws SQLException
RowSetãªããžã§ã¯ãã«é¢é£ä»ããããSQLãŠãŒã¶ãŒå®çŸ©åã®ã«ã¹ã¿ã ã»ãããã³ã°ãããå Žåã«ã¯ããããæå®ããMapãªããžã§ã¯ããååŸããŸãã åãããã®ããã©ã«ãã¯ç©ºã§ãã java.util.Mapãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetTypeMap(java.util.Map<java.lang.String, java.lang.Class<?>>)void setTypeMap(Map<String,Class<?>> map) throws SQLException
RowSetãªããžã§ã¯ãã®ããã©ã«ãã®åããããšããŠæå®ãããjava.util.Mapãªããžã§ã¯ããã€ã³ã¹ããŒã«ããŸãã å¥ã®åããããã¡ãœããã®ãã©ã¡ãŒã¿ãšããŠæå®ããããŸã§ããã®åãããã䜿çšãããŸãã map - SQLãŠãŒã¶ãŒå®çŸ©åãšãããããããã³ã°ãããJavaã¯ã©ã¹ãæ ŒçŽãããŠããjava.util.Mapãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetTypeMap()String getCommand()
RowSetãªããžã§ã¯ãã®commandããããã£ãååŸããŸãã commandããããã£ã«ã¯ãSQLã¯ãšãªãŒã§ããã³ãã³ãæååãæ ŒçŽãããŸããããã¯ãè¡ã»ããã«ããŒã¿ãæ ŒçŽããããã«å®è¡ãããŸãã ããã©ã«ãå€ã¯nullã§ãã nullãå¯setCommand(java.lang.String)void setCommand(String cmd) throws SQLException
RowSetãªããžã§ã¯ãã®commandããããã£ã«SQLã¯ãšãªãŒãèšå®ããŸãã è¡ã»ãããã³ãã³ãããµããŒãããªãããŒã¿ã»ãœãŒã¹ããããŒã¿ãåŸãå Žå(ã¹ãã¬ããã·ãŒããªã©)ããã®ããããã£ã¯ãªãã·ã§ã³ã§ãã cmd - ãã®RowSetãªããžã§ã¯ãã®ããŒã¿ãååŸããããã«äœ¿çšãããSQLã¯ãšãªãŒãnullãå¯SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetCommand()boolean isReadOnly()
RowSetãªããžã§ã¯ããèªåãå°çšãã©ããã確èªããŸãã æŽæ°ãå¯èœãªå Žåãè¡ã»ããã®ããã©ã«ãã¯æŽæ°å¯èœã«ãªããŸãã
èªåãå°çšã®è¡ã»ãããæŽæ°ããããšãããšãSQLExceptionãã¹ããŒãããŸãã
RowSetãªããžã§ã¯ããèªåãå°çšã®å Žåã¯trueãæŽæ°å¯èœãªå Žåã¯falsesetReadOnly(boolean)void setReadOnly(boolean value)
throws SQLException
RowSetãªããžã§ã¯ããèªåãå°çšãã©ããããæå®ããbooleanã«èšå®ããŸããvalue - èªåãå°çšã®å Žåã¯trueãæŽæ°å¯èœãªå Žåã¯falseSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåisReadOnly()int getMaxFieldSize()
throws SQLException
BINARYãVARBINARYãLONGVARBINARYBINARYãCHARãVARCHARãLONGVARCHARãNCHARãããã³NVARCHARã®ååã ãã«é©çšãããŸãã å¶éå€ãè¶
ããããŒã¿ã¯éç¥ãªãã«ç Žæ£ãããŸãã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetMaxFieldSize(int)void setMaxFieldSize(int max)
throws SQLException
BINARYãVARBINARYãLONGVARBINARYBINARYãCHARãVARCHARãLONGVARCHARãNCHARãããã³NVARCHARã®ååã ãã«é©çšãããŸãã å¶éå€ãè¶
ããããŒã¿ã¯éç¥ãªãã«ç Žæ£ãããŸãã ç§»æ€æ§ãæå€§éã«ããã«ã¯ã256ãã倧ããå€ã䜿çšããŸãã max - æ°ããæå€§åãµã€ãºã®å¶éå€(ãã€ã)ããŒãã¯ç¡å¶éãæå³ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetMaxFieldSize()int getMaxRows()
throws SQLException
RowSetãªããžã§ã¯ãã«å«ããããšã®ã§ããæå€§è¡æ°ãååŸããŸãã å¶éå€ãè¶
ããè¡ã¯éç¥ãªãã«é€å€ãããŸãã RowSetãªããžã§ã¯ãã«å«ããããšã®ã§ããçŸåšã®æå€§è¡æ°ããŒãã¯ç¡å¶éãæå³ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetMaxRows(int)void setMaxRows(int max)
throws SQLException
RowSetãªããžã§ã¯ãã«å«ããããšã®ã§ããæå€§ã®è¡æ°ããæå®ããå€ã«èšå®ããŸãã å¶éå€ãè¶
ããè¡ã¯éç¥ãªãã«é€å€ãããŸãã max - æ°ããæå€§è¡æ°ããŒãã¯ç¡å¶éãæå³ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetMaxRows()boolean getEscapeProcessing()
throws SQLException
RowSetãªããžã§ã¯ãã®ãšã¹ã±ãŒãã®åŠçãæå¹ãã©ãããååŸããŸãã ãšã¹ã±ãŒãã»ã¹ãã£ãã³ã°ãæå¹ã®å Žå(ããã©ã«ã)ããã©ã€ãã¯SQLæãããŒã¿ããŒã¹ã«éãåã«ãšã¹ã±ãŒã眮æããå®è¡ããŸãã trueãç¡å¹ãªå Žåã¯falseSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetEscapeProcessing(boolean)void setEscapeProcessing(boolean enable)
throws SQLException
RowSetãªããžã§ã¯ãã®ãšã¹ã±ãŒãã®åŠçããªã³ãŸãã¯ãªãã«èšå®ããŸãã ãšã¹ã±ãŒãã»ã¹ãã£ãã³ã°ããªã³ã®å Žå(ããã©ã«ã)ããã©ã€ãã¯SQLæãããŒã¿ããŒã¹ã«éãåã«ãšã¹ã±ãŒã眮æããå®è¡ããŸãã enable - ãšã¹ã±ãŒãåŠçãæå¹ã«ããå Žåã¯trueãç¡å¹ã«ããå Žåã¯falseSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetEscapeProcessing()int getQueryTimeout()
throws SQLException
SQLExceptionãã¹ããŒãããŸãã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåsetQueryTimeout(int)void setQueryTimeout(int seconds)
throws SQLException
SQLExceptionãã¹ããŒãããŸãã seconds - æ°ããã¯ãšãªãŒã»ã¿ã€ã ã¢ãŠãã®å¶éå€ã®ç§æ°ããŒãã¯ç¡å¶éãæå³ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽågetQueryTimeout()void setType(int type)
throws SQLException
RowSetãªããžã§ã¯ãã®åããæå®ããåã«èšå®ããŸãã ãã®ã¡ãœããã¯ãããã©ã«ãã§èªåãå°çšã§ã¹ã¯ããŒã«äžå¯ã®è¡ã»ããã®åã倿Žããããã«çšããããŸãã type - ã¿ã€ããæå®ããResultSet宿°ãResultSet.TYPE_FORWARD_ONLYãResultSet.TYPE_SCROLL_INSENSITIVEããŸãã¯ResultSet.TYPE_SCROLL_SENSITIVESQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåResultSet.getType()void setConcurrency(int concurrency)
throws SQLException
RowSetãªããžã§ã¯ãã®äžŠè¡æ§ããæå®ããäžŠè¡æ§ã¬ãã«ã«èšå®ããŸãã ãã®ã¡ãœããã¯ãããã©ã«ãã§ResultSet.CONCUR_READ_ONLYã§ããè¡ã»ããã®äžŠè¡æ§ã¬ãã«ã倿Žããããã«çšããããŸãã concurrency - 䞊è¡åŠçã®ã¬ãã«ãæå®ããResultSet宿°ãResultSet.CONCUR_READ_ONLYãŸãã¯ResultSet.CONCUR_UPDATABLESQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåResultSet.getConcurrency()void setNull(int parameterIndex,
int sqlType)
throws SQLException
RowSetãªããžã§ã¯ãã®SQLã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããSQL NULLã«èšå®ããŸãã
ããŒã: ãã©ã¡ãŒã¿ã®SQLã®åãæå®ããå¿ èŠããããŸãã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãsqlType - java.sql.Typesã«ãã£ãŠå®çŸ©ãããSQLåã®ã³ãŒãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNull(String parameterName, int sqlType) throws SQLException
NULLã«èšå®ããŸãã
ããŒã: ãã©ã¡ãŒã¿ã®SQLã®åãæå®ããå¿ èŠããããŸãã
parameterName - ãã©ã¡ãŒã¿ã®ååsqlType - java.sql.Typesã§å®çŸ©ãããSQLåã³ãŒãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNull(int paramIndex,
int sqlType,
String typeName)
throws SQLException
RowSetãªããžã§ã¯ãã®SQLã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããSQL NULLã«èšå®ããŸãã SQLãŠãŒã¶ãŒå®çŸ©å(UDT)ããã³REFåã®ãã©ã¡ãŒã¿ã§ã¯ããã®ããŒãžã§ã³ã®setNullã¡ãœããã䜿çšããå¿
èŠããããŸãã UDTã®äŸã«ã¯ãSTRUCTãDISTINCTãJAVA_OBJECTãããã³ååä»ãé
åããããŸãã
ããŒã: ç§»æ€æ§ãå®çŸããããã«ã¯ãã¢ããªã±ãŒã·ã§ã³ã¯NULLã®ãŠãŒã¶ãŒå®çŸ©ãã©ã¡ãŒã¿ãŸãã¯REFãã©ã¡ãŒã¿ãæå®ãããšãã«SQLåã³ãŒãããã³å®å
šæå®ã®SQLååãæå®ããªããã°ãããŸããã ãŠãŒã¶ãŒå®çŸ©åã®å Žåãååã¯ãã©ã¡ãŒã¿èªäœã®ååã§ãã REFãã©ã¡ãŒã¿ã®å Žåãååã¯åç
§ãããåã®ååã§ãã JDBCãã©ã€ããåã³ãŒããŸãã¯ååã®æ
å ±ãå¿
èŠãšããªãå Žåãããã¯ç¡èŠãããŸãã UDTããã³REFãã©ã¡ãŒã¿ã察象ãšããŠããŸããããã®ã¡ãœããã¯ä»»æã®JDBCåã®nullãã©ã¡ãŒã¿ãèšå®ããããã«äœ¿çšã§ããŸãã ãã©ã¡ãŒã¿ããŠãŒã¶ãŒå®çŸ©ã®åãŸãã¯REFåãæããªãå ŽåãtypeNameãã©ã¡ãŒã¿ã¯ç¡èŠãããŸãã
paramIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãsqlType - java.sql.Typesããã®å€typeName - SQL UDTã®å®å
šæå®åããŸãã¯REFåã§åç
§ãããSQLæ§é åã®ååããã©ã¡ãŒã¿ãUDTãŸãã¯REFåã§ãªãå Žåã¯ç¡èŠãããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNull(String parameterName, int sqlType, String typeName) throws SQLException
NULLã«èšå®ããŸãã ãŠãŒã¶ãŒå®çŸ©åããã³REFåã®ãã©ã¡ãŒã¿ã§ã¯ããã®ããŒãžã§ã³ã®setNullã¡ãœããã䜿çšããã¹ãã§ãã ãŠãŒã¶ãŒå®çŸ©åã®äŸã«ã¯ãSTRUCTãDISTINCTãJAVA_OBJECTãããã³ååä»ãé
åããããŸãã
ããŒã: ç§»æ€æ§ãå®çŸããããã«ã¯ãã¢ããªã±ãŒã·ã§ã³ã¯NULLã®ãŠãŒã¶ãŒå®çŸ©ãã©ã¡ãŒã¿ãŸãã¯REFãã©ã¡ãŒã¿ãæå®ãããšãã«SQLåã³ãŒãããã³å®å šæå®ã®SQLååãæå®ããªããã°ãããŸããã ãŠãŒã¶ãŒå®çŸ©åã®å Žåãååã¯ãã©ã¡ãŒã¿èªäœã®ååã§ãã REFãã©ã¡ãŒã¿ã®å Žåãååã¯åç §ãããåã®ååã§ãã JDBCãã©ã€ããåã³ãŒããŸãã¯ååã®æ å ±ãå¿ èŠãšããªãå Žåãããã¯ç¡èŠãããŸãã ãŠãŒã¶ãŒå®çŸ©ãã©ã¡ãŒã¿ããã³REFãã©ã¡ãŒã¿ã察象ãšããŠããŸããããã®ã¡ãœããã¯ä»»æã®JDBCåã®nullãã©ã¡ãŒã¿ãèšå®ããããã«äœ¿çšã§ããŸãã ãã©ã¡ãŒã¿ããŠãŒã¶ãŒå®çŸ©ã®åãŸãã¯REFåãæããªãå Žåãæå®ãããtypeNameã¯ç¡èŠãããŸãã
parameterName - ãã©ã¡ãŒã¿ã®ååsqlType - java.sql.Typesããã®å€typeName - SQLãŠãŒã¶ãŒå®çŸ©åã®å®å
šæå®ãããååããã©ã¡ãŒã¿ããŠãŒã¶ãŒå®çŸ©åã§ãSQL REFå€ã§ããªãå Žåã¯ç¡èŠãããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBoolean(int parameterIndex,
boolean x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava booleanå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL BITå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBoolean(String parameterName, boolean x) throws SQLException
booleanå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL BITãŸãã¯BOOLEANå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getBoolean(int)void setByte(int parameterIndex,
byte x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava byteå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL TINYINTå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setByte(String parameterName, byte x) throws SQLException
byteå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL TINYINTå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getByte(int)void setShort(int parameterIndex,
short x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava shortå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL SMALLINTå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setShort(String parameterName, short x) throws SQLException
shortå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL SMALLINTå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getShort(int)void setInt(int parameterIndex,
int x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava intå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL INTEGERå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setInt(String parameterName, int x) throws SQLException
intå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL INTEGERå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getInt(int)void setLong(int parameterIndex,
long x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava longå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL BIGINTå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setLong(String parameterName, long x) throws SQLException
longå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL BIGINTå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getLong(int)void setFloat(int parameterIndex,
float x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava floatå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL REALå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setFloat(String parameterName, float x) throws SQLException
floatå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL FLOATå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getFloat(int)void setDouble(int parameterIndex,
double x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava doubleå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL DOUBLEå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setDouble(String parameterName, double x) throws SQLException
doubleå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL DOUBLEå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getDouble(int)void setBigDecimal(int parameterIndex,
BigDecimal x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.math.BigDeciamlå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ã«éä¿¡ãããåã«ããã©ã€ãã«ãã£ãŠSQL NUMERICå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBigDecimal(String parameterName, BigDecimal x) throws SQLException
java.math.BigDecimalå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL NUMERICå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getBigDecimal(int, int)void setString(int parameterIndex,
String x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããJava Stringå€ã«èšå®ããŸãã ããã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ããã©ã€ãã«ãã£ãŠSQL VARCHARãŸãã¯LONGVARCHARå€ã«å€æãããŸã(ãã©ã€ãã®VARCHARå€ã®å¶éã«é¢ããåŒæ°ã®ãµã€ãºã«äŸå)ã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setString(String parameterName, String x) throws SQLException
Stringå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL VARCHARãŸãã¯LONGVARCHARå€(ãã©ã€ãã®VARCHARå€ã®å¶éã«å¯ŸããåŒæ°ã®ãµã€ãºã«äŸå)ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getString(int)void setBytes(int parameterIndex,
byte[] x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããbyteå€ã®æå®ããJavaé
åå€ã«èšå®ããŸãã ããã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ããã©ã€ãã«ãã£ãŠSQL VARBINARYãŸãã¯LONGVARBINARYå€ã«å€æãããŸã(ãã©ã€ãã®VARBINARYå€ã®å¶éã«é¢ããåŒæ°ã®ãµã€ãºã«äŸå)ã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBytes(String parameterName, byte[] x) throws SQLException
VARBINARYãŸãã¯LONGVARBINARY (ãã©ã€ãã®VARBINARYå€ã®å¶éã«å¯ŸããåŒæ°ã®ãµã€ãºã«äŸå)ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getBytes(int)void setDate(int parameterIndex,
Date x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Dateå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ãããã©ã«ãã®java.util.Calendarã䜿çšããŠæ¥ä»ãèšç®ããããã©ã€ãã«ãã£ãŠSQL DATEå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setTime(int parameterIndex,
Time x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Timeå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ãããã©ã«ãã®java.util.Calendarã䜿çšããŠèšç®ããããã©ã€ãã«ãã£ãŠSQL TIMEå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setTimestamp(int parameterIndex,
Timestamp x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.sql.Timestampå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ãããã©ã«ãã®java.util.Calendarã䜿çšããŠèšç®ããããã©ã€ãã«ãã£ãŠSQL TIMESTAMPå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setTimestamp(String parameterName, Timestamp x) throws SQLException
java.sql.Timestampå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL TIMESTAMPå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getTimestamp(int)void setAsciiStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.InputStreamå€ã«èšå®ããŸãã java.io.InputStreamãä»ããŠéåžžã«å€§ããªASCIIå€ãéä¿¡ããã»ãããLONGVARCHARãã©ã¡ãŒã¿ã䜿çšããããçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠããã©ã€ãã«ãã£ãŠããŒã¿ãã¹ããªãŒã ããèªã¿åãããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ASCIIãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã length - ã¹ããªãŒã ã®ãã€ãæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªASCIIå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãASCIIããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterName - ãã©ã¡ãŒã¿ã®ååx - ASCIIãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã length - ã¹ããªãŒã ã®ãã€ãæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBinaryStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.InputStreamå€ã«èšå®ããŸãã java.io.InputStreamãä»ããŠéåžžã«å€§ããªãã€ããªå€ãéä¿¡ããã»ãããLONGVARBINARYãã©ã¡ãŒã¿ã䜿çšããããçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠããã©ã€ãã«ãã£ãŠããŒã¿ãã¹ããªãŒã ããèªã¿åãããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã€ããªã»ãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã length - ã¹ããªãŒã ã®ãã€ãæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
LONGVARBINARYãã©ã¡ãŒã¿ã«éåžžã«å€§ããªãã€ããªå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã€ããªã»ãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã length - ã¹ããªãŒã ã®ãã€ãæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setCharacterStream(int parameterIndex,
Reader reader,
int length)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããjava.io.Readerå€ã«èšå®ããŸãã java.io.Readerãä»ããŠéåžžã«å€§ããªUNICODEå€ãéä¿¡ããã»ãããLONGVARCHARãã©ã¡ãŒã¿ã䜿çšããããçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠããã©ã€ãã«ãã£ãŠããŒã¿ãã¹ããªãŒã ããèªã¿åãããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãreader - èšå®ããUNICODEããŒã¿ãå«ãReaderãªããžã§ã¯ãlength - ã¹ããªãŒã å
ã®æåæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªUNICODEå€ãå
¥åããããšãã«ã¯ãjava.io.Readerãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãUNICODEããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
parameterName - ãã©ã¡ãŒã¿ã®ååreader - æå®ããããã©ã¡ãŒã¿ãšããŠäœ¿çšãããUNICODEããŒã¿ãå«ãjava.io.Readerãªããžã§ã¯ãlength - ã¹ããªãŒã å
ã®æåæ°SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setAsciiStream(int parameterIndex,
InputStream x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªASCIIå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãASCIIããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setAsciiStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ASCIIãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setAsciiStream(String parameterName, InputStream x) throws SQLException
LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªASCIIå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãASCIIããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setAsciiStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååx - ASCIIãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBinaryStream(int parameterIndex,
InputStream x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããå
¥åã¹ããªãŒã ã«èšå®ããŸãã LONGVARBINARYãã©ã¡ãŒã¿ã«éåžžã«å€§ããªãã€ããªå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setBinaryStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã€ããªã»ãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBinaryStream(String parameterName, InputStream x) throws SQLException
LONGVARBINARYãã©ã¡ãŒã¿ã«éåžžã«å€§ããªãã€ããªå€ãå
¥åããããšãã«ã¯ãjava.io.InputStreamãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setBinaryStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã€ããªã»ãã©ã¡ãŒã¿å€ãå«ãJavaå
¥åã¹ããªãŒã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setCharacterStream(int parameterIndex,
Reader reader)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããæå®ãããReaderãªããžã§ã¯ãã«èšå®ããŸãã LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªUNICODEå€ãå
¥åããããšãã«ã¯ãjava.io.Readerãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãUNICODEããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setCharacterStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãreader - UnicodeããŒã¿ãæ ŒçŽããjava.io.Readerãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setCharacterStream(String parameterName, Reader reader) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã LONGVARCHARãã©ã¡ãŒã¿ã«éåžžã«å€§ããªUNICODEå€ãå
¥åããããšãã«ã¯ãjava.io.Readerãªããžã§ã¯ããä»ããŠéãã®ãçŸå®çã§ãã ãã¡ã€ã«ã®çµããã«éãããŸã§å¿
èŠã«å¿ããŠã¹ããªãŒã ããããŒã¿ãèªã¿èŸŒãŸããŸãã JDBCãã©ã€ãã¯ãããŒã¿ãUNICODEããããŒã¿ããŒã¹ã®char圢åŒã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setCharacterStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååreader - UnicodeããŒã¿ãæ ŒçŽããjava.io.Readerãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNCharacterStream(int parameterIndex,
Reader value)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ããããã©ã¡ãŒã¿ããReaderãªããžã§ã¯ãã«èšå®ããŸãã Readerã¯ããã¡ã€ã«ã®çµããã«éãããŸã§ããŒã¿ãèªã¿èŸŒã¿ãŸãã ãã©ã€ãã¯ãå¿
èŠã«å¿ããŠãJavaã®æå衚çŸãããŒã¿ããŒã¹å
ã®ååœæåã»ããã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setNCharacterStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setObject(int parameterIndex,
Object x,
int targetSqlType,
int scaleOrLength)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããæå®ããJava Objectã«èšå®ããŸãã æŽæ°å€ã®å Žåã¯ç䟡ãªjava.langãªããžã§ã¯ãã䜿çšããå¿
èŠããããŸã(ããšãã°intã«å¯ŸããŠIntegerã¯ã©ã¹ã®ã€ã³ã¹ã¿ã³ã¹)ã 2çªç®ã®åŒæ°ãInputStreamã§ããå Žåãã¹ããªãŒã ã«ã¯scaleOrLengthã§æå®ããããã€ãæ°ãå«ãŸããå¿
èŠããããŸãã 2çªç®ã®åŒæ°ãReaderã§ããå ŽåããªãŒããŒã«ã¯scaleOrLengthã§æå®ãããæåæ°*ãå«ãŸããå¿
èŠããããŸãã ãããã®æ¡ä»¶ãtrueã§ã¯ãªãå Žåãæºåãããæã®å®è¡æã«ãã©ã€ãã¯SQLExceptionãçæããŸãã
æå®ãããJavaãªããžã§ã¯ãã¯ãããŒã¿ããŒã¹ã«éãããåã«targetSqlTypeã«å€æãããŸãã
ãªããžã§ã¯ãã®ã¯ã©ã¹ãSQLDataãå®è£
ããå Žåã¯ãè¡ã»ããã§SQLData.writeSQLã¡ãœãããåŒã³åºããŠããªããžã§ã¯ããSQLOutputããŒã¿ã»ã¹ããªãŒã ã«æžã蟌ãå¿
èŠããããŸãã ãŸãããªããžã§ã¯ããRefãBlobãClobãNClobãStructãjava.net.URLããŸãã¯Arrayãå®è£
ããã¯ã©ã¹ã®ãªããžã§ã¯ãã§ããå Žåããã©ã€ãã¯ãã®ãªããžã§ã¯ãã察å¿ããSQLåã®å€ãšããŠããŒã¿ããŒã¹ã«æž¡ãå¿
èŠããããŸãã
ãã®ã¡ãœããã¯ãããŒã¿ããŒã¹åºæã®æœè±¡ããŒã¿åãæž¡ãããã«äœ¿çšã§ããããšã«æ³šæããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãtargetSqlType - ããŒã¿ããŒã¹ã«éããã(java.sql.Typesã§å®çŸ©ããã) SQLåã scaleåŒæ°ã§ãããã«ãã®åãéå®ã§ããã scaleOrLength - java.sql.Types.DECIMALãŸãã¯java.sql.Types.NUMERIC typesã®å Žåãããã¯å°æ°ç¹ã®ããšã®æ¡æ°ã«ãªãã Javaãªããžã§ã¯ãåInputStreamããã³Readerã®å Žåã¯ãã¹ããªãŒã ãŸãã¯ãªãŒããŒã®ããŒã¿é·ã ã»ãã®ãã¹ãŠã®åã§ã¯ããã®å€ã¯ç¡èŠãããã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåTypesvoid setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
java.langãªããžã§ã¯ãã䜿çšãã¹ãã§ãã
æå®ãããJavaãªããžã§ã¯ãã¯ãããŒã¿ããŒã¹ã«éãããåã«ãæå®ãããtargetSqlTypeã«å€æãããŸãã ãªããžã§ã¯ããã«ã¹ã¿ã ã»ãããã³ã°ãæã€å Žå(ãªããžã§ã¯ããã€ã³ã¿ãã§ãŒã¹SQLDataãå®è£
ããã¯ã©ã¹ã®ã€ã³ã¹ã¿ã³ã¹ã§ããå Žå)ãJDBCãã©ã€ãã¯SQLData.writeSQLã¡ãœãããåŒã³åºããŠããã®ãªããžã§ã¯ããSQLããŒã¿ã»ã¹ããªãŒã ãžæžã蟌ãå¿
èŠããããŸãã ãŸãããªããžã§ã¯ããRefãBlobãClobãNClobãStructãjava.net.URLããŸãã¯Arrayãå®è£
ããã¯ã©ã¹ã®ãªããžã§ã¯ãã§ããå Žåããã©ã€ãã¯ãã®ãªããžã§ã¯ãã察å¿ããSQLåã®å€ãšããŠããŒã¿ããŒã¹ã«æž¡ãå¿
èŠããããŸãã
ãã®ã¡ãœããã¯ãããŒã¿ããŒã¹åºæã®æœè±¡ããŒã¿åãæž¡ãããã«äœ¿çšã§ããããšã«æ³šæããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãtargetSqlType - ããŒã¿ããŒã¹ã«éããã(java.sql.Typesã§å®çŸ©ããã) SQLåã scaleåŒæ°ã§ãããã«ãã®åãéå®ã§ããã scale - java.sql.Types.DECIMALãjava.sql.Types.NUMERICåã§ã¯ãå°æ°ç¹ä»¥äžã®æ¡æ°ã ã»ãã®ãã¹ãŠã®åã§ã¯ããã®å€ã¯ç¡èŠãããã SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - targetSqlTypeã®ããŒã¿åããARRAYãBLOBãCLOBãDATALINKãJAVA_OBJECTãNCHARãNCLOBãNVARCHARãLONGNVARCHARãREFãROWIDãSQLXMLããŸãã¯STRUCTã§ãJDBCãã©ã€ãããã®ããŒã¿åããµããŒãããŠããªãå ŽåTypesãResultSet.getObject(int)void setObject(int parameterIndex,
Object x,
int targetSqlType)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããJava Objectã«èšå®ããŸãã æŽæ°å€ã®å Žåã¯ç䟡ãªjava.langãªããžã§ã¯ãã䜿çšããå¿
èŠããããŸãã ãã®ã¡ãœããã¯åè¿°ã®setObjectã«äŒŒãŠããŸããã䜿ãããã¹ã±ãŒã«ã¯2çªç®ã®ãã©ã¡ãŒã¿ã®ã¹ã±ãŒã«ã«ãªããŸãã ã¹ã«ã©ãŒå€ã®ã¹ã±ãŒã«ã¯0ã§ãã ãªãã©ã«å€ãä¿æããã¹ã±ãŒã«ã¯ããªãã©ã«å
ã«ååšããŸãã
æµ®åå°æ°ç¹ã®å ¥åå€ã§ãã®ã¡ãœãããåŒã³åºãããšã¯ããµããŒããããŠããŸããæšå¥šã¯ãããŠããŸããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãtargetSqlType - ããŒã¿ããŒã¹ã«éããã(java.sql.Typesã§å®çŸ©ããã) SQLåSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObjectã¡ãœããã«äŒŒãŠããŸãããscaleã«0ãä»®å®ããŠããç¹ãç°ãªããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãtargetSqlType - ããŒã¿ããŒã¹ã«éããã(java.sql.Typesã§å®çŸ©ããã) SQLåSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - targetSqlTypeã®ããŒã¿åããARRAYãBLOBãCLOBãDATALINKãJAVA_OBJECTãNCHARãNCLOBãNVARCHARãLONGNVARCHARãREFãROWIDãSQLXMLããŸãã¯STRUCTã§ãJDBCãã©ã€ãããã®ããŒã¿åããµããŒãããŠããªãå ŽåResultSet.getObject(int)void setObject(String parameterName, Object x) throws SQLException
Objectåã§ããå¿
èŠããããŸãããããã£ãŠãçµèŸŒã¿åã®å Žåãç䟡ãªjava.langãªããžã§ã¯ãã䜿çšãã¹ãã§ãã
JDBCã®ä»æ§ã§ã¯ãJavaã®ObjectåããSQLåãžã®æšæºãããã³ã°ãèŠå®ããŠããŸãã æå®ãããåŒæ°ã¯ãããŒã¿ããŒã¹ã«éãããåã«ã察å¿ããSQLåã«å€æãããŸãã
ãã®ã¡ãœããã¯ããã©ã€ãåºæã®Javaåã䜿çšããŠãããŒã¿ããŒã¹åºæã®æœè±¡ããŒã¿åãæž¡ãããã«äœ¿çšããããšã«æ³šæããŠãã ããã ãªããžã§ã¯ããã€ã³ã¿ãã§ãŒã¹SQLDataãå®è£
ããã¯ã©ã¹ã®ã€ã³ã¹ã¿ã³ã¹ã§ããå ŽåãJDBCãã©ã€ãã¯SQLData.writeSQLã¡ãœãããåŒã³åºããŠããã®ãªããžã§ã¯ããSQLããŒã¿ã»ã¹ããªãŒã ãžæžã蟌ãå¿
èŠããããŸãã ãŸãããªããžã§ã¯ããRefãBlobãClobãNClobãStructãjava.net.URLããŸãã¯Arrayãå®è£
ããã¯ã©ã¹ã®ãªããžã§ã¯ãã§ããå Žåããã©ã€ãã¯ãã®ãªããžã§ã¯ãã察å¿ããSQLåã®å€ãšããŠããŒã¿ããŒã¹ã«æž¡ãå¿
èŠããããŸãã
ããšãã°ããªããžã§ã¯ããäžèšã®ã€ã³ã¿ãã§ãŒã¹ãè€æ°å®è£ ããã¯ã©ã¹ã§ãããªã©ããããŸãããããå Žåããã®ã¡ãœããã¯äŸå€ãã¹ããŒããŸãã
parameterName - ãã©ã¡ãŒã¿ã®ååx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããCallableStatementã§åŒã³åºãããå ŽåããŸãã¯æå®ãããObjectãã©ã¡ãŒã¿ããããŸããªå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getObject(int)void setObject(int parameterIndex,
Object x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãå
ã®æå®ãããã©ã¡ãŒã¿ããJava Objectã«èšå®ããŸãã æŽæ°å€ã®å Žåã¯ç䟡ãªjava.langãªããžã§ã¯ãã䜿çšããå¿
èŠããããŸãã
JDBCã¯ãJavaã®ObjectåããSQLåãžã®æšæºãããã³ã°ãæäŸããŸãã æå®ãããJavaãªããžã§ã¯ãã¯ãããŒã¿ããŒã¹ã«éãããåã«ãã©ã€ãã«ãã£ãŠæšæºã®SQLãããã³ã°ã«å€æãããŸãã
ãã®ã¡ãœããã¯ããã©ã€ãåºæã®Javaåã䜿çšããŠãããŒã¿ããŒã¹åºæã®æœè±¡ããŒã¿åãæž¡ãããã«äœ¿çšããããšã«æ³šæããŠãã ããã ãªããžã§ã¯ãã®ã¯ã©ã¹ãSQLDataãå®è£
ããå Žåã¯ãè¡ã»ããã§SQLData.writeSQLã¡ãœãããåŒã³åºããŠããªããžã§ã¯ããSQLOutputããŒã¿ã»ã¹ããªãŒã ã«æžã蟌ãå¿
èŠããããŸãã ãŸãããªããžã§ã¯ããRefãBlobãClobãNClobãStructãjava.net.URLããŸãã¯Arrayãå®è£
ããã¯ã©ã¹ã®ãªããžã§ã¯ãã§ããå Žåããã©ã€ãã¯ãã®ãªããžã§ã¯ãã察å¿ããSQLåã®å€ãšããŠããŒã¿ããŒã¹ã«æž¡ãå¿
èŠããããŸãã
ããšãã°ããªããžã§ã¯ãããããã®ã€ã³ã¿ãã§ãŒã¹ãè€æ°å®è£ ããã¯ã©ã¹ã§ãããªã©ããããŸãããããå ŽåãäŸå€ãã¹ããŒãããŸãã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - å
¥åãã©ã¡ãŒã¿å€ãå«ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setRef(int i,
Ref x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããRefå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãã©ã€ãã«ãã£ãŠé©åãªREF(<structured-type>) (æ§é åå)å€ã«å€æãããŸãã i - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - SQL REFåã®ããŒã¿ã衚ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBlob(int i,
Blob x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããBlobå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ããã©ã€ãã«ãã£ãŠBlobãªããžã§ã¯ãã衚ãBLOBå€ã«å€æãããŸãã i - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - BLOBã衚ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setBlob(int parameterIndex,
InputStream inputStream,
long length)
throws SQLException
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã inputstreamã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãPreparedStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetBinaryStream (int, InputStream, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãBLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setBinaryStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARBINARYãšBLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãinputStream - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®ãã€ãæ°ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããPreparedStatementäžã§åŒã³åºãããå ŽåãparameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå Žåãé·ããšããŠãŒãæªæºã®å€ãæå®ãããå Žåãå
¥åã¹ããªãŒã å
ã®ãã€ãæ°ãæå®ãããé·ããšäžèŽããŠããªãå ŽåãSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBlob(int parameterIndex,
InputStream inputStream)
throws SQLException
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetBinaryStream (int, InputStream)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãBLOBãšããŠãµãŒããŒã«éä¿¡ããªããã°ãªããªãããšããã©ã€ãã«éç¥ããŸãã setBinaryStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARBINARYãšBLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setBlobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãinputStream - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã§åŒã³åºãããå ŽåããŸãã¯parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå ŽåãSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã inputstreamã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãCallableStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetBinaryStream (int, InputStream, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãBLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setBinaryStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARBINARYãšBLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterName - 2çªç®ã¯2ã«èšå®ããããã©ã¡ãŒã¿ã®ååinputStream - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®ãã€ãæ°ãSQLException - parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå Žåãé·ããšããŠãŒãæªæºã®å€ãæå®ãããå Žåãå
¥åã¹ããªãŒã å
ã®ãã€ãæ°ãæå®ãããé·ããšäžèŽããŠããªãå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBlob(String parameterName, Blob x) throws SQLException
java.sql.Blobãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL BLOBå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - SQL BLOBå€ããããã³ã°ããBlobãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setBlob(String parameterName, InputStream inputStream) throws SQLException
InputStreamãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetBinaryStream (int, InputStream)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãBLOBãšããŠãµãŒããŒã«éä¿¡ããªããã°ãªããªãããšããã©ã€ãã«éç¥ããŸãã setBinaryStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARBINARYãšBLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ãããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setBlobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååinputStream - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setClob(int i,
Clob x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããClobå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ããã©ã€ãã«ãã£ãŠClobãªããžã§ã¯ãã衚ãCLOBå€ã«å€æãããŸãã i - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - CLOBã衚ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã readerã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãPreparedStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARCHARãšCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã§åŒã³åºãããå ŽåãparameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå ŽåããŸãã¯é·ããšããŠãŒãæªæºã®å€ãæå®ãããå ŽåãSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setClob(int parameterIndex,
Reader reader)
throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARCHARãšCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setClobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã§åŒã³åºãããå ŽåããŸãã¯parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setClob(String parameterName, Reader reader, long length) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã readerã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãCallableStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARCHARãšCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ãããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterName - èšå®ããããã©ã¡ãŒã¿ã®ååãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå Žåãé·ããšããŠãŒãæªæºã®å€ãæå®ãããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããCallableStatementã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setClob(String parameterName, Clob x) throws SQLException
java.sql.Clobãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL CLOBå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - SQL CLOBå€ããããã³ã°ããClobãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setClob(String parameterName, Reader reader) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGVARCHARãšCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ãããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setClobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setArray(int i,
Array x)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããArrayå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ããã©ã€ãã«ãã£ãŠArrayãªããžã§ã¯ãã衚ãARRAYå€ã«å€æãããŸãã i - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - SQL ARRAYã衚ããªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setDate(int parameterIndex,
Date x,
Calendar cal)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Dateå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãæå®ããjava.util.Calendarãªããžã§ã¯ãã䜿çšããŠæ¥ä»ãèšç®ããããã©ã€ãã«ãã£ãŠSQL DATEå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€cal - æ¥ä»ã®èšç®ã«äœ¿çšããjava.util.Calendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setDate(String parameterName, Date x) throws SQLException
java.sql.Dateå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL DATEå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getDate(int)void setDate(String parameterName, Date x, Calendar cal) throws SQLException
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Dateå€ã«èšå®ããŸãã ãã©ã€ãã¯Calendarãªããžã§ã¯ãã䜿çšããŠSQL DATEå€ãäœæããç¶ããŠãããããŒã¿ããŒã¹ã«éããŸãã Calendarãªããžã§ã¯ãã䜿çšãããšããã©ã€ãã¯ã«ã¹ã¿ã ã»ã¿ã€ã ãŸãŒã³ãèæ
®ããŠæ¥ä»ãèšç®ã§ããŸãã Calendarãªããžã§ã¯ããæå®ããªãå Žåããã©ã€ãã¯ãã¢ããªã±ãŒã·ã§ã³ãå®è¡ããŠããä»®æ³ãã·ã³ã®ã¿ã€ã ãŸãŒã³ã§ããããã©ã«ãã®ã¿ã€ã ãŸãŒã³ã䜿çšããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€cal - ãã©ã€ããæ¥ä»ãäœæããããã«äœ¿çšããCalendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getDate(int)void setTime(int parameterIndex,
Time x,
Calendar cal)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Timeå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ãæå®ããjava.util.Calendarãªããžã§ã¯ãã䜿çšããŠæ¥ä»ãèšç®ããããã©ã€ãã«ãã£ãŠSQL TIMEå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€cal - æéã®èšç®ã«äœ¿çšããjava.util.Calendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setTime(String parameterName, Time x) throws SQLException
java.sql.Timeå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL TIMEå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getTime(int)void setTime(String parameterName, Time x, Calendar cal) throws SQLException
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Timeå€ã«èšå®ããŸãã ãã©ã€ãã¯Calendarãªããžã§ã¯ãã䜿çšããŠSQL TIMEå€ãäœæããç¶ããŠãããããŒã¿ããŒã¹ã«éããŸãã Calendarãªããžã§ã¯ãã䜿çšãããšããã©ã€ãã¯ã«ã¹ã¿ã ã»ã¿ã€ã ãŸãŒã³ãèæ
®ããŠæéãèšç®ã§ããŸãã Calendarãªããžã§ã¯ããæå®ããªãå Žåããã©ã€ãã¯ãã¢ããªã±ãŒã·ã§ã³ãå®è¡ããŠããä»®æ³ãã·ã³ã®ã¿ã€ã ãŸãŒã³ã§ããããã©ã«ãã®ã¿ã€ã ãŸãŒã³ã䜿çšããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€cal - ãã©ã€ããæéãäœæããããã«äœ¿çšããCalendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getTime(int)void setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãã§æå®ãããã©ã¡ãŒã¿ããæå®ããjava.sql.Timestampå€ã«èšå®ããŸãã ãã®ãã©ã¡ãŒã¿ã¯ãããŒã¿ããŒã¹ãžã®éä¿¡åã«ãæå®ããjava.util.Calendarãªããžã§ã¯ãã䜿çšããŠæ¥ä»ãèšç®ããããã©ã€ãã«ãã£ãŠSQL TIMESTAMPå€ã«å€æãããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€cal - ã¿ã€ã ã¹ã¿ã³ãã®èšç®ã«äœ¿çšããjava.util.Calendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
Calendarãªããžã§ã¯ãã䜿çšããŠãæå®ããããã©ã¡ãŒã¿ãæå®ãããjava.sql.Timestampå€ã«èšå®ããŸãã ãã©ã€ãã¯Calendarãªããžã§ã¯ãã䜿çšããŠSQL TIMESTAMPå€ãäœæããç¶ããŠãããããŒã¿ããŒã¹ã«éããŸãã Calendarãªããžã§ã¯ãã䜿çšãããšããã©ã€ãã¯ã«ã¹ã¿ã ã»ã¿ã€ã ãŸãŒã³ãèæ
®ããŠã¿ã€ã ã¹ã¿ã³ããèšç®ã§ããŸãã Calendarãªããžã§ã¯ããæå®ããªãå Žåããã©ã€ãã¯ãã¢ããªã±ãŒã·ã§ã³ãå®è¡ããŠããä»®æ³ãã·ã³ã®ã¿ã€ã ãŸãŒã³ã§ããããã©ã«ãã®ã¿ã€ã ãŸãŒã³ã䜿çšããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€cal - ãã©ã€ããã¿ã€ã ã¹ã¿ã³ããäœæããããã«äœ¿çšããCalendarãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå ŽåResultSet.getTimestamp(int)void clearParameters()
throws SQLException
RowSetãªããžã§ã¯ãã®ã³ãã³ãçšã®ãã©ã¡ãŒã¿ã»ã»ãããã¯ãªã¢ããŸãã
éåžžãRowSetãªããžã§ã¯ããç¹°è¿ã䜿çšããããã«ããã©ã¡ãŒã¿å€ã¯åŒ·å¶çã«æ®ãããŸãã ãã©ã¡ãŒã¿å€ãèšå®ãããšãåã®å€ã¯èªåçã«ã¯ãªã¢ãããŸãã ããããçŸåšã®ãã©ã¡ãŒã¿å€ã«ãã£ãŠäœ¿çšããããªãœãŒã¹ããã ã¡ã«è§£æŸããæ¹ã圹ã«ç«ã€å ŽåããããŸããããã¯ãclearParametersã¡ãœãããåŒã³åºããŠå®è¡ã§ããŸãã
SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid execute()
throws SQLException
RowSetãªããžã§ã¯ãã«ããŒã¿ãæ ŒçŽããŸãã
executeã¡ãœããã¯ãurlãããŒã¿ã»ãœãŒã¹åããŠãŒã¶ãŒåããã¹ã¯ãŒãããã©ã³ã¶ã¯ã·ã§ã³é®æãåããããªã©ã®ããããã£ã䜿çšããŠãããŒã¿ãèªã¿åãããã«æ¥ç¶ãäœæããŸãã executeã¡ãœããã¯ãã³ãã³ããèªåãå°çšãæå€§ãã£ãŒã«ãã»ãµã€ãºãæå€§è¡æ°ããšã¹ã±ãŒãåŠçãã¯ãšãªãŒã»ã¿ã€ã ã¢ãŠããªã©ã®ããããã£ã䜿çšããŠãã³ãã³ãå®è¡æãäœæããŸãã
èŠæ±ããããããã£ãèšå®ãããŠããªãå Žåã¯äŸå€ãã¹ããŒãããŸãã ãã®ã¡ãœããã®å®è¡ãæåãããšãè¡ã»ããã®çŸåšã®å 容ã¯ç Žæ£ãããè¡ã»ããã®ã¡ã¿ããŒã¿ã(å)èšå®ãããŸãã æªåŠçã®æŽæ°ãããå Žåããããã¯ç¡èŠãããŸãã
ãã®RowSetãªããžã§ã¯ããããŒã¿ã®ãœãŒã¹ãšã®é£ç¶ããæ¥ç¶ãä¿æã§ããªãå Žåã¯ããªãŒããŒ(RowSetReaderãªããžã§ã¯ã)ãããŒã¿ãå
¥ããããã«äœ¿çšãããŸãã ãã®å ŽåããªãŒããŒã¯ãã®RowSetãªããžã§ã¯ãã§ç»é²ãããŠãããexecuteã¡ãœããã§ã¯ãå®è£
ã®äžéšãšããŠãªãŒããŒã®readDataã¡ãœãããåŒã³åºããŸãã
SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãæ¥ç¶ãäœæããæãäœæããããã«å¿
èŠãªããããã£ã®ã©ãããèšå®ãããŠããªãå Žåvoid addRowSetListener(RowSetListener listener)
RowSetãªããžã§ã¯ãã§çºçããã€ãã³ããéç¥ãããããã«ããŸããlistener - RowSetListenerã€ã³ã¿ãã§ãŒã¹ãå®è£
ãããã€ããã®RowSetãªããžã§ã¯ãã§ã€ãã³ããçºçãããšãã«éç¥ãåããã³ã³ããŒãã³ãremoveRowSetListener(javax.sql.RowSetListener)void removeRowSetListener(RowSetListener listener)
RowSetãªããžã§ã¯ãã§ã€ãã³ããçºçãããšãã«éç¥ãããã³ã³ããŒãã³ãã®ãªã¹ãããåé€ããŸããlistener - ãã®RowSetãªããžã§ã¯ãã®ãªã¹ããŒãšããŠç»é²ãããŠããã³ã³ããŒãã³ãaddRowSetListener(javax.sql.RowSetListener)void setSQLXML(int parameterIndex,
SQLXML xmlObject)
throws SQLException
java.sql.SQLXMLãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL XMLå€ã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãxmlObject - SQL XMLå€ããããã³ã°ããSQLXMLãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããçµæã»ããã§åŒã³åºãããå ŽåãSQLXMLãªããžã§ã¯ãçšã®java.xml.transform.ResultãWriterããŸãã¯OutputStreamãã¯ããŒãºãããŠããªãå Žåããããã¯XMLå€ã®åŠçäžã«ãšã©ãŒãçºçããå Žåã ãã®äŸå€ã®getCauseã¡ãœããã«ããããã詳现ãªäŸå€ãæäŸãããããšããã(ããšãã°ã¹ããªãŒã ã«æå¹ãªXMLãå«ãŸããŠããªãå Žå)ã void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
java.sql.SQLXMLãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL XMLå€ã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååxmlObject - SQL XMLå€ããããã³ã°ããSQLXMLãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåããã®ã¡ãœãããã¯ããŒãºãããçµæã»ããã§åŒã³åºãããå ŽåãSQLXMLãªããžã§ã¯ãçšã®java.xml.transform.ResultãWriterããŸãã¯OutputStreamãã¯ããŒãºãããŠããªãå Žåããããã¯XMLå€ã®åŠçäžã«ãšã©ãŒãçºçããå Žåã ãã®äŸå€ã®getCauseã¡ãœããã«ããããã詳现ãªäŸå€ãæäŸãããããšããã(ããšãã°ã¹ããªãŒã ã«æå¹ãªXMLãå«ãŸããŠããªãå Žå)ã void setRowId(int parameterIndex,
RowId x)
throws SQLException
java.sql.RowIdãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL ROWIDå€ã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setRowId(String parameterName, RowId x) throws SQLException
java.sql.RowIdãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL ROWIDã«å€æããŸãã parameterName - ãã©ã¡ãŒã¿ã®ååx - ãã©ã¡ãŒã¿å€SQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNString(int parameterIndex,
String value)
throws SQLException
Stringãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL NCHARãNVARCHARããŸãã¯LONGNVARCHARå€(ãã©ã€ãã®NVARCHARå€ã«é¢ããå¶éã«é¢ããåŒæ°ã®ãµã€ãºã«äŸå)ã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNString(String parameterName, String value) throws SQLException
Stringãªããžã§ã¯ãã«èšå®ããŸãã ãã©ã€ãã¯ãããSQL NCHARãNVARCHARããŸãã¯LONGNVARCHARã«å€æããŸãã parameterName - èšå®ãããåã®ååvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNCharacterStream(int parameterIndex,
Reader value,
long length)
throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã Readerã¯ããã¡ã€ã«ã®çµããã«éãããŸã§ããŒã¿ãèªã¿èŸŒã¿ãŸãã ãã©ã€ãã¯ãå¿
èŠã«å¿ããŠãJavaã®æå衚çŸãããŒã¿ããŒã¹å
ã®ååœæåã»ããã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãvalue - ãã©ã¡ãŒã¿å€length - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNCharacterStream(String parameterName, Reader value, long length) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã Readerã¯ããã¡ã€ã«ã®çµããã«éãããŸã§ããŒã¿ãèªã¿èŸŒã¿ãŸãã ãã©ã€ãã¯ãå¿
èŠã«å¿ããŠãJavaã®æå衚çŸãããŒã¿ããŒã¹å
ã®ååœæåã»ããã«å€æããŸãã parameterName - èšå®ãããåã®ååvalue - ãã©ã¡ãŒã¿å€length - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNCharacterStream(String parameterName, Reader value) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã Readerã¯ããã¡ã€ã«ã®çµããã«éãããŸã§ããŒã¿ãèªã¿èŸŒã¿ãŸãã ãã©ã€ãã¯ãå¿
èŠã«å¿ããŠãJavaã®æå衚çŸãããŒã¿ããŒã¹å
ã®ååœæåã»ããã«å€æããŸãã
ããŒã: ãã®ã¹ããªãŒã ã»ãªããžã§ã¯ãã¯ãæšæºã®Javaã¹ããªãŒã ã»ãªããžã§ã¯ãããŸãã¯æšæºã€ã³ã¿ãã§ãŒã¹ãå®è£ ããç¬èªã®ãµãã¯ã©ã¹ã®ã©ã¡ãã§ãããŸããŸããã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setNCharacterStreamã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNClob(String parameterName, NClob value) throws SQLException
java.sql.NClobãªããžã§ã¯ãã«èšå®ããŸãã ãã®ãªããžã§ã¯ãã¯ãjava.sql.NClobã€ã³ã¿ãã§ãŒã¹ãå®è£
ããŸãã ãã®NClobãªããžã§ã¯ãã¯ãSQL NCLOBã«ãããã³ã°ãããŸãã parameterName - èšå®ãããåã®ååvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNClob(String parameterName, Reader reader, long length) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã readerã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãCallableStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãNCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGNVARCHARãšNCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ãããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterName - èšå®ããããã©ã¡ãŒã¿ã®ååãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå Žåãé·ããšããŠãŒãæªæºã®å€ãæå®ãããå Žåããã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNClob(String parameterName, Reader reader) throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãNCLOBãšããŠãµãŒããŒã«éä¿¡ããªããã°ãªããªãããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGNVARCHARãšNCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ãããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setNClobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterName - ãã©ã¡ãŒã¿ã®ååreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããCallableStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNClob(int parameterIndex,
Reader reader,
long length)
throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã readerã«ã¯ãlengthã§æå®ãããæåæ°ãå«ãŸããŠããå¿
èŠããããŸããããã§ãªãå ŽåãPreparedStatementã®å®è¡æã«SQLExceptionãçæãããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader, int)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãNCLOBãšããŠãµãŒããŒã«éä¿¡ããã¹ãã§ããããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGNVARCHARãšNCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããlength - ãã©ã¡ãŒã¿ã»ããŒã¿å
ã®æåæ°ãSQLException - parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒãšå¯Ÿå¿ããŠããªãå Žåãé·ããšããŠãŒãæªæºã®å€ãæå®ãããå Žåããã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementäžã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setNClob(int parameterIndex,
NClob value)
throws SQLException
java.sql.NClobãªããžã§ã¯ãã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL NCLOBå€ã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãvalue - ãã©ã¡ãŒã¿å€SQLException - ãã©ã€ããååœæåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããå¯èœæ§ãæ€åºã§ããå ŽåããŸãã¯ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå Žåvoid setNClob(int parameterIndex,
Reader reader)
throws SQLException
Readerãªããžã§ã¯ãã«èšå®ããŸãã ãã®ã¡ãœããã¯ãsetCharacterStream (int, Reader)ã¡ãœãããšç°ãªãããã©ã¡ãŒã¿å€ãNCLOBãšããŠãµãŒããŒã«éä¿¡ããªããã°ãªããªãããšããã©ã€ãã«éç¥ããŸãã setCharacterStreamã¡ãœããã䜿çšãããšããã©ã€ãã¯ããã©ã¡ãŒã¿ã»ããŒã¿ãLONGNVARCHARãšNCLOBã®ã©ã¡ããšããŠãµãŒããŒã«éä¿¡ããã¹ããã倿ããããã«äœèšãªäœæ¥ãè¡ãå¿
èŠãããå¯èœæ§ããããŸãã
ããŒã: lengthãã©ã¡ãŒã¿ã䜿çšããããŒãžã§ã³ã®setNClobã䜿çšããæ¹ãå¹ççãã©ããã倿ããã«ã¯ãJDBCãã©ã€ãã®ããã¥ã¡ã³ããåç
§ããŠãã ããã
parameterIndex - æåã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã®ã€ã³ããã¯ã¹ã¯2ã... ãšãªãreader - ãã©ã¡ãŒã¿å€ã«èšå®ãããããŒã¿ãå«ããªããžã§ã¯ããSQLException - parameterIndexãSQLæã®ãã©ã¡ãŒã¿ã»ããŒã«ãŒã«å¯Ÿå¿ããªãå Žåããã©ã€ããååœã®æåã»ããããµããŒãããªãå Žåããã©ã€ããããŒã¿å€æãšã©ãŒãçºçããããšãæ€åºã§ããå ŽåãããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã§åŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žåvoid setURL(int parameterIndex,
URL x)
throws SQLException
java.net.URLå€ã«èšå®ããŸãã ããŒã¿ããŒã¹ã«éããšãã«ããã©ã€ãã¯ãããSQL DATALINKå€ã«å€æããŸãã parameterIndex - æåã®ãã©ã¡ãŒã¿ã¯1ã2çªç®ã®ãã©ã¡ãŒã¿ã¯2ã... ãšãªãx - èšå®ãããjava.net.URLãªããžã§ã¯ãSQLException - ããŒã¿ããŒã¹ã»ã¢ã¯ã»ã¹ã»ãšã©ãŒãçºçããå ŽåããŸãã¯ãã®ã¡ãœãããã¯ããŒãºãããPreparedStatementã«ã€ããŠåŒã³åºãããå ŽåSQLFeatureNotSupportedException - JDBCãã©ã€ãããã®ã¡ãœããããµããŒãããªãå Žå ãã°ãŸãã¯æ©èœãéä¿¡
詳现ãªAPIãªãã¡ã¬ã³ã¹ããã³éçºè
ããã¥ã¡ã³ãã«ã€ããŠã¯ãJava SEã®ããã¥ã¡ã³ããåç
§ããŠãã ããã ãã®ããã¥ã¡ã³ãã«ã¯ãæŠå¿µçãªæŠèŠãçšèªã®å®çŸ©ãåé¿æ¹æ³ãæå¹ãªã³ãŒãäŸãªã©ã®ãéçºè
ã察象ã«ãããã詳现ãªèª¬æãå«ãŸããŠããŸãã
Copyright © 1993, 2025, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Documentation Redistribution Policyãåç
§ããŠãã ããã