从表格复制整列到Java代码中，然后replace rn为','，就可以将列数据逗号分隔
public class transform_test {
public transform_test() {
}
public static void main(String[] args) {
String str = "1200451n1200456n1200555n1200599n1200603n1200715n1200787n1200791n1200795n1201047n1201052n1201055n1201342n1201347n1201351n1201444n1201446n1201499n1201523n1201623n1201627n1201707n1201712n1201841n1201893n1201933n1202249n1202255n1202261n1202266n1202299n1202304n1202499n1202503n1202531n1202634n1202690n1202798n1202805n1202930n1203199n1203335n1203412n1203531n1203609n1203637n1203647n1203677n1203769n1204074n1206661n1206662n1206668n1206669n1206671n1206677n1206678n1206680n1206682n1206686n1206688n1206690n1206697n1206703n1206707n1206711n1206716n1206718n1206722n1206736n1206743n1206745n1206749n1206752n1206768n1206772n1206778n1206780n1206791n1206795n1206803n1206809n1206813n1206826n1206831n1206833n1206838n1206842n1206846n1206859n1206866n1206870n1206879n1206888n1206898n1206906n1208308n1208312n1208317n1208321n";
str = str.replaceAll("(rn|n)", ",");
System.out.println(str);
}
}
可将逗号分隔的数据用于SQL查询
select ... task_id in (1200451,1200456,1200555,1200599,1200603,1200715,1200787,1200791,1200795,1201047,1201052,1201055,1201342,1201347,1201351,...)
