这篇文章主要介绍了jdbc.utils QueryRunner的建档使用示例,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。package com.jdbc.test
这篇文章主要介绍了jdbc.utils QueryRunner的建档使用示例,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。
package com.jdbc.test;import java.sql.*;import java.util.List;import org.apache.commons.dbutils.QueryRunner;import org.apache.commons.dbutils.ResultSetHandler;import org.apache.commons.dbutils.handlers.BeanHandler;import org.apache.commons.dbutils.handlers.BeanListHandler;public class OdbcTest {@SuppressWarnings({ "unchecked", "rawtypes" })public static void main(String[] args) {Connection conn =null;try {Class.forName("oracle.jdbc.driver.OracleDriver");conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.249.137:1521:hgs","hgs","hgs"); //DriverManager.getConnection("jdbc:oracle:thin:@192.168.249.137:1521:hgs","hgs","hgs");//Class.forName("oracle.jdbc.driver.OracleDriver");//Connection connection = null;//connection = DriverManager.getConnection("jdbc:oracle:thin:@192.168.249.137:1521:hgs","hgs","hgs");} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}QueryRunner qr = new QueryRunner();////////////////////查询try {List<Animals> ai = qr.query(conn, "select atype,averageage from animals",new BeanListHandler<Animals>(Animals.class)); for(Animals a : ai){ System.out.println("atype: "+a.getAtype() +" avgage: "+a.getAverageage()); }} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}////////////////////////////////////插入try {Object[] params= {"man",78};//qr.insert(conn, "insert into animals(atype,averageage) values(?,?)", new BeanHandler<Animals>(Animals.class), params);qr.update(conn, "insert into animals(atype,averageage) values(?,?)", params);} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}///删除try {Object[] params= {"man",78};//qr.insert(conn, "insert into animals(atype,averageage) values(?,?)", new BeanHandler<Animals>(Animals.class), params);qr.update(conn, "delete from animals");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} }}
感谢你能够认真阅读完这篇文章,希望小编分享的“jdbc.utils QueryRunner的建档使用示例”这篇文章对大家有帮助,同时也希望大家多多支持编程网,关注编程网精选频道,更多相关知识等着你来学习!
--结束END--
本文标题: jdbc.utils QueryRunner的建档使用示例
本文链接: https://www.lsjlt.com/news/231586.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0