在做项目中有这样一个问题:在前台输入sql语句,传入后台后获得数据,将数据绑定在datagrid上显示。
这个问题困扰我很久,因为如果是传入sql语句的话,很难确定是哪个表,也不好确定到底有多少列,所以无法使用实体类来获得数据,解析sql语句的话……..太不现实了。但是如果单纯使用resultset来传递,又太散列了,所以最后决定用ArrayList<Map<String,String>>
来获取经sql语句执行后获得的数据,其中,arraylist中有6个map,每个map是一条数据记录:
{
"id":"6","typecode":"PA","codename":"普通职工","typename":"权限分配","code":"0"},
{
"id":"7","typecode":"PA","codename":"组长","typename":"权限分配","code":"1"},
{
"id":"8","typecode":"PA","codename":"管理员","typename":"权限分配","code":"2"},
{
"id":"9","typecode":"TG","codename":"一组","typename":"所属组","code":"0"},
{
"id":"10","typecode":"TG","codename":"二组","typename":"所属组","code":"1"},
{
"id":"11","typecode":