package ddc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DataFactory {
public static Connection getCon() {
Connection con = null;
PreparedStatement pre = null;
ResultSet result = null;
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String user = "scott";
String pass = "tiger";
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pass);
String sql = "select * from emp";
pre = con.prepareStatement(sql);
result = pre.executeQuery();
while (result.next()) {
System.out.print(result.getString("
oracle 数据库连接代码编写
最新推荐文章于 2021-04-05 13:43:15 发布
本文详细介绍了如何编写连接Oracle数据库的代码,涵盖了必要的配置步骤和关键的编程接口使用,为大数据处理提供稳定的数据源。
摘要由CSDN通过智能技术生成