?? z_sortitem.jsp
字號:
<td width="33%"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0" height="120">
<tr>
<td height="179" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"> </td>
</tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" height="151">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/z_list2.gif" width="140" height="23" usemap="#Map" border="0"></td>
</tr>
</table>
<form name=theform method=post action="z_sortItem.jsp">
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<td colspan="2" bgcolor="#d9d8dc"></td>
</tr>
<tr>
<td bgcolor="#d9d8dc" colspan="2" align="center">
<p> </p>
</td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" width="25%"><font color="#000099">選擇項目類別</font></td>
<td>
<select name=Sort onChange="JavaScript:showSubOpt(OptSort,this,theform.SubSort)" style="WIDTH:200px">
<option selected value="0000">---請選擇---</option>
<script language="javascript">showMainOpt(OptSort);</script>
</select>
<select name=SubSort style="WIDTH:200px">
<option selected value="0000">---請選擇---</option>
</select>
</td>
</tr>
<tr>
<td bgcolor="#d9d8dc" align="center" colspan="2"> </td>
</tr>
<tr bgcolor="#d9d8dc" align="center">
<td colspan="2">
<input type=image src="../images/refer.gif" width="62" height="22" name="refer">
</td>
</tr>
</table>
</form>
<font size="2" color="#000099">按* <script language="javascript">showSort(OptSort,"<%=sort%>");</script>*<%=str%>查詢</font><br>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
<tr>
<td width="36%" bgcolor="#d9d8dc"><font size="2" color="#000099">項目名稱</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">專家一</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">專家二</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">專家三</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">專家四</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">專家五</font></td>
<td width="8%" align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">通過數</font></td>
<td align="center" bgcolor="#d9d8dc" width="8%"><font size="2" color="#000099">總分</font></td>
<td align="center" bgcolor="#d9d8dc"><font size="2" color="#000099">平均分</font></td>
</tr>
<%
String ssum="";
String savg="";
if (intPageCount>0)
{
for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next();
for(i=1;i<=pageLine;i++){
if(rs.next()){
String itemID=rs.getString("itemID");
String item_name=rs.getString("item_name");
String sql2="select sum(score6) as ssum,avg(score6) as savg from I_distribute where itemID='"+itemID+"' and score6>0";
ResultSet rs2=z_sortItem.executeQuery(sql2);
if(rs2.next())
{
ssum=rs2.getString("ssum");
savg=rs2.getString("savg");
if(ssum==null){ ssum=" ";}
if(savg==null){ savg=" ";}
else { savg=savg.substring(0,4);}
}
String expert[]={" "," "," "," "," "};
int k=0;
String sql3="select score6 from I_distribute where itemID='"+itemID+"'";
ResultSet rs3=z_sortItem.executeQuery(sql3);
while(rs3.next())
{
expert[k]=rs3.getString("score6");
if(expert[k]==null){ expert[k]=" ";}
k++;
}
String cMind="";
String sql4="select count(mind) as cMind from I_distribute where itemID='"+itemID+"' and mind='資助'";
ResultSet rs4=z_sortItem.executeQuery(sql4);
if(rs4.next()){ cMind=rs4.getString("cMind");}
%>
<tr>
<td><font size="2" color="#000099"><%=item_name%> </font></td>
<td align="center"><font size="2" color="#000099"><%=expert[0]%></font></td>
<td align="center"><font size="2" color="#000099"><%=expert[1]%></font></td>
<td align="center"><font size="2" color="#000099"><%=expert[2]%></font></td>
<td align="center"><font size="2" color="#000099"><%=expert[3]%></font></td>
<td align="center"><font size="2" color="#000099"><%=expert[4]%></font></td>
<td align="center"><font size="2" color="#000099"><%=cMind%></font></td>
<td align="center"><font size="2" color="#000099"><%=ssum%></font></td>
<td align="center"><font size="2" color="#000099"><%=savg%></font></td>
</tr>
<%
}
}
}
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#d9d8dc">
<td colspan="3" bgcolor="#d9d8dc"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<%
out.print("<tr>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='post' name=fPageNum action='z_sortItem.jsp?SubSort="+sort+"'>");
out.print("<p align='left'><font color='#000099'> 分頁</font> ");
if(intPage<2)
out.print("<font color='#000099'>首頁 上一頁 </font>");
else{
out.print("<a href='z_sortItem.jsp?page=1&&SubSort="+sort+"'><font color='#000099'>首頁</font></a> ");
out.print("<a href='z_sortItem.jsp?page="+(intPage-1)+"&&SubSort="+sort+"'><font color='#000099'>上一頁</font></a> ");
}
if(intPage-intPageCount>=0)
out.print("<font color='#000099'> 下一頁 尾頁</font>");
else{
out.print("<a href='z_sortItem.jsp?page="+(intPage+1)+"&&SubSort="+sort+"'><font color='#000099'>下一頁</font></a> <a href='z_sortItem.jsp?page="+intPageCount+"&&SubSort="+sort+"'><font color='#000099'>尾頁</font></a>");
}
out.print(" <font color='#000099'>頁次</font>：<strong><font color='#000099'>"+intPage+"/"+intPageCount+"</font></strong><font color='#000099'>頁</font>");
out.print(" <font color='#000099'>共</font><b><font color='#000099'>"+totalRec+"</font></b><font color='#000099'>個項目</font><b><font color='#000099'>"+pageLine+"</font></b><font color='#000099'>條/頁</font>");
out.print("<font color='#000099'>轉到第</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("<font color='#000099'>頁</font><input class=buttonface type='submit' value='GO' name='cndok'></span></p></form>");
out.print("</td>");
out.print("</tr>");
%>
<tr align="center">
<td bgcolor="#d9d8dc" colspan="3"><input onClick=javascript:window.print(); type=image src="../images/print.gif" width="62" height="22">
<INPUT onclick=javascript:window.close(); type=image src="../images/close.gif" width="62" height="22"></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<map name="Map">
<area shape="rect" coords="1,1,69,22" href="z_item.jsp?SubSort=0000">
</map>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -