JDBC（oracle11g）

来源：互联网发布：明解c语言入门篇答案编辑：程序博客网时间：2024/06/05 00:46

环境：jdk1.7+oracle11g

1.创建java工程

2.在oracle安装目录下找到jdbc/lib/ojdbc6.jar

3.将jar包导入工程，点击工程 - 右键 - Build Path - Add External Archives，选择ojdbc6.jar

4.在oracle中创建一张表

5.在工程中创建class，例如为：Demo.java

6.加载OracleDriver类：Class.forName("oracle.jdbc.driver.OracleDriver");

Class.forName()的作用是要求JVM查找并加载指定的类，即JVM会执行该类的静态代码段，OracleDriver的静态代码中实例化了DriverManager

7.创建数据库连接：DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.208:1521:orcl", username, password);

8.创建Statement：stmt = conn.createStatement();

Statement 对象用于执行一条静态的 SQL 语句并获取它产生的结果

以下为测试程序代码:

import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Demo {static{try {Class.forName("oracle.jdbc.driver.OracleDriver");} catch (ClassNotFoundException e) {e.printStackTrace();}}private Connection conn;private Statement stmt;//Statement 对象用于执行一条静态的 SQL 语句并获取它产生的结果private ResultSet rs;public void connectOracle(String username,String password){try {conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.208:1521:orcl", username, password);} catch (SQLException e) {e.printStackTrace();}try {stmt = conn.createStatement();} catch (SQLException e) {e.printStackTrace();}}public boolean executeNoQuery(String sql){try {return stmt.execute(sql);} catch (SQLException e) {e.printStackTrace();}return false;}public ResultSet executeQuery(String sql){this.rs = null;try {rs=stmt.executeQuery(sql);} catch (SQLException e) {e.printStackTrace();}return rs;}public void close(){try {rs.close();stmt.close();conn.close();} catch (SQLException e) {e.printStackTrace();}}public static void main(String[] args) {Demo test = new Demo();test.connectOracle("ida", "ida");String mySql="SELECT t.yhmc,t.xb FROM BASE_USER t";ResultSet r = test.executeQuery(mySql);try {while(r.next()){String yhmc = r.getString("yhmc");String xb = r.getString("xb");System.out.println(yhmc+"---"+xb);}} catch (SQLException e) {e.printStackTrace();}}}

0 0