dbutils入门

DButils隶属于apache commons，对于一些基本的jdbc操作进行了封装，比之orm要小巧不小，当然功能上弱化很多。

简单demo看看dbutils使用（增删改查）：

 

public class DB {
	private String dirverClassName = "com.mysql.jdbc.Driver";
	private String url = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8";
	private String user = "root";
	private String password = "admin";
	static Connection conn = null;
	QueryRunner runner = null;

	private void getConnection() {
		try {
			Class.forName(dirverClassName);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		try {
			conn = DriverManager.getConnection(url, user, password);
			runner = new QueryRunner();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	private void insert() throws SQLException {
		int n = runner.update(conn, "insert into aaa(term) values('你大爷')");
		System.out.println("插入" + n + "条数据！");
	}

	private void find() throws SQLException {
		List<Word> list = (List<Word>) runner.query(conn,
				"select id,term from aaa", new BeanListHandler(Word.class));
		for (Word user : list) {
			System.out.println(user);
		}
	}

	private void delete() throws Exception {
		runner.update(conn, "delete from aaa where id = ?", 10);
	}

	public void test() throws Exception {
		getConnection();
		// insert();
		find();
		DbUtils.closeQuietly(conn);
	}

	public static void main(String[] args) throws Exception {
		DB db = new DB();
		db.test();
	}
}

  

 

 

 

aaa表结构：

 

DROP TABLE IF EXISTS `test`.`aaa`;
CREATE TABLE  `test`.`aaa` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `term` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

  

 

除dbutils.jar外还需要mysql-java的驱动包。