1. Kategori pagination
Salinan kode adalah sebagai berikut:
paket org.zh.basic;
/**
* Kelas halaman
*
* @Author Keven
*
*/
PageInfo kelas publik {
// definisi
Private String p_tableName; // -table nama
Private String p_strwhere; // -Kondisi Query
Private String P_ORDERCOLUMN;
Private String P_ORDERSTYLE; // -Metode Sorting
private int p_curpage; // -halaman arus
Private int p_pagesize; // -jumlah catatan yang ditampilkan per halaman
private int p_totalrecords; // -catatan total
Private Int P_TotalPages; // -Total Halaman
// / <summary>
// / tentukan fungsi
/// </summary>
pageInfo publik () {
}
pageInfo publik (string p_tablename, string p_strwhere,
String p_orderColumn, string p_orderstyle, 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_orderstyle = p_orderstyle;
this.p_curpage = p_curpage;
this.p_pagesize = p_pagesize;
this.p_totalrecords = p_totalrecords;
this.p_totalpages = p_totalpages;
}
string publik getp_tableName () {
return p_tableName;
}
public void setp_tableName (string pTableName) {
p_tablename = ptableName;
}
string publik getp_strwhere () {
kembalikan p_strwhere;
}
public void setp_strwhere (string pStrwhere) {
p_strwhere = pStr where;
}
string publik getp_ordercolumn () {
return p_orderColumn;
}
public void setp_orderColumn (String porderColumn) {
p_orderColumn = porderColumn;
}
string publik getp_orderstyle () {
return p_orderstyle;
}
public void setp_orderstyle (string porderstyle) {
p_orderstyle = porderstyle;
}
publik int getp_curpage () {
return p_curpage;
}
public void setp_curpage (int pcurpage) {
p_curpage = pcurpage;
}
publik int getp_pagesize () {
return p_pagesize;
}
public void setp_pagesize (int ppageSize) {
p_pagesize = pPageSize;
}
publik 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 Panggilan
Salinan kode adalah sebagai berikut:
paket org.zh.sys.server;
impor java.sql.callablestatement;
impor java.sql.connection;
impor java.sql.Resultset;
impor java.sql.resultsetMetadata;
impor java.sql.sqlexception;
impor java.util.arraylist;
impor java.util.map;
impor java.util.hashmap;
impor org.hibernate.Session;
impor org.zh.basic.pageInfo;
impor org.zh.dao.hibernatessiessionFactory;
impor oracle.jdbc.driver.oracletypes;
impor oracle.jdbc.oraclecallablestatement;
Kelas Publik GeneratePage {
GeneratEpage publik () {
}
Public Static ArrayList PRC_PAGE (PageInfo Page) {
Daftar ArrayList = ArrayList baru ();
Peta MP;
Sesi s = null;
Koneksi conn = null;
Hasil rs = null;
Callablestatement proc = null;
mencoba {
S = HibernatesessionFactory.getSession ();
Conn = s.connection ();
proc = conn.prepareCall ("{call halaman.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_orderstyle ());
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);
Hasil rmd rsmd = rs.getmetadata ();
int numberofcolumns = rsmd.getColumnCount ();
while (rs.next ()) {
MP = HashMap baru (NumberOfColumns);
untuk (int r = 1; r <numberofcolumns; r ++) {
mp.put (rsmd.getColumnName (r), rs.getObject (r));
}
list.add (MP);
}
daftar pengembalian;
} catch (sqlexception ex) {
Ex.PrintStackTrace ();
daftar pengembalian;
} catch (Exception ex2) {
ex2.printstacktrace ();
daftar pengembalian;
} Akhirnya {
mencoba {
if (proc! = null) {
proc.close ();
}
if (rs! = null) {
rs.close ();
}
if (conn! = null) {
conn.close ();
}
} catch (sqlexception ex1) {
EX1.PrintStackTrace ();
}
}
}
}