1. Kategorie Pagination
Die Codekopie lautet wie folgt:
Paket org.zh.basic;
/**
* Seitenklasse
*
* @Author Keven
*
*/
public class pageinfo {
// Definition
private String p_tableName;
private Zeichenfolge p_strwhere;
private String p_orderColumn;
private String p_orderSyle;
private int p_curpage;
private int p_pageSize;
private int p_totalrecords;
private int p_totalpages;
// / <summary>
// / Funktionen definieren
/// </ summary>
public pageinfo () {
}
public pageInfo (String p_tableName, String p_strwhere,
String p_orderColumn, String p_orderSyle, int p_curpage,
int p_pageSize, int p_totalrecords, int p_totalpages) {
this.p_tableName = p_tableName;
this.p_strwhere = p_strwhere;
this.p_orderColumn = p_orderColumn;
this.p_orderSyle = p_orderSyle;
this.p_curpage = p_curpage;
this.p_pageSize = p_pageSize;
this.p_totalRecords = p_totalRecords;
this.p_totalpages = p_totalpages;
}
public String getp_tableName () {
return p_tableName;
}
public void setp_tableName (String ptableName) {
p_tableName = ptableName;
}
public String getp_strwhere () {
return p_strwhere;
}
public void setp_strwhere (String pstrwhere) {
p_strwhere = pstrwhere;
}
public String getp_orderColumn () {
return p_orderColumn;
}
public void setp_orderColumn (String pordercolumn) {
p_orderColumn = pordercolumn;
}
public String getp_orderSyle () {
return p_ordersyle;
}
public void setp_orderSyle (String porderSyle) {
P_OrderSyle = PorderSyle;
}
public int getp_curpage () {
return p_curpage;
}
public void setp_curpage (int pcurpage) {
p_curpage = pcurpage;
}
public int getp_pagesize () {
return p_pageSize;
}
public void setp_pageSize (int ppageSize) {
p_pageSize = ppageSize;
}
public int getp_totalrecords () {
return p_totalrecords;
}
public void setp_totalrecords (int ptotalrecords) {
p_totalRecords = ptotalrecords;
}
public int getp_totalpages () {
return p_totalpages;
}
public void setp_totalpages (int ptotalpages) {
p_totalpages = ptotalpages;
}
}
2 Rufen Sie an
Die Codekopie lautet wie folgt:
Paket org.zh.sys.server;
importieren java.sql.callablestatement;
Import Java.sql.Connection;
importieren java.sql.resultset;
importieren java.sql.resultsetmetadata;
importieren java.sql.sqlexception;
Import Java.util.ArrayList;
import Java.util.map;
import Java.util.hashMap;
import org.hibernate.session;
import org.zh.basic.pageInfo;
import org.zh.dao.hiberNateSessionFactory;
import oracle.jdbc.driver.oracletypes;
importieren oracle.jdbc.oraclecallablestatement;
öffentliche Klasse GeneratePage {
public generatePage () {
}
public static ArrayList PRC_PAGE (PageInfo -Seite) {
ArrayList List = new ArrayList ();
Karte MP;
Sitzung S = NULL;
Verbindung conn = null;
ResultSet rs = null;
CallABlestatement Proc = NULL;
versuchen {
s = hibernateSessionFactory.getSession ();
conn = S.Connection ();
proc = conn.preparecall ("{call pages.prc_page (?,?,?,?,?,?,?,?,?,?)}");
Proc.SetString (1, page.getP_tableName ());
Proc.SetString (2, page.getP_strwhere ());
Proc.SetString (3, page.getP_orderColumn ());
Proc.SetString (4, page.getP_OrderSyle ());
proc.setint (5, page.getP_curpage ());
proc.setint (6, page.getP_pageSize ());
proc.registerOutParameter (7, oracletypes.number);
proc.registerOutParameter (8, oracletypes.number);
proc.registerOutParameter (9, oracletypes.cursor);
proc.execute ();
// page.setp_totalrecords (proc.getint ("p_totalrecords"));
// page.setp_totalpages (proc.getint ("p_totalpages"));
// list = (ArrayList) proc.getObject ("v_cur");
page.setp_totalrecords (proc.getint (7));
page.setp_totalpages (proc.getint (8));
RS = (ORACLECALLABLESTATEMENT) proc) .getCursor (9);
ResultsetMetadata rsmd = rs.getmetadata ();
int nummerOfcolumns = rsmd.getColumnCount ();
while (rs.Next ()) {
MP = neuer HashMap (numberofcolumns);
für (int r = 1; r <numberofcolumns; r ++) {
mp.put (rsmd.getColumnname (r), rs.getObject (r));
}
list.add (MP);
}
Rückgabeliste;
} catch (SQLEXception ex) {
ex.printstacktrace ();
Rückgabeliste;
} catch (Ausnahme ex2) {
ex2.printstacktrace ();
Rückgabeliste;
} Endlich {
versuchen {
if (proc! = null) {
proc.close ();
}
if (rs! = null) {
rs.close ();
}
if (conn! = null) {
conn.close ();
}
} catch (sqlexception ex1) {
ex1.printstacktrace ();
}
}
}
}