JAVA连接Oracle数据库实代码
下面是连接数据库的代码:<div class="highlighter">
[*]package org.javawo.test;<li class="alt">
[*]import java.sql.Connection;
[*]import java.sql.DriverManager;
[*]
[*]/**
[*] * 获取数据库连接
[*] *
[*] * @author 杨涛
[*] *
[*] */
[*]public class DBConnection {
[*]
[*] /** Oracle数据库连接URL*/
[*] private final static String DB_URL = "jdbc:oracle:thin:@192.168.2.66:1521:orcl66";
[*]
[*] /** Oracle数据库连接驱动*/
[*] private final static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
[*]
[*] /** 数据库用户名*/
[*] private final static String DB_USERNAME = "cpp";
[*]
[*] /** 数据库密码*/
[*] private final static String DB_PASSWORD = "cpp";
[*]
[*] /**
[*] * 获取数据库连接
[*] * @return
[*] */
[*] public Connection getConnection(){
[*] /** 声明Connection连接对象*/
[*] Connection conn = null;
[*] try{
[*] /** 使用Class.forName()方法自动创建这个驱动程序的实例且自动调用DriverManager来注册它*/
[*] Class.forName(DB_DRIVER);
[*] /** 通过DriverManager的getConnection()方法获取数据库连接*/
[*] conn = DriverManager.getConnection(DB_URL,DB_USERNAME,DB_PASSWORD);
[*] }catch(Exception ex){
[*] ex.printStackTrace();
[*] }
[*] return conn;
[*] }
[*]
[*] /**
[*] * 关闭数据库连接
[*] *
[*] * @param connect
[*] */
[*] public void closeConnection(Connection conn){
[*] try{
[*] if(conn!=null){
[*] /** 判断当前连接连接对象如果没有被关闭就调用关闭方法*/
[*] if(!conn.isClosed()){
[*] conn.close();
[*] }
[*] }
[*] }catch(Exception ex){
[*] ex.printStackTrace();
[*] }
[*] }
[*]
[*]}
页:
[1]