/** * Value by page number (starting from Current_page page, page_size per page) * @param key * @param params * @param current_page * @param page_size * @retur n */public <T> pagination getpaginationbypage (String key, Object params,int current_page,int page_size) {int count< c0/>= ( Integer) getsqlsession (). SelectOne (key+ "_count", params); list<object> list = getsqlsession (). SelectList (Key, Params,new rowbounds ((current_page-1) * page_size , page_size)); pagination pagination = new pagination ();p agination.paging (Current_page, Page_size, Count);p agination.setlist ( list); return pagination; }
Java.sql.SQLException frequently occurs when paging queries are executed: The stream has been closed.
The table field in the Oracle Library in an isolated project uses a long type instead of number, changing the number to the normal amount.
The ResultSet interface provides a GET method for getting column values from the current row (Getboolean, Getlong, and so on). You can use the index number of a column or the name of a column to get a value.
In general, the use of column indexes is more efficient. The column is numbered starting at 1. For maximum portability, the result set columns in each row should be read in left-to-right order, and each column can be read only once.
MyBatis Oracle Java.sql.SQLException: Stream has been turned off issue