9月1号

来源：互联网发布：淘宝家政服务平台编辑：程序博客网时间：2024/04/28 06:46

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

0 0