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