袁奇生

To always face my adversity head on.

  博客园 :: 首页 :: 博问 :: 闪存 :: 新随笔 :: 联系 :: 订阅 订阅 :: 管理 ::
    public void test() throws Exception {
        //创建一个Properties对象
        Properties props=new Properties();
        //将某一个具体的Properties文件与props产生关系
        //将jdbc.properties文件转成输入字节流
        InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("resource/jdbc.properties");
        props.load(ins);
        //3.开始读取jdbc.properties中的数据
        String driver = props.getProperty("driver");
        System.out.println(driver);
        System.out.println(url);
        System.out.println(username);
        System.out.println(password);
    }
}

 JdbcUtils

package com.yqs.utils;

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

import org.junit.Test;


public class JdbcUtil {
    private static String driver=null;//驱动
    private static String url=null;//连接地址
    private static String username=null;//用户名
    private static String password=null;//密码
    static {
        try {
            Properties props=new Properties();
            InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("jdbc.properties");
            props.load(ins);
            driver = props.getProperty("driver");
            url = props.getProperty("url");
            username = props.getProperty("username");
            password = props.getProperty("password");
            Class.forName(driver);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * Description:获取数据连接<br/>
     * @return yuanQiSheng
     * @throws Exception
     */
    public static Connection getConnection() throws Exception {
        
        return DriverManager.getConnection("url","username","password");
    }
    /**
     * Description:释放数据库资源<br/>
     * @param conn:Connection
     * @param pres:PreparedStatement
     * @param rs:ResultSet
     */
    public static void release(Connection conn,Statement stm,ResultSet rs) {
        try {
            if(rs!=null) {
                rs.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        try {
            if(stm!=null) {
                stm.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        try {
            if(conn!=null) {
                conn.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    @Test
    public void test() throws Exception {
        //创建一个Properties对象
        Properties props=new Properties();
        //将某一个具体的Properties文件与props产生关系
        //将jdbc.properties文件转成输入字节流
        InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("resource/jdbc.properties");
        props.load(ins);
        //3.开始读取jdbc.properties中的数据
        String driver = props.getProperty("driver");
        System.out.println(driver);
        System.out.println(url);
        System.out.println(username);
        System.out.println(password);
    }
}

 

posted on 2020-02-25 15:29  逼近精进  阅读(169)  评论(0编辑  收藏  举报