spring中jdbc连接数据库(idea版本)

//1.注册驱动
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
//2.获取连接 Connection connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/springssm”,“账号”,“密码”); //3.获取操作数据库的预处理对象
PreparedStatement preparedStatement = connection.prepareStatement(“select * from account”);
//4.执行sql，得到结果集
ResultSet resultSet = preparedStatement.executeQuery();
//5.遍历结果集
while (resultSet.next()){
System.out.println(resultSet.getString(“name”));
}
//6.释放资源
resultSet.close();
preparedStatement.close();
connection.close();