Question

请教JDBC怎么连接ORACLE数据库

Answer 1

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class TestConnectOracle { public static void main(String[] args) { Connection con = null; PreparedStatement pre = null; ResultSet result = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("开始尝试连接数据库！"); String url = "jdbc:oracle:" + "thin:@127.0.0.1:1521:ORCL1"; String user = "pioneer"; String password = "pioneer"; con = DriverManager.getConnection(url, user, password); System.out.println("连接成功！"); String sql = "select * from tt where 1=?"; pre = con.prepareStatement(sql); pre.setString(1, "1"); result = pre.executeQuery(); while (result.next()) { System.out.println("Course: " + result.getString("name") + ", F1: " + result.getString("F1") + ",F2: " + result.getString("F2") + ", F3: " + result.getString("F3") + ", F4: " + result.getString("F4")); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (result != null) result.close(); if (pre != null) pre.close(); if (con != null) con.close(); System.out.println("数据库连接已关闭！"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }}