jdbc数据库基本连接

一、引用ojdbc6.jar

二、伪代码如下：

package com.db;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

 

/**

 * 数据库连接类

 * @author wgy

 *

 */

public class OracleDB {

public static String driver_class="oracle.jdbc.driver.OracleDriver";

public static String url="jdbc:oracle:thin:@192.168.0.92:1521:orcl";

public static String username="sde2";

public static String password="sde2";

 

public Connection getConnection(){

Connection conn=null;

try {

Class.forName(driver_class);

conn=DriverManager.getConnection(url, username, password);

   if (!conn.isClosed()) {

                System.out.println("数据库连接成功！"); //验证是否连接成功

            }

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

return conn;

}

 

public void closeAll(Connection conn,PreparedStatement ps,ResultSet rs){

try {

if(rs!=null){

rs.close();

}

if(ps!=null){

ps.close();

}

if(conn!=null){

conn.close();

}

} catch (Exception e) {

// TODO: handle exception

e.printStackTrace();

}

}

 

}