package com.xt.test;

import java.io.InputStream;

import java.sql.SQLException;

import java.util.Properties;

import org.junit.Test;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.Driver;

/**

 * 测试连接数据库，获取数据库链接

 * 其中有读取资源文件的方法。

 * @author LZF

 */

public class TestDBConnection {

/**

 * 直接硬编码连接mysql

 * @throws SQLException

 */

@Test

public void testJdbc() throws SQLException{

Driver driver=new com.mysql.jdbc.Driver();

String url="jdbc:mysql://127.0.0.1:3306/test";

Properties info=new Properties();

info.put("user", "root");

info.put("password", "");

Connection connection=(Connection) driver.connect(url, info);

System.out.println(connection);

}

/**

 * 通过配置，将数据库的基本信息放置到配置文件中。

 * @throws ClassNotFoundException 

 * @throws IllegalAccessException 

 * @throws InstantiationException 

 * @throws SQLException

 */

public Connection getConnection() throws Exception{

//读取类路径下的jdbc.properties

InputStream      in=getClass().getClassLoader().getResourceAsStream("jdbc.properties");

Properties properties=new Properties();

properties.load(in);

String driverClass=properties.getProperty("driverClass");

String jdbcUrl=properties.getProperty("jdbcUrl");

String userName=properties.getProperty("userName");

String password=properties.getProperty("password");

if(password==null&&"".equals(password)){

password="";

}

Properties info=new Properties();

info.put("user", userName);

info.put("password", password);

//通过反射创建对象

Driver driver=(Driver)Class.forName(driverClass).newInstance();

Connection connection=(Connection) driver.connect(jdbcUrl, info);

return connection;

}

@Test

public void testGetConnection() throws Exception{

System.out.println(this.getConnection());

}

}