Dbutils 使用实例

最新推荐文章于 2025-08-08 12:35:56 发布

aescoty

最新推荐文章于 2025-08-08 12:35:56 发布

阅读量473

点赞数

CC 4.0 BY-SA版权

文章标签： string jdbc sql oracle url email

本文链接：https://blog.youkuaiyun.com/aescoty/article/details/5312107

package com.lzg.dbutils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

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

public class MapListExample
{

    public static void main(String[] args)
    {
        String url = "jdbc:oracle:thin:@aescoty-pc:1521:orcl";
        String sql = "select *from guestbook ";
        DbUtils.loadDriver("oracle.jdbc.driver.Oracle");
        try
        {
            Connection conn = DriverManager.getConnection(url,"scott","a123");
            QueryRunner qr = new QueryRunner();
            List<?> results = (List<?>) qr.query(conn,sql,new MapListHandler());
            DbUtils.close(conn);
            for(int i = 0; i < results.size(); i++)
            {
                Map<?, ?> map = (Map<?, ?>)results.get(i);
                System.out.print(map.get("id")+"/t");
                System.out.print(map.get("name")+"/t");
                System.out.print(map.get("phone")+"/t");
                System.out.println(map.get("email")+"/t");

            }

        } catch (SQLException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

}