远程连接thin oracle,Java java jdbc thin远程连接并操作Oracle数据库

转载于 2021-04-13 12:46:45 发布 · 214 阅读

文章标签：

该博客展示了如何使用Java连接Oracle数据库并执行SQL查询和更新操作。代码中定义了数据库连接字符串、用户和密码，并实现了OracleConection类，包含建立连接、执行查询和更新的方法。示例中创建了一个名为test_table的表，并演示了查询结果的遍历。

CREATE TABLE test_table

(

NUMBER(5) PRIMARY KEY,

name

VARCHAR2(15) NOT NULL

)

TABLESPACE testtbs01;

OracleConection.java代码如下：

package testpckg;

import java.sql.*;

public class OracleConection {

//定义连接字符串(协议名:jdbc:oracle:thin@oracle据库服务器主机ip:数据库监听端口号:SID)

private

String

url

= "jdbc:oracle:thin:@172.25.75.14:1521:orcl11g";

private

String

userName

= "system"; //数据库用户名

private

String

password

= "abc123"; //登录密码

private

Connection

connector;

private

Statement

statement;

private

ResultSet

rs = null;

public

OracleConection()

{

try

{

Class.forName("oracle.jdbc.driver.OracleDriver");

//加载驱动

connector

DriverManager.getConnection(url, userName, password); //建立连接

statement

= connector.createStatement();

} catch (ClassNotFoundException ex)

{

System.out.println("Error:Can't Load the SQL Server

Driver");

} catch (SQLException ex) {

System.out.println("Error:Can't connect to

Database!");

}

public

ResultSet

executeQuery(String sql) {

rs = null;

try

{

rs = statement.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return

rs;

}

public

boolean

executeUpdate(String

sql) {

try

{

statement.executeUpdate(sql);

return

true;

} catch (SQLException e) {

e.printStackTrace();

return

false;

}

public

void

finalize() {

try

{

connector.close();

statement.close();

} catch (Exception e) {

e.printStackTrace();

}

public

static

void

main(String[] args)

{

ResultSet rs = null;

boolean

flag =

false;

OracleConection obj = new OracleConection();

//执行查询

rs = obj.executeQuery("select * from

test_table"); //注意，不能有分号

try

{

while

(rs.next())

{

//遍历结果

System.out.println("id:"+rs.getString(1)+"

name:"+rs.getString(2));

}

} catch (Exception e) {

e.printStackTrace();

}