一个测试数据库连接的类,自己留着以后方便用。 DBTest.java 测试类 Java代码 import java.sql.*; public class DBTest { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { OracleConn oc=new Ora
一个测试数据库连接的类,自己留着以后方便用。 DBTest.java 测试类
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数据库连接信息
Java代码
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;
}
}