JDBC连接数据库的两种方法

第一种：

package com.dr.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;



public class DBHelper{

  
    /**
     * 新创建一个数据库连接
     * @return
     */
    public static Connection getConn() {
        String url="jdbc:oracle:thin:@121.52.216.217:1521:orcl";
        String username ="itmms";
        String password ="itmms";
        Connection conn = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            conn = DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
        
    }
    



    /**
     * 执行增加删除和修改的方法
     * 
     * @param sql
     * @param condition
     */
    public static void execSql(Connection con, String sql, Object[] condition) {
        PreparedStatement ps = null;
        try {
            ps = con.prepareStatement(sql);
            if (condition!= null && condition.length > 0) {
                for (int i = 0; i < condition.length; i++) {
                    ps.setObject(i + 1, condition[i]);
                }
            }
            ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();

        }finally{
            closeAll(null, ps);
        }
    }
    
 
   
    /**
     * 关闭�?��连接
     * 
     * @param rs
     * @param ps
     * @param con
     */
    public static void closeAll(ResultSet rs, PreparedStatement ps,Connection con) {
        try {
            if (rs != null)
                rs.close();
            if (ps != null)
                ps.close();
            if(con !=null)con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static void closeAll(ResultSet rs, PreparedStatement ps) {
        try {
            if (rs != null)
                rs.close();
            if (ps != null)
                ps.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static void closeConn(Connection con) {
        try {
            if (con != null) {
                con.close();
                con = null;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

第二种，在配置文件中 配置相关信息

public Connection openConnection(){
		String driver = "";
		String url = "";
		String user = "";
		String password = "";
		Properties prop = new Properties();
		Connection conn = null;
		try {
			//加载属�?文件
			prop.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));
			driver = prop.getProperty("driver");
			url = prop.getProperty("url");
			user = prop.getProperty("user");
			password = prop.getProperty("password");
			//Class.forName加载驱动
			Class.forName(driver);
			//DriverManager获得连接
			conn = DriverManager.getConnection(url,user,password);
			return conn;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

在配置文件中DBConfig.properties

driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/shopping
user=root
password=1234