跨平台
1.建立properties文件 点击src右键new->Resource Bundle
2.在properties文件里面输入以下信息,不用分号,不用双引号
3.建立连接类DBUtils
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class DBUtils {
private static final Properties PROPERTIES=new Properties();//储存配置文件内容价值的properitues集合
static {
InputStream is=DBUtils.class.getResourceAsStream("/db.properties");
try {
PROPERTIES.load(is);//通过流,将配置文件内容加载到propertuies集合
Class.forName(PROPERTIES.getProperty("driver"));
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection connection=null;
try {
connection= DriverManager.getConnection(PROPERTIES.getProperty("url"),PROPERTIES.getProperty("name"),PROPERTIES.getProperty("password"));
}
catch (SQLException e){
e.printStackTrace();
}
return connection;
}
//释放资源
public static void closeAll(Connection connection, Statement statement, ResultSet resultSet){
try {
if (connection!=null){
resultSet.close();
}
if (statement!=null){
statement.close();
}
if (resultSet!=null){
resultSet.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
4.建立测试类
import java.sql.Connection;
public class TestDbtuils {
public static void main(String[] args) {
Connection connection=DBUtils.getConnection();
System.out.println(connection);
}
}