表格数据存储

1、Map和List结合

import java.util.*;

public class TestStoreData {
    public static void main(String[] args) {
        Map<String,Object> row1=new HashMap<>();
        row1.put("id",1001);
        row1.put("name","张三");
        row1.put("salary",20000);
        row1.put("data","2021.5.7");

        Map<String,Object> row2=new HashMap<>();
        row2.put("id",1002);
        row2.put("name","李四");
        row2.put("salary",30000);
        row2.put("data","2021.5.8");

        Map<String,Object> row3=new HashMap<>();
        row3.put("id",1003);
        row3.put("name","王五");
        row3.put("salary",40000);
        row3.put("data","2021.5.9");

        List<Map<String,Object>> table1=new ArrayList<>();
        table1.add(row1);
        table1.add(row2);
        table1.add(row3);

        for(Map<String,Object> row: table1){
            Set<String> keyset =row.keySet();
            for(String key:keyset){
                System.out.print(key+":"+row.get(key)+"\t");
            }
            System.out.println();
        }
    }
}

data:2021.5.7    name:张三    id:1001    salary:20000    
data:2021.5.8    name:李四    id:1002    salary:30000    
data:2021.5.9    name:王五    id:1003    salary:40000    
 

2、javabean和list/map结合

/*
每一行数据使用javabean对象存储，多行放到map或list中
 */
import java.util.*;

public class TestStoreData {
    public static void main(String[] args) {
        User user1=new User(1001,"张三",20000,"2020.5.7");
        User user2=new User(1002,"李四",30000,"2020.6.7");
        User user3=new User(1003,"王五",2000,"2020.2.7");

        List<User> list= new ArrayList<>();
        list.add(user1);
        list.add(user2);
        list.add(user3);
        for(User u:list){
            System.out.println(u);
        }

        Map<Integer,User> map=new HashMap<>();
        map.put(1001,user1);
        map.put(1002,user2);
        map.put(1003,user3);

        Set<Integer> keyset =map.keySet();
        for(Integer key:keyset){
            System.out.println(key +"==="+map.get(key));
        }



    }

}
class User{
    private int id;
    private String name;
    private double salary;
    private String hiredata;

    //一个完整的javabean.要有set和get方法，以及无参构造器
    public User(){

    }

    public User(int id, String name, double salary, String hiredata) {
        this.id = id;
        this.name = name;
        this.salary = salary;
        this.hiredata = hiredata;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public double getSalary() {
        return salary;
    }

    public void setSalary(double salary) {
        this.salary = salary;
    }

    public String getHiredata() {
        return hiredata;
    }

    public void setHiredata(String hiredata) {
        this.hiredata = hiredata;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", salary=" + salary +
                ", hiredata='" + hiredata + '\'' +
                '}';
    }
}

 User{id=1001, name='张三', salary=20000.0, hiredata='2020.5.7'}
User{id=1002, name='李四', salary=30000.0, hiredata='2020.6.7'}
User{id=1003, name='王五', salary=2000.0, hiredata='2020.2.7'}
1001===User{id=1001, name='张三', salary=20000.0, hiredata='2020.5.7'}
1002===User{id=1002, name='李四', salary=30000.0, hiredata='2020.6.7'}
1003===User{id=1003, name='王五', salary=2000.0, hiredata='2020.2.7'}