当前位置:文档之家› 两个数组进行比较并去重

两个数组进行比较并去重


import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;


public class main {
public void check() throws Exception
{
String sql="select * from meet";
JDBC jdbc = new JDBC();
ResultSet rs = jdbc.select(sql);
//Object[][] data1 = getDataArray(rs,1);
//Object[][] data2 = getDataArray(rs,2);
//printArray(data1,data2);
List list1=getList(rs,1);
List list2=getList(rs,2);
printList(list1,list2);

rs.close();
}

private static List getList(ResultSet rs,int times) throws Exception {
List list = new LinkedList();
rs.first();
rs.previous();
while (rs.next()) {
Map map = new HashMap();
if (times==1)
{
map.put("tid",rs.getString("tid"));
map.put("uid",rs.getString("uid"));
}
else{
map.put("tid",rs.getString("uid"));
map.put("uid",rs.getString("tid"));
}
list.add(map);
}
return list;
}

private static void printList(List list1,List list2)
{
//list1.addAll(list2);
//System.out.println(list1.size());
// System.out.println(list1);
// System.out.println(list2);
//HashSet h = new HashSet(list1);

///list1.clear();

//list1.addAll(h);
//System.out.println(list1);
for ( int i = 0 ; i < list1.size() - 1 ; i ++ ) {

for ( int j = list1.size() - 1 ; j > i; j -- ) {

if (list1.get(j).equals(list1.get(i))) {

//System.out.println("first remove="+list1.get(j));
list1.remove(j);

}
if (list2.get(j).equals(list2.get(i))) {

//System.out.println("first remove="+list1.get(j));
list2.remove(j);

}

}

}
//System.out.println("first times="+list1.size());
// System.out.println(list1);
// System.out.println(list2);
for ( int i = 0 ; i < list1.size() - 1 ; i ++ ) {

for ( int j = list1.size() - 1 ; j > 0; j -- ) {
//System.out.println("list1"+list1.get(j));
//System.out.println("list2"+list2.get(i));
if (list1.get(j).equals(list2.get(i))) {

//System.out.println("seconds remove="+list1.get(i));
list1.remove(j);
list2.remove(i);

}

}

}

System.out.println("seconds times="+list1.size());
//for ( int i = 0 ; i < list1.size() - 1 ; i ++ ) {
// System.out.println(list1.get(i));
//}
// System.out.println(list2);

}



public static void main(String[] args) throws Exception{
new main().check();


}
}

相关主题
文本预览
相关文档 最新文档