dbutils例子

最新推荐文章于 2023-11-16 15:40:55 发布

kongxx

最新推荐文章于 2023-11-16 15:40:55 发布

阅读量7.3k

点赞数

分类专栏： Java 文章标签： exception string import insert jdbc mysql

本文链接：https://blog.youkuaiyun.com/kongxx/article/details/24925

版权

Java 专栏收录该内容

179 篇文章

订阅专栏

此博客展示了Java使用dbutils 1.0版本操作MySQL数据库的代码示例。包含导入相关包，定义TestDBUnits类，在main方法中调用查询和更新方法，如testQuery1、testQuery2和testUpdate，还给出了获取数据库连接的方法。

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

//使用dbutils1.0版本

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

public class TestDBUnits {

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

  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 = "org.gjt.mm.mysql.Driver";
  String strUrl = "jdbc:mysql://localhost:3306/test";
  String strUser = "root";
  String strPass = "";

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