9月1号

1： mysql更新多行多条数据

UPDATE Map_Tag  SET TagName = CASE code WHEN 'S00003' THEN '测121111' WHEN 'S00004' THEN '1222222'  END WHERE code IN ('S00003','S00004')

或者这样写

UPDATE Map_Tag 
SET TagName = CASE code 
WHEN 'S00003' THEN '测121111' 
WHEN 'S00004' THEN '1222222'  
END WHERE code IN ('S00003','S00004')

在java里面这样写

String sql = "UPDATE Map_Tag  SET TagName = CASE code ";
                for (int i = 0; i < str.length; i++) {
                    sql = sql + "WHEN " + ut.change(str[i]) + " THEN " + ut.change(TagNames[i]) + " ";
                }
                sql = sql + " END WHERE code IN (";
                for (int i = 0; i < str.length - 1; i++) {
                    sql = sql + ut.change(str[i]) + ",";
                }
                sql = sql + ut.change(str[str.length - 1]) + ")";

2：mysql的左右链接

select a.code,a.TagName,b.Comment_Cn from Map_Tag as a left join Map_GlobalId as b on a.code=b._id where a.TbmId= 'CREC188'

3：easyUi的行编辑

 ary.push({field: 'TagName', title: 'PLC参数', align: 'center', width: 150, editor: {type: 'validatebox', options: {required: true}}});

双击进行编辑

onDblClickCell: function (index, field, value) {
            $(this).datagrid('beginEdit', index);
            var ed = $(this).datagrid('getEditor', {index: index, field: field});
            $(ed.target).focus();

        },