package com.ww.jdbc;
import com.ww.jdbc_demo_01.javabean.user;
import java.nio.file.attribute.UserPrincipal;
import java.sql.*;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
public class jdbc_demo2 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//连接数据库
String url ="jdbc:mysql://localhost:3306/ooo";
String username = "root";
String password = "123456";
Connection connection = DriverManager.getConnection(url,username,password);
String sql = "select * from user";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
//循环打印输出所有结果集 或者 将所有的结果集存入对象,存入对象后和返回,可读取
List<user> list = new ArrayList<user>();
while (resultSet.next()){
// System.out.println(resultSet.getObject("id"));
// System.out.println(resultSet.getObject("username"));
// System.out.println(resultSet.getObject("password"));
// System.out.println(resultSet.getObject("nickname"));
user user = new user();
user.setId(resultSet.getInt("id"));
user.setUsername(resultSet.getString("username"));
user.setPassword(resultSet.getString("password"));
user.setNickname(resultSet.getString("nickname"));
list.add(user);
}
//循环打印
for (user u:list){
System.out.println(u.toString());
}
//迭代方式打印
Iterator<user> iterator = list.iterator();
while (iterator.hasNext()){
user next = iterator.next();
System.out.println(next);
}
//释放资源(先创建,后关闭)
resultSet.close();
statement.close();
connection.close();
}
}