📄 pageableresultset.java
字号:
int allrow=rs.getRow();
rs.beforeFirst();
return allrow;
}
public short getShort(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return 0;
}
public short getShort(String columnName) throws SQLException {
// TODO Auto-generated method stub
return 0;
}
public Statement getStatement() throws SQLException {
// TODO Auto-generated method stub
return null;
}
public String getString(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return rs.getString(columnIndex);
}
public Time getTime(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Time getTime(String columnName) throws SQLException {
// TODO Auto-generated method stub
return rs.getTime(columnName);
}
public Time getTime(int columnIndex, Calendar cal) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Time getTime(String columnName, Calendar cal) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Timestamp getTimestamp(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Timestamp getTimestamp(String columnName) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public int getType() throws SQLException {
// TODO Auto-generated method stub
return 0;
}
public URL getURL(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public URL getURL(String columnName) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public InputStream getUnicodeStream(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public InputStream getUnicodeStream(String columnName) throws SQLException {
// TODO Auto-generated method stub
return null;
}
public SQLWarning getWarnings() throws SQLException {
// TODO Auto-generated method stub
return null;
}
public void insertRow() throws SQLException {
// TODO Auto-generated method stub
}
public boolean isAfterLast() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean isBeforeFirst() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean isFirst() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean isLast() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean last() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public void moveToCurrentRow() throws SQLException {
// TODO Auto-generated method stub
}
public void moveToInsertRow() throws SQLException {
// TODO Auto-generated method stub
}
public boolean previous() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public void refreshRow() throws SQLException {
// TODO Auto-generated method stub
}
public boolean relative(int rows) throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean rowDeleted() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean rowInserted() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public boolean rowUpdated() throws SQLException {
// TODO Auto-generated method stub
return false;
}
public void setFetchDirection(int direction) throws SQLException {
// TODO Auto-generated method stub
}
public void setFetchSize(int rows) throws SQLException {
// TODO Auto-generated method stub
}
public void updateArray(int columnIndex, Array x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateArray(String columnName, Array x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBlob(int columnIndex, Blob x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBlob(String columnName, Blob x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBoolean(int columnIndex, boolean x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBoolean(String columnName, boolean x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateByte(int columnIndex, byte x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateByte(String columnName, byte x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBytes(int columnIndex, byte[] x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateBytes(String columnName, byte[] x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException {
// TODO Auto-generated method stub
}
public void updateClob(int columnIndex, Clob x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateClob(String columnName, Clob x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateDate(int columnIndex, Date x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateDate(String columnName, Date x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateDouble(int columnIndex, double x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateDouble(String columnName, double x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateFloat(int columnIndex, float x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateFloat(String columnName, float x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateInt(int columnIndex, int x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateInt(String columnName, int x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateLong(int columnIndex, long x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateLong(String columnName, long x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateNull(int columnIndex) throws SQLException {
// TODO Auto-generated method stub
}
public void updateNull(String columnName) throws SQLException {
// TODO Auto-generated method stub
}
public void updateObject(int columnIndex, Object x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateObject(String columnName, Object x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateObject(int columnIndex, Object x, int scale) throws SQLException {
// TODO Auto-generated method stub
}
public void updateObject(String columnName, Object x, int scale) throws SQLException {
// TODO Auto-generated method stub
}
public void updateRef(int columnIndex, Ref x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateRef(String columnName, Ref x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateRow() throws SQLException {
// TODO Auto-generated method stub
}
public void updateShort(int columnIndex, short x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateShort(String columnName, short x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateString(int columnIndex, String x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateString(String columnName, String x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateTime(int columnIndex, Time x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateTime(String columnName, Time x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException {
// TODO Auto-generated method stub
}
public void updateTimestamp(String columnName, Timestamp x) throws SQLException {
// TODO Auto-generated method stub
}
public boolean wasNull() throws SQLException {
// TODO Auto-generated method stub
return false;
}
}
/* 这里只是简单的取得一个总记录数,并将记录游标移回初始位置(before first),同时将参数中的ResultSet赋给成员变量。
这里只是简单的取得一个总记录数,并将记录游标移回初始位置(before first),同时将参数中的ResultSet赋给成员变量。
Pageable的使用方法
因为Pageable接口继承自ResultSet,所以在使用方法上与ResultSet一致,尤其是在不需要分页功能的时候,可以直接当成ResultSet使用。而在需要分页时,只需要简单的setPageSize, gotoPage,即可*/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -