JDBC连接数据库 执行增删查改操作

public Connection getConnectionS() throws IOException, ClassNotFoundException, SQLException {
// 1. 创建Properties对象
Properties properties = new Properties();
// 2. 获取jdbc.properties对应得输入流，并加载
InputStream resourceAsStream = this.getClass().getClassLoader().getResourceAsStream("jdbc.properties");
properties.load(resourceAsStream);
String userName = properties.getProperty("user"); // 数据库得名称
String pass = properties.getProperty("pass"); //数据库得密码
String jdbcUrl = properties.getProperty("jdbcUrl"); //数据库得Url
String driverClass = properties.getProperty("driver");
// 3.加载数据库驱动程序
Class.forName(driverClass);
// 4. 通过DriverManager得 getConnection()得方法链接数据库
Connection connection = DriverManager.getConnection(jdbcUrl, userName, pass);
return connection;
}