resultset转换为JavaBean代码.doc

广州java培训 package com.a.e; import java.lang.reflect.Method; import java.lang.reflect.Modifier; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Collection; import java.util.Date; import java.util.Iterator; import javax.swing.JApplet; public class hf { public static void main(String[] args) { String driver = oracle.jdbc.driver.OracleDriver; String strUrl = jdbc:oracle:thin:@5:1521:XINLIORA; Statement stmt = null; ResultSet rs = null; Connection conn = null; try { Class.forName(driver); conn = DriverManager.getConnection(strUrl, info, 123456); CallableStatement proc = null; // proc = conn // .prepareCall({ call p_page.pagerecordscount(?,?) }); // proc.setString(1, t_information); // proc.registerOutParameter(2, oracle.jdbc.OracleTypes.NUMBER); // proc.execute(); // Long countLong = proc.getLong(2); // System.out.println(countLong); /** * Pindex in number, --分页索引 第几页 以0开始为第一页 Psize in number, --页面大小 * 1页显示多少行 Psql in varchar2, --产生dataset的sql语句 查询1页数据的sql * allCountsql in varchar2, --查询总行数的语句 allCount out number, --总行数 * Pcount out number, --返回分页总数 v_cur2 out type_cur2 --返回当前页数据记录 */ proc = conn .prepareCall({ call p_page2.pagination2(?,?,?,?,?,?,?)}); proc.setString(1, 2); proc.setString(2, 5); proc.setString(3, select * from (select a.*,rownum row_num from + (select * from t_information t where adduserid=1 + order by t.inserttime desc ) a) ); proc.setString(4, t_information t where adduserid=1); proc.registerOutParameter(5, oracle.jdbc.OracleTypes.NUMBER); proc.registerOutParameter(6, oracle.jdbc.OracleTypes.NUMBER); proc.registerOutParameter(7, oracle.jdbc.OracleTypes.CURSOR); proc.execute(); Long rowCount = proc.