简单的连接数据库

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


import org.junit.Test;


public class JDBC {



@Test
public void test() throws Exception{
System.out.println(getSQL());
}
public Connection getSQL() throws Exception{


InputStream inputStream=null;


Properties properties =new Properties();
inputStream=this.getClass().getClassLoader().getResourceAsStream("jdbc.properties");
properties.load(inputStream);

String driver=properties.getProperty("driver");
String url=properties.getProperty("url");
String user=properties.getProperty("user");
String password=properties.getProperty("password");

Class.forName(driver);
return DriverManager.getConnection(url, user, password);

}
public void closeResources(Statement statement, Connection connection,ResultSet resultSet){
if(statement!=null){
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(connection!=null){
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(resultSet!=null){
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}