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