java循环问题求解?谢谢各位啦!
public static void main(String args[]) {
String sql = "select * from [File] where Is_Send=1";
byte[] byteArray=null;
for(;;){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String s = "jdbc:odbc:test";
Connection con = DriverManager.getConnection(s,"sa","88888");
Statement stmt = con.createStatement();
Connection con1 = DriverManager.getConnection(s,"sa","88888");
Statement stmt1 = con1.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while ( rs.next()) {
int ID=rs.getInt("ID");
byteArray=rs.getBytes("File_Bit");
senderID = rs.getString("SendID");
recipientID = rs.getString("ReceiveID");
targetType = rs.getString("MobileType");
smil = readfile(smilName);
gif = byteArray;
doUpload();
strSQL = "update [File] set Is_Send=0 where ID="+ID+"";
System.out.println(strSQL);
stmt1.executeUpdate(strSQL);
System.out.println("OK!!");
}
rs.close();
stmt.close();
stmt1.close();
con1.close();
con.close();
}
catch(Exception e)
{
System.out.println("error!!!!");
}
我这个程序的for循环太占CPU资源了,我想让它没有发现新记录时休息5秒,应该如何做呢?