Java連接Oracle(高級(jí)篇)

在項(xiàng)目工程目錄下新建一個(gè)config文件夾，在config文件夾里創(chuàng)建一個(gè)database.properties文件，配置相關(guān)Oracle數(shù)據(jù)庫(kù)的driver、url、username、password。

#Oracle

jdbc.driver=oracle.jdbc.driver.OracleDriver

jdbc.url=jdbc:oracle:thin:@localhost:1521:moonlight

jdbc.username=scott

jdbc.password=tiger

在DBUtil.java中封裝數(shù)據(jù)庫(kù)常用操作。

import java.io.FileInputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Properties;

public class DBUtil {

public static Connection getConnection() {

Connection conn = null;

Properties props = null;

FileInputStream in = null;

try {

props = new Properties();

in = new FileInputStream("config/database.properties");

props.load(in);

in.close();

String jdbcdriver = props.getProperty("jdbc.driver");

if (jdbcdriver != null) {

System.setProperty("jdbc.driver", jdbcdriver);

}

String url = props.getProperty("jdbc.url");

String username = props.getProperty("jdbc.username");

String password = props.getProperty("jdbc.password");

conn = DriverManager.getConnection(url, username, password);

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public static void close(Connection conn) {

if (conn != null) {

try {

conn.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void close(PreparedStatement pstmt) {

if (pstmt != null) {

try {

pstmt.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void close(ResultSet rs) {

if (rs != null) {

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

最后，在JDBCDemo.java中測(cè)試一下是否配置連接成功。

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class JDBCDemo {

public static void main(String[] args) throws Exception {

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

String keyword = "SMI";

String sql = "SELECT empno, ename, job FROM emp WHERE ename LIKE ?";

conn = DBUtil.getConnection();

pstmt = conn.prepareStatement(sql);

pstmt.setString(1, "%" + keyword + "%");

rs = pstmt.executeQuery();

while (rs.next()) {

int empno = rs.getInt("empno");

String ename = rs.getString("ename");

String job = rs.getString("job");

System.out.println("empno: " + empno + ", ename: " + ename

+ ", job: " + job);

}

DBUtil.close(rs);

DBUtil.close(pstmt);

DBUtil.close(conn);

}

}

總結(jié)

以上是生活随笔為你收集整理的java搭配oracle,Java联接Oracle（高级篇）的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。