import java.io.IOException;
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;
public class DBTest
{
/*public static void main(String[] args)
{
Driver driver = new Driver();
String url = "jdbc:mysql://192.168.52.128:3306/mysqltest";
Properties info = new Properties();
info.put("user", "root");
info.put("password", "123456");
//Connection connection;
try {
//connection = getConnectionInfo();
//System.out.println(connection);
//connection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/
@Test
public void Test()
{
//System.out.println(getConnectionInfo());
Connection connection = null;
connection = getConnectionInfo();
if(connection != null)
{
System.out.println(connection);
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else
{
System.out.println("获取连接失败");
}
}
public Connection getConnectionInfo()
{
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
//读取配置文件
InputStream in = getClass().getClassLoader().getResourceAsStream("db.properties");
Properties pro = new Properties();
try {
pro.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
driverClass = pro.getProperty("driver");
jdbcUrl = pro.getProperty("jdbcUrl");
user = pro.getProperty("user");
password = pro.getProperty("password");
//System.out.println("driver="+driverClass+"\njdbcUrl="+jdbcUrl+"\nuser="+user+"\npassword="+password);
Driver driver;
try {
driver = (Driver) Class.forName(driverClass).newInstance();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
//System.out.println(driver);
Properties info = new Properties();
info.put("user", user);
info.put("password", password);
Connection connection = null;
try {
connection = (Connection)driver.connect(jdbcUrl, info);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return connection;
}
}
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;
public class DBTest
{
/*public static void main(String[] args)
{
Driver driver = new Driver();
String url = "jdbc:mysql://192.168.52.128:3306/mysqltest";
Properties info = new Properties();
info.put("user", "root");
info.put("password", "123456");
//Connection connection;
try {
//connection = getConnectionInfo();
//System.out.println(connection);
//connection.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/
@Test
public void Test()
{
//System.out.println(getConnectionInfo());
Connection connection = null;
connection = getConnectionInfo();
if(connection != null)
{
System.out.println(connection);
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else
{
System.out.println("获取连接失败");
}
}
public Connection getConnectionInfo()
{
String driverClass = null;
String jdbcUrl = null;
String user = null;
String password = null;
//读取配置文件
InputStream in = getClass().getClassLoader().getResourceAsStream("db.properties");
Properties pro = new Properties();
try {
pro.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
driverClass = pro.getProperty("driver");
jdbcUrl = pro.getProperty("jdbcUrl");
user = pro.getProperty("user");
password = pro.getProperty("password");
//System.out.println("driver="+driverClass+"\njdbcUrl="+jdbcUrl+"\nuser="+user+"\npassword="+password);
Driver driver;
try {
driver = (Driver) Class.forName(driverClass).newInstance();
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
//System.out.println(driver);
Properties info = new Properties();
info.put("user", user);
info.put("password", password);
Connection connection = null;
try {
connection = (Connection)driver.connect(jdbcUrl, info);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
return connection;
}
}