1.在lib目录下导入数据库连接池
2.build path
3.代码
//1.注册数据库驱动
DriverManager.registerDriver(new Driver());//2.获取数据库库链接
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/day10", "root", "root");
//3.获取传输器对象
Statement statement=con.createStatement();
//4.利用传输器传输sql语句到数据库中执行,获取结果集对象
ResultSet rs=statement.executeQuery("select * from users");
//5.遍历结果集获取查询结果
while(rs.next()){
String name=rs.getString("username");
System.out.println(name);
}
//6.关闭资源
rs.close();
statement.close();
con.close();