beanutilsexample4.java

来自「用java编写的程序」· Java 代码 · 共 45 行

package webbook.beanutils.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import org.apache.commons.beanutils.DynaBean;
import org.apache.commons.beanutils.RowSetDynaClass;

public class BeanUtilsExample4 {
	public static void main(String args[]) throws Exception {
		Connection conn = getConnection();
		PreparedStatement ps = conn.prepareStatement("select id,title,time from guestbook order by id desc");
		ResultSet rs = ps.executeQuery();

		RowSetDynaClass rsdc = new RowSetDynaClass(rs);
		conn.close();
		Iterator itr = rsdc.getRows().iterator();
		while (itr.hasNext()) {
			DynaBean bean = (DynaBean) itr.next();
			System.out.print(bean.get("id") + "\t");
			System.out.print(bean.get("title") + "\t");
			System.out.println(bean.get("time"));
		}
	}

	private static Connection getConnection() {
		String url = "jdbc:oracle:thin:@192.168.1.20:1521:ora9";
		String username = "scott";
		String password = "tiger";
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection(url, username, password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
}