Oracle数据库连接测试

一个测试数据库连接的类，自己留着以后方便用。

 

   DBTest.java   测试类

import java.sql.*;
public class DBTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try  
		  {  
		   OracleConn oc=new OracleConn();  
		   Connection conn=oc.oracleGetConn();  
		   Statement  stmt=conn.createStatement();  
		   stmt.execute("select * from SECURITY_ASSETS");  
		   ResultSet rs=stmt.getResultSet();  
		   System.out.println("------【Java连接Oracle数据库测试】------");  
		   System.out.println("----------------------------------------------");  
		   System.out.println("ID"+"|"+"NAME"+"|"+"SYSTEM"+"|"+"IP"+"|"+"STATUS");  
		   System.out.println("----------------------------------------------");  
		   while(rs.next())  
		   {  
		    System.out.println(rs.getString(1)+"|"+rs.getString(2)+"|"+  
		    rs.getString(3)+"|"+rs.getString(4)+"|"+rs.getString(5));  
		   }  
		  }  
		  catch(Exception e)  
		  {  
		  e.printStackTrace();  
		 }  
	}

}

 

    OracleConn.java ---oracle数据库连接信息

import java.sql.Connection;
import java.sql.DriverManager;

public class OracleConn  
{  
  Connection conn;  
  public Connection oracleGetConn(){  
  String driver="oracle.jdbc.driver.OracleDriver";  
  String url="jdbc:oracle:thin:@111.1.46.68:1521:smp";  
  try  
  {  
   Class.forName(driver);  
   conn=DriverManager.getConnection(url,"smp","smpsmp");  
  }  
  catch(Exception e)  
  {  
   System.out.println("数据库连接失败，原因如下所示：");  
   e.printStackTrace();  
  }  
   return conn;  
  }  
}