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中的数据。