表格数据存储

一：Map和List结合存储整张表格

/**
* 测试表格数据的存储
* 每一行数据使用一个：Map
* 整个表格使用一个：List
* ORM思想：对象关系映射
* ORM思想的简单实现：Map表示一行数据，多行数据放入List
*/
public class TestStoreData {
    public static void main(String[] args) {
        //每一行数据使用一个：Map
        Map<String,String> row1 = new HashMap<>();
        row1.put("id","1001");
        row1.put("name","张三");
        row1.put("salary","20000");
        row1.put("入职日期","2018.5.5");

        Map<String,String> row2 = new HashMap<>();
        row2.put("id","1002");
        row2.put("name","李四");
        row2.put("salary","30000");
        row2.put("入职日期","2015.4.4");

        Map<String,String> row3 = new HashMap<>();
        row3.put("id","1003");
        row3.put("name","王五");
        row3.put("salary","40000");
        row3.put("入职日期","2016.6.8");
        //整个表格使用一个：List
        List<Map<String, String>> table1 = new ArrayList<>();

        table1.add(row1);
        table1.add(row2);
        table1.add(row3);

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

二：javabean和List结合存储整张表格

/**
* 测试表格数据的存储
* 每一行数据使用一个：Map
* 整个表格使用一个：List
* ORM思想：对象关系映射
* ORM思想的简单实现：Map表示一行数据，多行数据放入List
*/
public class TestStoreData {
    public static void main(String[] args) {
        //每一行数据使用一个：Map
        Map<String,String> row1 = new HashMap<>();
        row1.put("id","1001");
        row1.put("name","张三");
        row1.put("salary","20000");
        row1.put("入职日期","2018.5.5");

        Map<String,String> row2 = new HashMap<>();
        row2.put("id","1002");
        row2.put("name","李四");
        row2.put("salary","30000");
        row2.put("入职日期","2015.4.4");

        Map<String,String> row3 = new HashMap<>();
        row3.put("id","1003");
        row3.put("name","王五");
        row3.put("salary","40000");
        row3.put("入职日期","2016.6.8");
        //整个表格使用一个：List
        List<Map<String, String>> table1 = new ArrayList<>();

        table1.add(row1);
        table1.add(row2);
        table1.add(row3);

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