Apache组件commons的DbUtils的用法实例

最新推荐文章于 2025-02-27 16:12:12 发布

原创最新推荐文章于 2025-02-27 16:12:12 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

Apache-Commons 专栏收录该内容

17 篇文章

订阅专栏

本文通过实际案例对比分析了使用Apache Commons DbUtils库进行数据库连接操作的效率与便捷性，指出其在某些场景下可能不如直接编写代码灵活且易用。详细介绍了如何使用DbUtils库进行查询和更新操作，并提供了获取连接实例的具体步骤。

1 代码要连接数据库是可以跑通的，可是本人真心表示这个封装的太垃圾，远不及自己写的顺手，不建议再学一套db连接的方法，这个感觉写的还有点复杂，不好用，不推荐

package com.commons.dbutils;

import java.util.*;
import java.util.logging.*;
import java.sql.*;
import org.apache.commons.dbutils.*;
import org.apache.commons.dbutils.handlers.*;

public class DbUtilsTest {

	public static void main(String[] args) throws Exception {
		DbUtilsTest test = new DbUtilsTest();

		for (int i = 0; i < 1; i++) {
			test.testQuery1();
			test.testQuery2();
			test.testUpdate();
		}
	}

	public void testQuery1() {
		try {
			QueryRunner qr = new QueryRunner();
			ResultSetHandler rsh = new ArrayListHandler();
			String strsql = "select * from test1";
			ArrayList result = (ArrayList) qr.query(getConnection(), strsql,
					rsh);
			// System.out.print("");
		} catch (Exception ex) {
			ex.printStackTrace(System.out);
		}
	}

	public void testQuery2() {
		try {
			QueryRunner qr = new QueryRunner();
			ResultSetHandler rsh = new MapListHandler();
			String strsql = "select * from test1";
			ArrayList result = (ArrayList) qr.query(getConnection(), strsql,
					rsh);
			for (int i = 0; i < result.size(); i++) {
				Map map = (Map) result.get(i);
				// System.out.println(map);
			}
			// System.out.print("");
		} catch (Exception ex) {
			ex.printStackTrace(System.out);
		}
	}

	public void testUpdate() {
		try {
			QueryRunner qr = new QueryRunner();
			ResultSetHandler rsh = new ArrayListHandler();
			String strsql = "insert test1(page ,writable ,content)values('ttt','ttt','faskldfjklasdjklfjasdklj')";
			qr.update(getConnection(), strsql);
			// System.out.print("");
		} catch (Exception ex) {
			ex.printStackTrace(System.out);
		}
	}

	private Connection getConnection() throws InstantiationException,
			IllegalAccessException, ClassNotFoundException, SQLException {

		String strDriver = "com.mysql.jdbc.Driver";
		String strUrl = "jdbc:mysql://localhost:3306/test";
		String strUser = "root";
		String strPass = "root";

		Class.forName(strDriver).newInstance();
		return DriverManager.getConnection(strUrl, strUser, strPass);
	}
}