beanlistexample.java

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

package webbook.chapter5;

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

public class BeanListExample {
	public static void main(String[] args) {
		Connection conn = null;
		String url = "jdbc:oracle:thin:@192.168.1.20:1521:ora9";
		String jdbcDriver = "oracle.jdbc.driver.OracleDriver";
		String user = "scott";
		String password = "tiger";

		DbUtils.loadDriver(jdbcDriver);
		try {
			conn = DriverManager.getConnection(url, user, password);
			QueryRunner qr = new QueryRunner();
			List results = (List) qr.query(conn, "select id,name from guestbook", new BeanListHandler(Guestbook.class));
			for (int i = 0; i < results.size(); i++) {
				Guestbook gb = (Guestbook) results.get(i);
				System.out.println("id:" + gb.getId() + ",name:" + gb.getName());
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DbUtils.closeQuietly(conn);
		}
	}
}