java - JDBC连接数据库参数

来源：互联网发布：康美包员工知乎编辑：程序博客网时间：2024/06/05 21:54

ORACLE 数据库连接示例

oracle.properties 文件

oracle.driver=oracle.jdbc.driver.OracleDriveroracle.url=jdbc:oracle:thin:@127.0.0.1:1521:orcloracle.username=SCOTToracle.password=123456

mysql.properties 文件

mysql.driver=com.mysql.jdbc.Drivermysql.url=jdbc:mysql://localhost:3306/db_v?useUnicode=true&characterEncoding=utf8mysql.username=rootmysql.password=123456

DBUtil.java 文件

import java.io.IOException;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 DBUtil {private static String driver = "" ;private static String url = "" ;private static String username = "" ;private static String password = "" ;static {Properties pp = new Properties();try {pp.load(DBUtil.class.getClassLoader().getResourceAsStream("oracle.properties"));driver = pp.getProperty("oracle.driver");url = pp.getProperty("oracle.url");username = pp.getProperty("oracle.username");password = pp.getProperty("oracle.password");Class.forName(driver);System.out.println(driver+" "+url+" "+username+" "+password);} catch (ClassNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}public static Connection getConnection (){Connection conn = null ;try {conn = DriverManager.getConnection(url, username, password);} catch (SQLException e) {e.printStackTrace();}return conn ;}public static void close(ResultSet rs , PreparedStatement ps , Connection conn){try {if(rs!=null /*&& !rs.isClosed()*/){rs.close();}if(ps!=null/* && !ps.isClosed()*/){ps.close();}if(conn!=null /*&& !conn.isClosed()*/){conn.close();}} catch (SQLException e) {e.printStackTrace();}}public static void main(String[] args) {System.out.println(DBUtil.getConnection());}}

0 0