用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字
云代码 - java代码库

通过Java JDBC链接Oracle数据库

2015-05-13 作者: xiedong1112举报

[java]代码库

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)  
{  
 
 
OracleJdbcTest test = new
 
OracleJdbcTest();  
test.init();  
test.fetch
 
();  
}  
 
 
 
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)
{
OracleJdbcTest test = new OracleJdbcTest
 
();
test.init();
test.fetch();
}
}


网友评论    (发表评论)


发表评论:

评论须知:

  • 1、评论每次加2分,每天上限为30;
  • 2、请文明用语,共同创建干净的技术交流环境;
  • 3、若被发现提交非法信息,评论将会被删除,并且给予扣分处理,严重者给予封号处理;
  • 4、请勿发布广告信息或其他无关评论,否则将会删除评论并扣分,严重者给予封号处理。


扫码下载

加载中,请稍后...

输入口令后可复制整站源码

加载中,请稍后...