Oracle 11c下载 及连接到OracleDB的简单程序
2024-09-01 13:22:15
https://pan.baidu.com/s/1ZCFLUi4Ti_WUYOFR3gB2dA 是11g版本下载包,下载下来解压就能用了。
安装完毕后,驱动包在【oralcehome】\product\11.2.0\dbhome_1\jdbc\lib下。
访问Oracle的JDBC程序,建表请见 https://www.cnblogs.com/xiandedanteng/p/11691113.html
package com.hy; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.MessageFormat; public class OracleConnector { // 连接到数据库的四大属性 private static final String DRIVER = "oracle.jdbc.driver.OracleDriver"; private static final String DBURL = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; private static final String USER = "system"; private static final String PSWD = "Ufo12345678"; public static void testConnToDB() { Connection conn = null; Statement stmt = null; try{ Class.forName(DRIVER).newInstance(); conn = DriverManager.getConnection(DBURL, USER, PSWD); stmt = conn.createStatement(); String sql = "select id,name,age,createdtime from firsttb"; ResultSet rs = stmt.executeQuery(sql); int index = 0; while (rs.next()) { index++; String id = rs.getString("id"); String name = rs.getString("name"); String age = rs.getString("age"); String cdate = rs.getString("createdtime"); String raw = "#{0},{1},{2},{3},{4}"; Object[] arr = { index, id, name, age, cdate }; String outStr = MessageFormat.format(raw, arr); System.out.println(outStr); } } catch (Exception e) { System.out.print(e.getMessage()); } finally { try { stmt.close(); conn.close(); } catch (SQLException e) { System.out.print("Can't close stmt/conn because of " + e.getMessage()); } } } /** * 执行点 * @param args */ public static void main(String[] args) { testConnToDB(); } }
输出:
#1,1,ANDY,20,2019-11-09 09:19:10 #2,2,Bill,30,2019-11-09 09:19:39 #3,3,Cindy,40,2019-11-09 09:19:45
最新文章
- 同个项目写webservice引用EF出现的问题
- NOIP200806 火柴棒等式【B005】
- C语言面试题(二)
- Metadata file 'xxx.dll' could not be found 已解决
- react native for Android (make you first android app)
- 集中式vs分布式
- intellij idea 2016版破解方法
- jquery的ajax方法:ajaxStart()和ajaxStop()
- linux下C++动态链接C++库示例详解
- unity3d 多人寻路堵塞堆叠问题
- 从客户端检测到有潜在危险的 Reque
- [ERR] Node 172.168.63.202:7001 is not empty. Either the nodealready knows other nodes (check with CLUSTER NODES) or contains some
- Windows Server 2016-Windows安全日志ID汇总
- C#复习笔记(3)--C#2:解决C#1的问题(泛型)
- gcc,g++
- MVVM Light 笔记 - snippet
- 乐字节-Java8新特性之方法引用
- java拷贝文件到另一个目录下
- linux命令返回值的含义
- java学习笔记14--多线程编程基础1