ㅁㄴㅇㄹ

으아 mention이다 이건.

try{

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

ResultSet rs = stmt.executeQuery("select TweetID, creatingat from tweet");

ArrayList[String] creatingAtList = new ArrayList[String]();

while(rs.next()){

if(elapsedDay("2010-8-1 21:20:12",rs.getString(2))[0 ||elapsedDay("2010-8-1 21:20:12",rs.getString(2))]83){

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

}

}

rs.close();

stmt.close();

System.out.println("로딩완료" + creatingAtList.size());

//retweet 지우기.

PreparedStatement pstmtReTweet=sdc.getConnection().prepareStatement("delete from retweet where TweetID=?");

//mention 지우기.

PreparedStatement pstmtMention=sdc.getConnection().prepareStatement("delete from mention where TweetID=?");

//tweet 지우기.

PreparedStatement pstmtTweet=sdc.getConnection().prepareStatement("delete from tweet where TweetID=?");

for(int i=0;i[creatingAtList.size();i++){

// Retweet을 지운다.

pstmtReTweet.setString(1, creatingAtList.get(i));

pstmtReTweet.executeUpdate();

//Mention을 지운다.

pstmtMention.setString(1, creatingAtList.get(i));

pstmtMention.executeUpdate();

//Tweet을 지운다.

pstmtTweet.setString(1, creatingAtList.get(i));

pstmtTweet.executeUpdate();

System.out.println(i+"번째 자료 지움");

}

pstmtReTweet.close();

pstmtMention.close();

pstmtTweet.close();

}catch(Exception e){

}

SK_Tworld

Wonjoo

Yoo_Hee

ehkwon

fineglow

happynho

hongkee67

hurimin

hwashinmoon

hyosungkang

icsong

insu82

jakeoh81

noowgnak

rockmkd

rubylime

simishim

ukjang

yth7272