package cn.jy.demo;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class storetraverse {
public static void main(String[] args) throws SQLException {
fun1();
//fun2();
}
//通过遍历将表格中的数据存放到zhangwu1对象中（根据zhangwu1的有参构造）然后在将其存放到集合中 最后对集合进行遍历 输出结果
public static void fun1() throws SQLException{
Connection con=JDBCUtilsConfig.getConnection(); //连接 其中JDBCUtilsConfig为我自己为方便连接封装的类
String sql="SELECT * FROM zhangwu1"; //遍历我们创建的表格
PreparedStatement pst=con.prepareStatement(sql); //执行平台对象
ResultSet rs= pst.executeQuery(); //将查询的信息存放到ResultSet集合中
List<zhangwu1> list = new ArrayList<>();//创建集合 为之后的数据存入到集合中方便
while(rs.next()){
zhangwu1 zw=new zhangwu1(rs.getInt("id"),rs.getString("flname"),rs.getDouble("money"),rs.getString("zhanghu"),rs.getString("date"),rs.getString("description"));
list.add(zw);
}
for(zhangwu1 zw:list){
System.out.println(zw);
}
JDBCUtilsConfig.close(con, pst,rs);
}
//通过构造方法将一组数据用new对象的方式存入到集合中 先遍历 让后根据输入将该组数据输出
public static void fun2(){
List<zhangwu1> list=new ArrayList<>();
list.add(new zhangwu1(11,"女警",999,"4566","2015-6","优秀"));
list.add(new zhangwu1(12,"寒冰",599,"4567","2015-6","优秀"));
list.add(new zhangwu1(13,"女警1",699,"4568","2015-6","优秀"));
list.add(new zhangwu1(14,"女警2",799,"4569","2015-6","优秀"));
list.add(new zhangwu1(15,"女警3",199,"4576","2015-6","优秀"));
list.add(new zhangwu1(16,"女警4",99,"4598","2015-6","优秀"));
for(zhangwu1 zw:list){
System.out.println(zw);
}
Scanner sc=new Scanner(System.in);
System.out.println("请输入大于11小于16的整数");
int i=sc.nextInt();
for(int j=0;j<list.size();j++){
zhangwu1 item=list.get(j);
if(item.getId()==i){
System.out.println(item.getId()+" "+item.getFlname()+" "+item.getMoney());
}

}
sc.close();
}

}