maplistexample.java

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

package webbook.chapter5;

import org.apache.commons.dbutils.DbUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapListHandler;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.util.List;
import java.util.Map;

public class MapListExample {
	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 MapListHandler());

			for (int i = 0; i < results.size(); i++) {
				Map map = (Map) results.get(i);
				System.out.println("id:" + map.get("id") + ",name:" + map.get("name"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DbUtils.closeQuietly(conn);
		}
	}
}