java实现oracle连接_java实现oracle数据库连接

连接数据库：

package com.sinosoft.wwl;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class Dbconnection

{

final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";//加载oracle驱动

final static String sConnStr = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";//127.0.0.1是本机：1521 是接口：orcl 是数据库名,如果不知道数据库名可在SOL Plus中输入select * from v$database;得到当前数据库名。

final static String user="system";//用户名

final static String password="orcl";//密码

public Dbconnection()

{

}

public static Connection connectionDbByOci()

{

Connection conn = null;

try {

Class.forName(sDBDriver);

conn = (Connection) DriverManager.getConnection(sConnStr,user,password);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

public static void closeConnection(Connection conn)

{

if(conn !=null)

{

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public static void closePrepStmt(PreparedStatement prepStmt)

{

if(prepStmt !=null)

{

try {

prepStmt.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public static void closeResultSet(ResultSet re)

{

if(re != null)

{

try {

re.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

}

得到当前数据库名：

测试是否连接到数据库：

package com.sinosoft.wwl;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class DBUser {

public static void main(String[] args)

{

Connection conn = null;

PreparedStatement pre = null;

ResultSet re = null;

Dbconnection dbcon = new Dbconnection();

conn = Dbconnection.connectionDbByOci();

String sql = "select * from stuinfo";

try {

pre = conn.prepareStatement(sql);

re = pre.executeQuery();

while(re.next())

{

System.out.println("stuname:"+re.getString("stuname"));

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally

{

dbcon.closeConnection(conn);

dbcon.closePrepStmt(pre);

dbcon.closeResultSet(re);

}

}

}即可得到数据库表stuinfo中的数据。