java.sql.Statement stmt=null;
java.sql.ResultSet rs=null]
java.sql.ResultSet rs=null.
%>;
String sqlu="SELECT t1.fno, t1.fname, t2.fname AS fdept FROM tuser t1 LEFT OUTER JOIN TDept t2 ON t1.fdept = t2.fno order by t. 🎜> stmt=conn.createStatement();
rs=stmt.executeQuery(sqlu);
%>
while(rs.next())
{ %>
arr[]=new Array(" ","");
temp = temp 1;
}
%>
temp=;
function ChangeLocation(id){
document.combo_box.city.length=0; //初始化第二層選單的長度,下標從0開始
var i = 0;
document.combo_box.city.options[0]=new Option(-------,);
for(i=0;i
document.combo_box. city.options[document.combo_box.city.length] = new Option(arr[i][0], arr[i][0] );
}
}
}
}
}
}
> }
}
> }
}
> script>