Apache的commons组件的dbutils包关于封装数据库处理的实例【这个稍微有用】

最新推荐文章于 2022-02-06 09:30:00 发布

原创最新推荐文章于 2022-02-06 09:30:00 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

Apache-Commons 专栏收录该内容

17 篇文章

订阅专栏

本文介绍如何利用dbutils包进行数据库查询和更新操作，包括使用不同类型的ResultSetHandler处理查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.commons.components.dbutils;

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

/**
 * 使用dbutils包类进行数据查询，更改。
 * @author chaigw
 *
 */
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 sc";
			ArrayList result = (ArrayList) qr.query(getConnection(), strsql,
					rsh);
		} catch (Exception ex) {
			ex.printStackTrace(System.out);
		}
	}

	public void testQuery2() {
		try {
			QueryRunner qr = new QueryRunner();
			ResultSetHandler rsh = new MapListHandler();
			String strsql = "select * from sc";
			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 into student (name) values('"+"www"+"')";
			qr.update(getConnection(), strsql);
		} 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/exam";
		String strUser = "root";
		String strPass = "root";

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

{id=2, sid=1, grade=22.0, cid=3}
{id=5, sid=3, grade=64.0, cid=1}
{id=8, sid=3, grade=84.88, cid=5}
{id=9, sid=4, grade=87.88, cid=5}
{id=11, sid=4, grade=16.88, cid=3}
{id=12, sid=4, grade=38.0, cid=1}