dbutil 的使用方法
来源:互联网 发布:java二分递归 编辑:程序博客网 时间:2024/06/01 16:46
public static void main(String[] args) {
TestHandler t = new TestHandler();
try {
t.test9();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void test1() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
List<Product> list = qr.query(sql, new BeanListHandler<>(Product.class));
for (Product product : list) {
System.out.println(product.getName());
}
}
//适合取一条数据
public void test2() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Object[] query = qr.query(sql, new ArrayHandler());
List<Object[]> query2 = qr.query(sql, new ArrayListHandler());
}
//取一条数据变为实体类对象
public void test3() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Product query = qr.query(sql, new BeanHandler<>(Product.class));
}
//取一列数据
public void test4() throws SQLException {
String sql = "select * from product ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
List<Object> query = qr.query(sql, new ColumnListHandler<>(1));
for (Object object : query) {
System.out.println(object);
}
}
//取多条数据,每一条数据是小map,把小map放到大map中
//key是你指定的字段值
//大map的key是某列数列,小map的key是表的列名
public void test5() throws SQLException {
String sql = "select * from product ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Map<Object, Map<String, Object>> query = qr.query(sql, new KeyedHandler<>(2));
for(Map.Entry<Object, Map<String, Object>> m : query.entrySet()) {
for(Map.Entry<String, Object> mm : m.getValue().entrySet()) {
System.out.println(mm.getKey()+"\t"+mm.getValue());
}
}
}
//update
public void test6() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "insert into product values(12,'电视21',10,100) ";
int row = qr.update(sql);
}
public void test7() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "update product set name = ? where id = ?";
int row = qr.update(sql,"你好",12);
}
public void test8() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "delete from product where id = ? ";
int row = qr.update(sql,12);
}
public void test9()throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql ="select count(*) from product";
Object query = qr.query(sql,new ScalarHandler<>());
Integer count = Integer.valueOf(query.toString());
System.out.println(count);
}
TestHandler t = new TestHandler();
try {
t.test9();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void test1() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
List<Product> list = qr.query(sql, new BeanListHandler<>(Product.class));
for (Product product : list) {
System.out.println(product.getName());
}
}
//适合取一条数据
public void test2() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Object[] query = qr.query(sql, new ArrayHandler());
List<Object[]> query2 = qr.query(sql, new ArrayListHandler());
}
//取一条数据变为实体类对象
public void test3() throws SQLException {
String sql = "select * from product where id = ? and count = ? ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Product query = qr.query(sql, new BeanHandler<>(Product.class));
}
//取一列数据
public void test4() throws SQLException {
String sql = "select * from product ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
List<Object> query = qr.query(sql, new ColumnListHandler<>(1));
for (Object object : query) {
System.out.println(object);
}
}
//取多条数据,每一条数据是小map,把小map放到大map中
//key是你指定的字段值
//大map的key是某列数列,小map的key是表的列名
public void test5() throws SQLException {
String sql = "select * from product ";
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
Map<Object, Map<String, Object>> query = qr.query(sql, new KeyedHandler<>(2));
for(Map.Entry<Object, Map<String, Object>> m : query.entrySet()) {
for(Map.Entry<String, Object> mm : m.getValue().entrySet()) {
System.out.println(mm.getKey()+"\t"+mm.getValue());
}
}
}
//update
public void test6() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "insert into product values(12,'电视21',10,100) ";
int row = qr.update(sql);
}
public void test7() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "update product set name = ? where id = ?";
int row = qr.update(sql,"你好",12);
}
public void test8() throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql = "delete from product where id = ? ";
int row = qr.update(sql,12);
}
public void test9()throws SQLException {
QueryRunner qr = new QueryRunner(C3P0Util.getCpds());
String sql ="select count(*) from product";
Object query = qr.query(sql,new ScalarHandler<>());
Integer count = Integer.valueOf(query.toString());
System.out.println(count);
}
阅读全文
0 0
- DbUtil的使用方法
- dbutil 的使用方法
- DButil的介绍以及基础使用方法
- DBUtil的简单封装(dbutil+tomcat jdbcpool)
- Apache的dbutil 测试
- dbUtil的简单使用
- DBUtil的使用
- DbUtil工具的使用
- 有关dbutil的方面
- DBUtil
- DBUtil
- DBUtil
- Dbutil
- DBUtil
- DBUtil
- DBUtil
- DBUtil
- DBUtil
- HDU 1305:Immediate Decodability
- 使用Maven私服的好处
- 如何在交互式shell脚本中创建对话框
- Unreal教学(4)——组件和碰撞(Components and Collision)
- 禅道布署
- dbutil 的使用方法
- 【Linux】进程控制—exec函数族
- 记录QT的学习过程!
- Android LiveData简介(一)
- 阿里云营销引擎构建DSP/DMP系统
- 用JS锁定页面滚动条
- 基于队列的拓扑排序
- Java Mysql连接池配置和案例分析--超时异常和处理
- HTTP 2 TCP/IP