int row [] =table.getSelectedRows();//你选中的所有行数
String id[]=new String[row.length];
for(int temp=0;temp<row.length;temp++){
id[temp]=tableModel.getValueAt(row[temp],0).toString();
}
String sql="select * from exam where id in (";
for (int i = 0; i < id.length; i++) {
if(i==id.length-1){
sql+=id[i];
break;
}
sql+=id[i]+",";
}
System.out.println(sql+")");
Java中SQL遇到字段in条件的解决方法
最新推荐文章于 2024-08-09 23:23:34 发布