?? z_scorecheck.jsp
字號:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
String z_Loginmessage=(String)session.getValue("z_loginSign");
String adminID=(String)session.getValue("adminID");
if(z_Loginmessage!="OK")
{
response.sendRedirect("index4.jsp");
}
%>
<jsp:useBean id="z_sortItem" scope="page" class="firm.firm"/>
<%
String sort=request.getParameter("SubSort");
String subSort1=sort.substring(0,2);
String subSort2=sort.substring(2,4);
String str="";
String sql="";
String sql1="";
if(sort.compareTo("0000")==0){
sql="select * from I_s_item as x order by (select sum(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*)as cnt from I_s_item";
str="全部";
}
else if(subSort2.compareTo("00")==0){
sql="select * from I_s_item as x where sort1 like '"+subSort1+"__"+"' or sort2 like '"+subSort1+"__"+"' order by (select sum(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*)as cnt from I_s_item where sort1 like '"+subSort1+"__"+"' or sort2 like '"+subSort1+"__"+"'";
str="總類";
}
else{
sql="select * from I_s_item as x where sort1='"+sort+"' or sort2='"+sort+"' order by (select sum(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*)as cnt from I_s_item where sort1='"+sort+"' or sort2='"+sort+"'";
str="分類";
}
ResultSet rs=z_sortItem.executeQuery(sql);
int pageLine=20;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
ResultSet countrs=z_sortItem.executeQuery(sql1);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
z_sortItem.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%>
<html>
<head>
<title>項目設置</title>
<style>
<!--
:link {color:#000099}
:visited {color:#000099}
:active {color:#000099}
A:link,A:visited,A:active {text-decoration:none}
//-->
</style>
<SCRIPT language=javascript>
<!--
OptSort = new Array(
"0100","哲學",
"0101","哲學",
"0200","經濟學",
"0201","理論經濟學",
"0202","應用經濟學",
"0300","法學",
"0301","法學",
"0302","政治學",
"0303","社會學",
"0304","民族學",
"0400","教育學",
"0401","教育學",
"0402","心理學",
"0403","體育學",
"0500","文學",
"0501","中國語言文學",
"0502","外國語言文學",
"0503","新聞傳播學",
"0504","藝術學",
"0600","歷史學",
"0601","歷史學",
"0700","理學",
"0701","數學",
"0702","物理學",
"0703","化學",
"0704","天文學",
"0705","地理學",
"0706","大氣科學",
"0707","海洋科學",
"0708","地球物理學",
"0709","地質學",
"0710","生物學",
"0711","系統科學",
"0712","科學技術史",
"0800","工學",
"0801","力學",
"0802","機械工程",
"0803","光學工程",
"0804","儀器科學與技術",
"0805","材料科學與工程",
"0806","冶金工程",
"0807","動力工程及工程熱物理",
"0808","電氣工程",
"0809","電子科學與技術",
"0810","信息與通信工程",
"0811","控制科學與工程",
"0812","計算機科學與技術",
"0813","建筑學",
"0814","土木工程",
"0815","水利工程",
"0816","測繪科學與技術",
"0817","化學工程與技術",
"0818","地質資源與地質工程",
"0819","礦業工程",
"0820","石油與天然氣工程",
"0900","農學",
"0901","作物學",
"0902","園藝學",
"0903","農業資源利用",
"0904","植物保護",
"0905","畜牧學",
"0906","獸醫學",
"0907","林學",
"0908","水產",
"1000","醫學",
"1001","基礎醫學",
"1002","臨床醫學",
"1003","口腔醫學",
"1004","公共衛生與預防醫學",
"1005","中醫學",
"1006","中西醫結合",
"1007","藥學",
"1008","中藥學",
"1100","軍事學",
"1101","軍事",
"1200","管理學",
"1201","管理科學與工程",
"1202","工商管理");
function showMainOpt()
{
var i,start,step,len,a,args=showMainOpt.arguments;
a = args[0];
len = a.length;
start = (args.length>=2)?args[1]:0;
step = 2;
for(i=start;i<len;i+=step)
{
if(a[i].substr(a[i].length-2) == "00")
document.writeln("<option value="+a[i]+">"+a[i+1]+"</option>");
}
}
function showSubOpt()
{
var i,len,start,step,s1,s2,a,args=showSubOpt.arguments;
var mainVal,val,name;
a=args[0];
s1=args[1];
s2=args[2];
start=0;
step=2;
IsAll = (args.length>=4)?args[3]:false;
len=a.length;
mainVal=s1.options[s1.selectedIndex].value;
mainVal=mainVal.substr(0,2);
for(i=s2.length-1;i>=0;i--)
{
s2.options[i]=null;
}
if(Number(mainVal)!=0)
{
for(i=start;i<len;i+=step)
{
val = a[i];
name = a[i+1];
if(val.substr(0,2)==mainVal)
{
if(val.substr(val.length-2) == "00")s2.options[s2.length]=new Option("全部",val,false,false);
else s2.options[s2.length]=new Option(name,val,false,false);
}
}
}
}
function showSort()
{
var i,len,start,step,s1,a,args=showSort.arguments;
var name;
a=args[0];
s1=args[1];
start=0;
step=2;
len=a.length;
for(i=0;i<len;i+=step)
{
if(a[i]==s1)
{
name=a[i+1];
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -