1 7 package com.nilostep.xlsql.jdbc; 8 9 import java.io.*; 10 11 import java.math.BigDecimal ; 12 13 import java.net.URL ; 14 15 import java.sql.*; 16 17 import java.util.*; 18 19 public class xlResultSet implements java.sql.ResultSet { 20 21 xlStatement xlStm; 22 ResultSet dbRs; 23 24 29 protected xlResultSet(xlStatement stm, ResultSet rs) { 30 xlStm = stm; 31 dbRs = rs; 32 } 33 34 36 40 public boolean absolute(int row) throws SQLException { 41 return dbRs.absolute(row); 42 } 43 44 48 public void afterLast() throws SQLException { 49 dbRs.afterLast(); 50 } 51 52 56 public void beforeFirst() throws SQLException { 57 dbRs.beforeFirst(); 58 } 59 60 64 public void cancelRowUpdates() throws SQLException { 65 dbRs.cancelRowUpdates(); 66 } 67 68 72 public void clearWarnings() throws SQLException { 73 dbRs.clearWarnings(); 74 } 75 76 80 public void close() throws SQLException { 81 dbRs.close(); 82 } 83 84 88 public void deleteRow() throws SQLException { 89 dbRs.deleteRow(); 90 } 91 92 96 public int findColumn(String columnName) throws SQLException { 97 return dbRs.findColumn(columnName); 98 } 99 100 104 public boolean first() throws SQLException { 105 return dbRs.first(); 106 } 107 108 112 public Array getArray(int i) throws SQLException { 113 return dbRs.getArray(i); 114 } 115 116 120 public Array getArray(String colName) throws SQLException { 121 return dbRs.getArray(colName); 122 } 123 124 128 public java.io.InputStream getAsciiStream(int columnIndex) 129 throws SQLException { 130 return dbRs.getAsciiStream(columnIndex); 131 } 132 133 137 public java.io.InputStream getAsciiStream(String columnName) 138 throws SQLException { 139 return dbRs.getAsciiStream(columnName); 140 } 141 142 146 public BigDecimal getBigDecimal(int columnIndex) throws SQLException { 147 return dbRs.getBigDecimal(columnIndex); 148 } 149 150 154 public BigDecimal getBigDecimal(int columnIndex, int scale) 155 throws SQLException { 156 return dbRs.getBigDecimal(columnIndex, scale); 157 } 158 159 163 public BigDecimal getBigDecimal(String columnName) 164 throws SQLException { 165 return dbRs.getBigDecimal(columnName); 166 } 167 168 172 public BigDecimal getBigDecimal(String columnName, int scale) 173 throws SQLException { 174 return dbRs.getBigDecimal(columnName, scale); 175 } 176 177 181 public InputStream getBinaryStream(int columnIndex) 182 throws SQLException { 183 return dbRs.getBinaryStream(columnIndex); 184 } 185 186 190 public InputStream getBinaryStream(String columnName) 191 throws SQLException { 192 return dbRs.getBinaryStream(columnName); 193 } 194 195 199 public Blob getBlob(int i) throws SQLException { 200 return dbRs.getBlob(i); 201 } 202 203 207 public Blob getBlob(String colName) throws SQLException { 208 return dbRs.getBlob(colName); 209 } 210 211 215 public boolean getBoolean(int columnIndex) throws SQLException { 216 return dbRs.getBoolean(columnIndex); 217 } 218 219 223 public boolean getBoolean(String columnName) throws SQLException { 224 return dbRs.getBoolean(columnName); 225 } 226 227 231 public byte getByte(int columnIndex) throws SQLException { 232 return dbRs.getByte(columnIndex); 233 } 234 235 239 public byte getByte(String columnName) throws SQLException { 240 return dbRs.getByte(columnName); 241 } 242 243 247 public byte[] getBytes(int columnIndex) throws SQLException { 248 return dbRs.getBytes(columnIndex); 249 } 250 251 255 public byte[] getBytes(String columnName) throws SQLException { 256 return dbRs.getBytes(columnName); 257 } 258 259 263 public Reader getCharacterStream(int columnIndex) 264 throws SQLException { 265 return dbRs.getCharacterStream(columnIndex); 266 } 267 268 272 public Reader getCharacterStream(String columnName) 273 throws SQLException { 274 return dbRs.getCharacterStream(columnName); 275 } 276 277 281 public Clob getClob(int i) throws SQLException { 282 return dbRs.getClob(i); 283 } 284 285 289 public Clob getClob(String colName) throws SQLException { 290 return dbRs.getClob(colName); 291 } 292 293 297 public int getConcurrency() throws SQLException { 298 return dbRs.getConcurrency(); 299 } 300 301 305 public String getCursorName() throws SQLException { 306 return dbRs.getCursorName(); 307 } 308 309 313 public java.sql.Date getDate(int columnIndex) throws SQLException { 314 return dbRs.getDate(columnIndex); 315 } 316 317 321 public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) 322 throws SQLException { 323 return dbRs.getDate(columnIndex, cal); 324 } 325 326 330 public java.sql.Date getDate(String columnName) throws SQLException { 331 return dbRs.getDate(columnName); 332 } 333 334 338 public java.sql.Date getDate(String columnName, java.util.Calendar cal) 339 throws SQLException { 340 return dbRs.getDate(columnName, cal); 341 } 342 343 347 public double getDouble(int columnIndex) throws SQLException { 348 return dbRs.getDouble(columnIndex); 349 } 350 351 355 public double getDouble(String columnName) throws SQLException { 356 return dbRs.getDouble(columnName); 357 } 358 359 363 public int getFetchDirection() throws SQLException { 364 return dbRs.getFetchDirection(); 365 } 366 367 371 public int getFetchSize() throws SQLException { 372 return dbRs.getFetchSize(); 373 } 374 375 379 public float getFloat(int columnIndex) throws SQLException { 380 return dbRs.getFloat(columnIndex); 381 } 382 383 387 public float getFloat(String columnName) throws SQLException { 388 return dbRs.getFloat(columnName); 389 } 390 391 395 public int getInt(int columnIndex) throws SQLException { 396 return dbRs.getInt(columnIndex); 397 } 398 399 403 public int getInt(String columnName) throws SQLException { 404 return dbRs.getInt(columnName); 405 } 406 407 411 public long getLong(int columnIndex) throws SQLException { 412 return dbRs.getLong(columnIndex); 413 } 414 415 419 public long getLong(String columnName) throws SQLException { 420 return dbRs.getLong(columnName); 421 } 422 423 427 public ResultSetMetaData getMetaData() throws SQLException { 428 ResultSetMetaData dbRsMeta = dbRs.getMetaData(); 429 ResultSetMetaData rsMeta = new xlResultSetMetaData(this, dbRsMeta); 430 return rsMeta; 431 } 432 433 437 public Object getObject(int columnIndex) throws SQLException { 438 return dbRs.getObject(columnIndex); 439 } 440 441 445 public Object getObject(int i, Map map) throws SQLException { 446 return dbRs.getObject(i, map); 447 } 448 449 453 public Object getObject(String columnName) throws SQLException { 454 return dbRs.getObject(columnName); 455 } 456 457 461 public Object getObject(String colName, Map map) 462 throws SQLException { 463 return dbRs.getObject(colName, map); 464 } 465 466 470 public Ref getRef(int i) throws SQLException { 471 return dbRs.getRef(i); 472 } 473 474 478 public Ref getRef(String colName) throws SQLException { 479 return dbRs.getRef(colName); 480 } 481 482 486 public int getRow() throws SQLException { 487 return dbRs.getRow(); 488 } 489 490 494 public short getShort(int columnIndex) throws SQLException { 495 return dbRs.getShort(columnIndex); 496 } 497 498 502 public short getShort(String columnName) throws SQLException { 503 return dbRs.getShort(columnName); 504 } 505 506 510 public Statement getStatement() throws SQLException { 511 return xlStm; 512 } 513 514 518 public String getString(int columnIndex) throws SQLException { 519 return dbRs.getString(columnIndex); 520 } 521 522 526 public String getString(String columnName) throws SQLException { 527 return dbRs.getString(columnName); 528 } 529 530 534 public Time getTime(int columnIndex) throws SQLException { 535 return dbRs.getTime(columnIndex); 536 } 537 538 542 public Time getTime(int columnIndex, java.util.Calendar cal) 543 throws SQLException { 544 return dbRs.getTime(columnIndex, cal); 545 } 546 547 551 public Time getTime(String columnName) throws SQLException { 552 return dbRs.getTime(columnName); 553 } 554 555 559 public Time getTime(String columnName, java.util.Calendar cal) 560 throws SQLException { 561 return dbRs.getTime(columnName, cal); 562 } 563 564 568 public Timestamp getTimestamp(int columnIndex) throws SQLException { 569 return dbRs.getTimestamp(columnIndex); 570 } 571 572 576 public Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) 577 throws SQLException { 578 return dbRs.getTimestamp(columnIndex, cal); 579 } 580 581 585 public Timestamp getTimestamp(String columnName) throws SQLException { 586 return dbRs.getTimestamp(columnName); 587 } 588 589 593 public Timestamp getTimestamp(String columnName, java.util.Calendar cal) 594 throws SQLException { 595 return dbRs.getTimestamp(columnName, cal); 596 } 597 598 602 public int getType() throws SQLException { 603 return dbRs.getType(); 604 } 605 606 610 public InputStream getUnicodeStream(int columnIndex) 611 throws SQLException { 612 return dbRs.getUnicodeStream(columnIndex); 613 } 614 615 619 public InputStream getUnicodeStream(String columnName) 620 throws SQLException { 621 return dbRs.getUnicodeStream(columnName); 622 } 623 624 628 public URL getURL(int columnIndex) throws SQLException { 629 return dbRs.getURL(columnIndex); 630 } 631 632 636 public URL getURL(String columnName) throws SQLException { 637 return dbRs.getURL(columnName); 638 } 639 640 644 public SQLWarning getWarnings() throws SQLException { 645 return dbRs.getWarnings(); 646 } 647 648 652 public void insertRow() throws SQLException { 653 dbRs.insertRow(); 654 } 655 656 660 public boolean isAfterLast() throws SQLException { 661 return dbRs.isAfterLast(); 662 } 663 664 668 public boolean isBeforeFirst() throws SQLException { 669 return dbRs.isBeforeFirst(); 670 } 671 672 676 public boolean isFirst() throws SQLException { 677 return dbRs.isFirst(); 678 } 679 680 684 public boolean isLast() throws SQLException { 685 return dbRs.isLast(); 686 } 687 688 692 public boolean last() throws SQLException { 693 return dbRs.last(); 694 } 695 696 700 public void moveToCurrentRow() throws SQLException { 701 dbRs.moveToCurrentRow(); 702 } 703 704 708 public void moveToInsertRow() throws SQLException { 709 dbRs.moveToInsertRow(); 710 } 711 712 716 public boolean next() throws SQLException { 717 return dbRs.next(); 718 } 719 720 724 public boolean previous() throws SQLException { 725 return dbRs.previous(); 726 } 727 728 732 public void refreshRow() throws SQLException { 733 dbRs.refreshRow(); 734 } 735 736 740 public boolean relative(int rows) throws SQLException { 741 return dbRs.relative(rows); 742 } 743 744 748 public boolean rowDeleted() throws SQLException { 749 return dbRs.rowDeleted(); 750 } 751 752 756 public boolean rowInserted() throws SQLException { 757 return dbRs.rowInserted(); 758 } 759 760 764 public boolean rowUpdated() throws SQLException { 765 return dbRs.rowUpdated(); 766 } 767 768 772 public void setFetchDirection(int direction) throws SQLException { 773 dbRs.setFetchDirection(direction); 774 } 775 776 780 public void setFetchSize(int rows) throws SQLException { 781 dbRs.setFetchSize(rows); 782 } 783 784 788 public void updateArray(int columnIndex, Array x) throws SQLException { 789 dbRs.updateArray(columnIndex, x); 790 } 791 792 796 public void updateArray(String columnName, Array x) 797 throws SQLException { 798 dbRs.updateArray(columnName, x); 799 } 800 801 805 public void updateAsciiStream(int columnIndex, InputStream x, int length) 806 throws SQLException { 807 dbRs.updateAsciiStream(columnIndex, x, length); 808 } 809 810 814 public void updateAsciiStream(String columnName, InputStream x, 815 int length) throws SQLException { 816 dbRs.updateAsciiStream(columnName, x, length); 817 } 818 819 823 public void updateBigDecimal(int columnIndex, BigDecimal x) 824 throws SQLException { 825 dbRs.updateBigDecimal(columnIndex, x); 826 } 827 828 832 public void updateBigDecimal(String columnName, BigDecimal x) 833 throws SQLException { 834 dbRs.updateBigDecimal(columnName, x); 835 } 836 837 841 public void updateBinaryStream(int columnIndex, InputStream x, int length) 842 throws SQLException { 843 dbRs.updateBinaryStream(columnIndex ,x, length); 844 } 845 846 850 public void updateBinaryStream(String columnName, InputStream x, 851 int length) throws SQLException { 852 dbRs.updateBinaryStream(columnName, x, length); 853 } 854 855 859 public void updateBlob(int columnIndex, Blob x) throws SQLException { 860 dbRs.updateBlob(columnIndex, x); 861 } 862 863 867 public void updateBlob(String columnName, Blob x) throws SQLException { 868 dbRs.updateBlob(columnName, x); 869 } 870 871 875 public void updateBoolean(int columnIndex, boolean x) 876 throws SQLException { 877 dbRs.updateBoolean(columnIndex, x); 878 } 879 880 884 public void updateBoolean(String columnName, boolean x) 885 throws SQLException { 886 dbRs.updateBoolean(columnName, x); 887 } 888 889 893 public void updateByte(int columnIndex, byte x) throws SQLException { 894 dbRs.updateByte(columnIndex, x); 895 } 896 897 901 public void updateByte(String columnName, byte x) throws SQLException { 902 dbRs.updateByte(columnName, x); 903 } 904 905 909 public void updateBytes(int columnIndex, byte[] x) throws SQLException { 910 dbRs.updateBytes(columnIndex, x); 911 } 912 913 917 public void updateBytes(String columnName, byte[] x) 918 throws SQLException { 919 dbRs.updateBytes(columnName, x); 920 } 921 922 926 public void updateCharacterStream(int columnIndex, Reader x, int length) 927 throws SQLException { 928 dbRs.updateCharacterStream(columnIndex, x, length); 929 } 930 931 935 public void updateCharacterStream(String columnNameIndex, Reader x, int length) 936 throws SQLException { 937 dbRs.updateCharacterStream(columnNameIndex, x, length); 938 } 939 940 944 public void updateClob(int columnIndex, Clob x) throws SQLException { 945 dbRs.updateClob(columnIndex, x); 946 } 947 948 952 public void updateClob(String columnName, Clob x) throws SQLException { 953 dbRs.updateClob(columnName, x); 954 } 955 956 960 public void updateDate(int columnIndex, java.sql.Date x) 961 throws SQLException { 962 dbRs.updateDate(columnIndex, x); 963 } 964 965 969 public void updateDate(String columnName, java.sql.Date x) 970 throws SQLException { 971 dbRs.updateDate(columnName, x); 972 } 973 974 978 public void updateDouble(int columnIndex, double x) throws SQLException { 979 dbRs.updateDouble(columnIndex, x); 980 } 981 982 986 public void updateDouble(String columnName, double x) 987 throws SQLException { 988 dbRs.updateDouble(columnName, x); 989 } 990 991 995 public void updateFloat(int columnIndex, float x) throws SQLException { 996 dbRs.updateFloat(columnIndex, x); 997 } 998 999 1003 public void updateFloat(String columnName, float x) throws SQLException { 1004 dbRs.updateFloat(columnName, x); 1005 } 1006 1007 1011 public void updateInt(int columnIndex, int x) throws SQLException { 1012 dbRs.updateInt(columnIndex, x); 1013 } 1014 1018 public void updateInt(String columnName, int x) throws SQLException { 1019 dbRs.updateInt(columnName, x); 1020 } 1021 1022 1026 public void updateLong(int columnIndex, long x) throws SQLException { 1027 dbRs.updateLong(columnIndex, x); 1028 } 1029 1030 1034 public void updateLong(String columnName, long x) throws SQLException { 1035 dbRs.updateLong(columnName, x); 1036 } 1037 1038 1042 public void updateNull(int columnIndex) throws SQLException { 1043 dbRs.updateNull(columnIndex); 1044 } 1045 1046 1050 public void updateNull(String columnName) throws SQLException { 1051 dbRs.updateNull(columnName); 1052 } 1053 1054 1058 public void updateObject(int columnIndex, Object x) 1059 throws SQLException { 1060 dbRs.updateObject(columnIndex, x); 1061 } 1062 1063 1067 public void updateObject(int columnIndex, Object x, int scale) 1068 throws SQLException { 1069 dbRs.updateObject(columnIndex, x, scale); 1070 } 1071 1072 1076 public void updateObject(String columnName, Object x) 1077 throws SQLException { 1078 dbRs.updateObject(columnName, x); 1079 } 1080 1081 1085 public void updateObject(String columnName, Object x, int scale) 1086 throws SQLException { 1087 dbRs.updateObject(columnName, x, scale); 1088 } 1089 1090 1094 public void updateRef(int columnIndex, Ref x) throws SQLException { 1095 dbRs.updateRef(columnIndex, x); 1096 } 1097 1098 1102 public void updateRef(String columnName, Ref x) throws SQLException { 1103 dbRs.updateRef(columnName, x); 1104 } 1105 1106 1110 public void updateRow() throws SQLException { 1111 dbRs.updateRow(); 1112 } 1113 1114 1118 public void updateShort(int columnIndex, short x) throws SQLException { 1119 dbRs.updateShort(columnIndex, x); 1120 } 1121 1122 1126 public void updateShort(String columnName, short x) throws SQLException { 1127 dbRs.updateShort(columnName, x); 1128 } 1129 1130 1134 public void updateString(int columnIndex, String x) throws SQLException { 1135 dbRs.updateString(columnIndex, x); 1136 } 1137 1138 1142 public void updateString(String columnName, String x) 1143 throws SQLException { 1144 dbRs.updateString(columnName, x); 1145 } 1146 1147 1151 public void updateTime(String columnName, java.sql.Time x) 1152 throws SQLException { 1153 dbRs.updateTime(columnName, x); 1154 } 1155 1156 1160 public void updateTime(int columnIndex, java.sql.Time x) 1161 throws SQLException { 1162 dbRs.updateTime(columnIndex, x); 1163 } 1164 1165 1169 public void updateTimestamp(int columnIndex, java.sql.Timestamp x) 1170 throws SQLException { 1171 dbRs.updateTimestamp(columnIndex, x); 1172 } 1173 1174 1178 public void updateTimestamp(String columnName, java.sql.Timestamp x) 1179 throws SQLException { 1180 dbRs.updateTimestamp(columnName, x); 1181 } 1182 1183 1187 public boolean wasNull() throws SQLException { 1188 return dbRs.wasNull(); 1189 } 1190} | Popular Tags |