欢迎来到天天文库
浏览记录
ID:59307719
大小:41.00 KB
页数:7页
时间:2020-09-05
《DbUtils入门实例知识分享.doc》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、Dbutis1.package cn.lining.test; 2. 3.import java.sql.Connection; 4.import java.sql.DriverManager; 5.import java.sql.SQLException; 6.import java.util.List; 7.import java.util.Map; 8. 9.import org.apache.commons.dbutils.DbUtils; 10.import org.apache.commons.dbutils.Quer
2、yRunner; 11.import org.apache.commons.dbutils.handlers.ArrayHandler; 12.import org.apache.commons.dbutils.handlers.ArrayListHandler; 13.import org.apache.commons.dbutils.handlers.BeanHandler; 14.import org.apache.commons.dbutils.handlers.BeanListHandler; 15.import org.apa
3、che.commons.dbutils.handlers.ColumnListHandler; 16.import org.apache.commons.dbutils.handlers.KeyedHandler; 17.import org.apache.commons.dbutils.handlers.MapHandler; 18.import org.apache.commons.dbutils.handlers.MapListHandler; 19.import org.apache.commons.dbutils.handlers
4、.ScalarHandler; 20. 21.public class test { 22. @SuppressWarnings("unchecked") 23. public static void main(String[] args) throws ClassNotFoundException { 24. 25. UserField userField = new UserField(); 26. 27. Connection conn = null; 28. String jdbcURL = "jdbc:mysql:
5、//localhost:3306/macaw4"; 29. String jdbcDriver = "com.mysql.jdbc.Driver"; 30. try { 31. DbUtils.loadDriver(jdbcDriver); 32. conn = DriverManager.getConnection(jdbcURL, "root", "root"); 33. conn.setAutoCommit(false);//关闭自动提交 34. QueryRunner qRunner = new QueryR
6、unner(); 1. 2. // 以下部分代码采用MapHandler存储方式查询 3. System.out.println("***Using MapHandler***"); 4. Map map = (Map) qRunner.query(conn, 5. "select * from mc_user_field where id = ?", 6. new MapHandler(), new Object[] { "5" }); 7. 8. System.out.println("id --
7、----------- name "); 9. System.out.println(map.get("id") + " ------------- " 10. + map.get("name")); 11. 12. // 以下部分代码采用MapListHandler存储方式查询 13. System.out.println("***Using MapListHandler***"); 14. List lMap = (List) qRunner.query(conn, 15. "select * f
8、rom mc_user_field", new MapListHandler()); 16. 17. System
此文档下载收益归作者所有