用容器存储表格数据

了解ORM思想，为以后操作表数据提前打下基础

表格模板

|---表格数据存储_map和list结合存储整张表
|------表格数据存储_Map和_List结合
|--------每一行数使用一个Map；整个表格使用一个List
ORM思想：对象关系映射

package boom.collection;

import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * 测试用容器表格数据的存储
 * @author Administrator
 *
 */
public class TestStoreData {

    public static void main(String[] args) {
        
        Map<String, Object> row1 = new HashMap<>();
        
        row1.put("id", "1001");
        row1.put("姓名", "张三");
        row1.put("薪水", "20000");
        row1.put("入职日期", "2018.9.6");
        
        Map<String, Object> row2 = new HashMap<>();
        row2.put("id", "1002");
        row2.put("姓名", "李四");
        row2.put("薪水", "5000");
        row2.put("入职日期", "2019.5.9");
        
        Map<String, Object> row3 = new HashMap<>();
        row3.put("id", "1003");
        row3.put("姓名", "王五");
        row3.put("薪水", "30000");
        row3.put("入职日期", "2010.8.3");
        
        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) + "	");
            }
            System.out.println();
        }
    }

}

|----表格数据存储_javabean和list结合存储整张表
|------每一行数据使用一个：javabean对象；整个表格用一个Map / List
用户类：javabean

/**
 * 完整的javabean[setter和getter方法，无参构造器]
*/
class User{
    private int id;
    private String name;
    private double salary;
    private String data;

    public User() {
    }

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

    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 getData() {
        return data;
    }

    public void setData(String data) {
        this.data = data;
    }
    @Override
    public String toString() {
        return "id:" + id + "  name:" + name + "  salary:" + salary + "  data:" + data;
    }
}

测试类：

User user1 = new User(1001, "张三", 50000, "2018.2.5");
User user2 = new User(1002, "李四", 18000, "2018.9.5");
User user3 = new User(1003, "王五", 15000, "2018.5.5");

List<User> list = new ArrayList<>();
list.add(user1);
list.add(user2);
list.add(user3);

for (User u : list) {
    System.out.println(u);
}

System.out.println("------------------------------------------------");

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));
}

效果图：