JDBC配置文档连接数据库

1、创建项目

新建jdbc.properties文件

jdbc.name=scott
jdbc.pwd=tiger
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl

2.编写连接数据库类

package com.cd.util;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class JDBCConnection {
private static String name;
private static String pwd;
private static String driver;
private static String url;
private static Connection connection ;
private static PreparedStatement ps ;
private static ResultSet rs ;

static{
try {
InputStream inStream = JDBCConnection.class.getResourceAsStream("/jdbc.properties");
Properties properties =  new Properties();
properties.load(inStream);
name=properties.getProperty("jdbc.name");
pwd=properties.getProperty("jdbc.pwd");
driver=properties.getProperty("jdbc.driver");
url=properties.getProperty("jdbc.url");
Class.forName(driver);
} catch (Exception e) {
throw new RuntimeException("读取数据区文件异常!", e);
}
}

public static Connection getconn(){
try {
connection = DriverManager.getConnection(url, name, pwd);
System.out.println("数据库连接成功"+connection);
} catch (SQLException e) {
throw new RuntimeException("数据库连接异常",e);
}return connection;

}
public static void close(){
if(connection != null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps != null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

}




public static void main(String[] args) {
JDBCConnection.getconn();
JDBCConnection.close();

}

}