sql= "select * from weightbetweenusers WHERE source ='"+rnList.get(i).getName() +"' AND target='"+rnList.get(j).getName() +"'";

rs = stmt.executeQuery(sql);

//원래 것으로 있다.

if(rs.next()){

sql ="UPDATE weightbetweenusers SET weightbetweenusers.structuraldissimilarity="+dissimMatx[i][j]+" WHERE source ='"+rnList.get(i).getName() +"' AND target='"+rnList.get(j).getName() +"'";

stmt.executeUpdate(sql);

}else{

//타겟 소스 바꿔서

sql= "select * from weightbetweenusers WHERE target ='"+rnList.get(i).getName() +"' AND source='"+rnList.get(j).getName() +"'";

rs = stmt.executeQuery(sql);

if(rs.next()){

sql ="UPDATE weightbetweenusers SET weightbetweenusers.structuraldissimilarity="+dissimMatx[i][j]+" WHERE target ='"+rnList.get(i).getName() +"' AND source='"+rnList.get(j).getName() +"'";

stmt.executeUpdate(sql);

}else{

for(int k=0;k<10;k++){

System.out.println("There is not that row~!!");

}

}

}

asdf

/*try {

Statement stmt = sdc.getConnection().createStatement();

ResultSet rs = stmt.executeQuery("select screenName from twitteruser");

ArrayList screenNameList = new ArrayList();

while(rs.next()){

screenNameList.add(rs.getString(1));

}

for(int i=0;i

for(int j=i+1;j

stmt.executeUpdate("insert weightbetweenusers(source,target) values('"+screenNameList.get(i)+"','"+screenNameList.get(j) +"')");

}

}

stmt.close();

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

*/

ㅇㅇㅇ