rs1 = stmt1.executeQuery("Select DISTINCT to_char(bdate,'yyyy-MM-dd') from book");
while (rs1.next()) { if (!date1.equals(rs1.getString(1))) {
continue;}
for (int k = 0; k < Array.length; k++) {
buffer = buffer + "<option value=" + Array[k] + ">" + Array[k] + "</option>";
}
}
date1是select date option value.
現在我check了一不對,就continue上去再loop,check到最後都是不對先出option value.問題是有咩方法可以令到loop完個database並check完日期先行for loop 和出option value.
while (rs1.next()) { if (!date1.equals(rs1.getString(1))) {
continue;}
for (int k = 0; k < Array.length; k++) {
buffer = buffer + "<option value=" + Array[k] + ">" + Array[k] + "</option>";
}
}
date1是select date option value.
現在我check了一不對,就continue上去再loop,check到最後都是不對先出option value.問題是有咩方法可以令到loop完個database並check完日期先行for loop 和出option value.
我想講就是現在while loop個sql ,date1和sql內 的data不符合,直至去到最後都是不符合的話,就行for loop,請問怎樣等他check完先行個for loop
rs1 = stmt1.executeQuery("Select DISTINCT to_char(bdate,'yyyy-MM-dd') from book");
int i=0;
while (rs1.next()) { if (!date1.equals(rs1.getString(1))) {
continue;
}else{
i=1;
}
for (int k = 0; k < Array.length; k++) {
buffer = buffer + "<option value=" + Array[k] + ">" + Array[k] + "</option>";
}
}
if(i==0){
for (int k = 0; k < Array.length; k++) {
buffer = buffer + "<option value=" + Array[k] + ">" + Array[k] + "</option>";
}
}