package com.cgdata.test;
import java.sql.*;
public class TestClientOracle {
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@192.168.80.80:1521:ORCL";
String user = "scott";//登录的账号
String password = "root";//登录的密码
connection = DriverManager.getConnection(url, user, password);
System.out.println(connection);
statement = connection.createStatement();
String sql = "select * from dept";
// String sql = "insert into dept(deptno,dname,loc) values(2,'lisi','wanger')";
long startTime = System.currentTimeMillis();
queryOracle(sql,statement,connection);
// insertOracle(sql,statement,connection);
System.out.println(String.valueOf(System.currentTimeMillis()-startTime));
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
public static void queryOracle
使用原生jdbc操作oracle数据库
最新推荐文章于 2024-09-24 09:19:59 发布
本文介绍如何在Java项目中使用原生JDBC进行Oracle数据库操作。通过引入Maven依赖,详细讲解了连接Oracle数据库、执行SQL语句及处理结果的基本步骤。
摘要由CSDN通过智能技术生成