📄 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 + -