oracle数据库 rec是什么意思,我用的是Oreclo数据库该怎样写这一段？？

超速_蜗牛

2016-12-12 17:17

package util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBHelper {

private static Connection connection=null;

private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orc";

private static final String USERNAME = "SYS as SYSDBA";

private static final String PASSWORD = "admin";

static{

try {

Class.forName(DRIVER);

} catch (Exception e) {

e.printStackTrace();

}

}

private static Connection getConnection() {

if (connection==null) {

try {

connection = DriverManager.getConnection(URL,USERNAME,PASSWORD);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return connection;

} else {

return connection;

}

}

private static void closeConnection(Connection connection) {

if (connection!=null) {

try {

connection.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}

public static void main(String[] args) {

Connection conn = null;

conn = DBHelper.getConnection();

if (conn!=null) {

System.out.println("数据库连接正常");

}else {

System.out.println("数据库连接异常");

}

DBHelper.closeConnection(conn);

}

}