Java JDBC链接Oracle数据库
package com.test.test;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
/**
* 通过Java JDBC链接Oracle数据库
* @author Administrator
*
*/
public class OracleJdbcTest {
String driverClass = "oracle.jdbc.driver.OracleDriver";
Connection con;
public void init(FileInputStream fs) throws ClassNotFoundException,
SQLException, FileNotFoundException, IOException {
Properties props = new Properties();
props.load(fs);
String url = props.getProperty("db.url");
String userName = props.getProperty("db.user");
String password = props.getProperty("db.password");
Class.forName(driverClass);
con = DriverManager.getConnection(url, userName, password);
}
public void fetch() throws SQLException, IOException {
PreparedStatement ps = con.prepareStatement("select SYSDATE from dual");
ResultSet rs = ps.executeQuery();
while (rs.next()) {
// do the thing you do
}
rs.close();
ps.close();
}
public static void main(String[] args) throws ClassNotFoundException,
FileNotFoundException, SQLException, IOException {
OracleJdbcTest test = new OracleJdbcTest();
//配置文件路径
FileInputStream fs = null;
test.init(fs);
test.fetch();
}
}
最新文章
- Servlet入门
- Ubuntu 14.10 创建虚拟网卡实现桥接网络
- jpa datasource config
- ecshop网站搬家缓存无法更新
- nginx https ssl 设置受信任证书[原创]
- jquery------.cycle的使用
- 每日目标——HTML 头部标签学习 2015-8-27
- Problem A Where is the Marble?(查找排序)
- 消息中间件Client模块划分
- bzoj3129[Sdoi2013]方程 exlucas+容斥原理
- 谈谈git以及如何关联github
- go-001[常用命令]
- 【原创】空中鼠标一DMP欧拉角
- win10 安装 oracle 11g
- 惊艳,Dubbo域名已改,也不再局限于Java!
- 点击li ,父辈出现; 子级,子辈不出现. prevUntil --->; 前面多个, 截止到 截止元素 , prev([expr]) -->; 前面一个.
- NOIP2018考前抱佛脚——图论基础复习
- mongodb常用查询
- 8 -- 深入使用Spring -- 3...1 Resource实现类FileSystemResource
- UVa 10375 选择与除法(唯一分解定理)
热门文章
- Umbraco -- 在Visual Studio中新建一个View 如何在Umbraco back office 中显示出来
- Ubuntu12.04更新出现 The system is running in low-graphics mode解决方法
- ASP.NET MVC 小牛之旅1:何谓MVC
- enter键触发事件的清除
- docker17.09.1-ce 执行systemctl resart docker重启失败的问题
- unity 3d 之合并网格和贴图(combine mesh and texture)
- bzoj3876: [Ahoi2014&;Jsoi2014]支线剧情(上下界费用流)
- Error: Attribute application@allowBackup value=(false) from AndroidManifest.xml:14:7-34 is also present at [:react-native-qq] AndroidManifest.xml:14:18-44 value=(true).
- 017 Letter Combinations of a Phone Number 电话号码的字母组合
- C	A Simple Job