JDBC ORACLE THIN EXAMPLE

最新推荐文章于 2021-03-16 10:50:51 发布

iteye_2892

最新推荐文章于 2021-03-16 10:50:51 发布

阅读量128

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle 文章标签： JDBC Oracle SQL Java

本文链接：https://blog.youkuaiyun.com/iteye_2892/article/details/82072485

Oracle 专栏收录该内容

2 篇文章

订阅专栏

本文提供了一个使用Java进行数据库连接的示例代码，通过DBConnection类实现与Oracle数据库的交互，包括设置数据库驱动、URL、用户名及密码，并执行SQL查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

JAR package: class12.jar


package com.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {

	private String drivername;
	private String dburl;
	private String username;
	private String password;

	public Connection getConnection() {
		try {
			Class.forName(drivername);
			return DriverManager.getConnection(dburl, username, password);
		} catch (ClassNotFoundException e) {
			System.out.println(e.getMessage());
			e.printStackTrace();
		} catch (SQLException e) {
			System.out.println(e.getMessage());
			e.printStackTrace();
		}
		return null;

	}

	public String getDrivername() {
		return drivername;
	}

	public void setDrivername(String drivername) {
		this.drivername = drivername;
	}

	public String getDburl() {
		return dburl;
	}

	public void setDburl(String dburl) {
		this.dburl = dburl;
	}

	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

}


package com.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBDemon {

	/**
	 * @param args
	 */
	public static void main(String[] args) {		
		DBConnection dbdemon = new DBConnection();
		dbdemon.setDrivername("oracle.jdbc.driver.OracleDriver");
		dbdemon.setDburl("jdbc:oracle:thin:@host:port:sid");
		dbdemon.setUsername("username");
		dbdemon.setPassword("password");
		Connection conn = dbdemon.getConnection();
		ResultSet rs = null;
		try {
			Statement stmt = conn.createStatement();
			String sql = "select * from sc_processing_queue";
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				System.out.println(rs.getInt(1));
				System.out.println(rs.getInt(2));
				System.out.println(rs.getString(3));
				System.out.println(rs.getString(4));
				System.out.println(rs.getString(5));
				System.out.println(rs.getDate(6));
				System.out.println(rs.getDate(7));
			}
		} catch (SQLException e) {
			System.out.println(e.getMessage());
		} finally {
			try {
				rs.close();
				conn.close();
			} catch (SQLException e) {
				System.out.println(e.getMessage());
			}
		}

	}
}