用户说加急,催技术!
运营说加急,催技术!
产品说加急,催技术!
有人相爱
有人夜里看海
有人数组推荐第一题都做不出来!
你设计好的动态选择城市,用户非要非法输入,到最后走不下去流程,三端改数据,你设计好的流程,用户非要非法操作,哎~有流程不走,我就拖着,我就是玩儿~
60多条数据批量修改,虽然不多,但CV起来还是恶心心
Excel批量导出SQL
幸好是有这功能,要不我导出demo都写一半了
public static void main(String[] args) throws IOException {
String text = FileUtils.readFileToString(new File("C:\\Users\\Administrator\\Desktop\\a.txt"));
text.replaceAll("\n","");
final String[] split = text.split(",");
List<LUser> list = new ArrayList<>();
for (String s : split) {
s.replaceAll("\r|\n", "");
// String msg="update detail set userId='' where mobile=11111111130 and userName='%s';";
//final String format = String.format(msg, s);
// System.out.println(format);
}
String b = FileUtils.readFileToString(new File("C:\\Users\\Administrator\\Desktop\\b.txt"));
b.replaceAll("\n","");
final String[] splitb = b.split(",");
LUser lUser = new LUser();
for (String bs : splitb) {
bs.replaceAll("\r|\n", "");
final String format = String.format(msg,bs,s);
System.out.println(format);
lUser.setMobile1(bs);
lUser.setUserName(s);
//System.out.println(bs);
break;
}
/*
final String[] splitb = b.split(",");
for (String s : splitb) {
final String format = String.format(msg, s);
System.out.println(format);
}*/
}
@Data
static
class LUser{
private String mobile1;
private String userName;
private String mobile2;
}
主要是占位符拷来拷去
打开Excel,选择最后一行空格,输入函数
注意整条函数语句应该用""包含,前面有=,且在变量取值时string为单引号''包围,且变量有"",语句以;结尾,如下
="update p_detail set mobile='"&D1&"' where mobile='"&E1&"' and userName='"&C1&"';"
回车,点击行末尾+号,向下拖动,或者快捷键Ctrl+↓
选中生成sql导出,复制到执行器
搞定~