?? query_stu_mn.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="jinghua.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=true;
String studentID="";
String gradenote="";
String gradename="";
Statement stmt=null;
ResultSet rs=null;
String sql="";
String sqlCon=null;
int testNumber=0;
int EveryPage=5;//每頁顯示的記錄數(shù)；
int OnPage=1; //當(dāng)前顯示的頁數(shù)；
int Total=0;//記錄的總數(shù)；
int TotalPage=0;//記錄的總頁數(shù)；
%>
<%
try{
studentID=(String)session.getAttribute("studentID");
if(studentID==null){
throw new Exception();
}
}catch(Exception e){
Tools.showalert("您還沒有登錄，或連接超時(shí)，請重新登錄!",out);
Tools.showJS("window.open('../login.jsp','_self')",out);
}
try{
con=DBCon.getConnection();
//獲取學(xué)生的年級信息
sql=" SELECT `grade`.`Name`, `grade`.`note` FROM"+
" `grade` INNER JOIN `UserInfo` ON (`grade`.`note` = `UserInfo`.`gradenote`)"+
" WHERE (`UserInfo`.`vcUserNo` = '"+studentID+"')";
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
gradenote=rs.getString("note");
gradename=rs.getString("Name");
rs.close();
stmt.close();
}
if(debug){
out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
}
}
catch(SQLException se){
out.print("<br> query grade error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query grade error sql="+sql);
out.print("<br>"+e.toString());
}
//查詢學(xué)生所屬年級的錯(cuò)題
%>
<%
//構(gòu)造查詢條件
//String errorpad_grade=(String)session.getAttribute("errorpad_grade");
//String errorpad_sub=(String)session.getAttribute("errorpad_sub");
//String errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
//String errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
//String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
sqlCon="";
String errorpad_grade=request.getParameter("Grade");
String errorpad_sub=request.getParameter("Subject");
String errorpad_knowpoint=request.getParameter("KnowPoint");
String errorpad_testtype=request.getParameter("testtype");
String errorpad_errorcount=request.getParameter("errorcount");
if(debug){
out.print("<br>grade="+errorpad_grade+
"<br>sub="+errorpad_sub+
"<br>knowpoint="+errorpad_knowpoint+
"<br>testtype="+errorpad_testtype+
"<br>errorcunt="+errorpad_errorcount);
}
if(errorpad_grade!=null)
{
session.setAttribute("errorpad_grade",errorpad_grade);
}
else
{
errorpad_grade=(String)session.getAttribute("errorpad_grade");
}
if(errorpad_sub!=null)
{
session.setAttribute("errorpad_sub",errorpad_sub);
}else
{
errorpad_sub=(String)session.getAttribute("errorpad_sub");
}
if(errorpad_knowpoint!=null)
{
session.setAttribute("errorpad_knowpoint",errorpad_knowpoint);
}
else
{
errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
}
if(errorpad_testtype!=null)
{
session.setAttribute("errorpad_testtype",errorpad_testtype);
}
else
{
errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
}
if(errorpad_errorcount!=null)
{
session.setAttribute("errorpad_errorcount",errorpad_errorcount);
}
else
{
errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
}
if(errorpad_grade==null)
errorpad_grade="all";
if(errorpad_sub==null)
errorpad_sub="all";
if(errorpad_knowpoint==null)
errorpad_knowpoint="all";
if(errorpad_testtype==null)
errorpad_testtype="all";
if(errorpad_errorcount==null)
errorpad_errorcount="0";
if(errorpad_grade!=null){
if(!errorpad_grade.equals("all")){
if(errorpad_grade.equals("c")){
sqlCon="(question.gradenote='c1' OR question.gradenote='c2' OR question.gradenote='c3')";
}else if(errorpad_grade.equals("g")){
sqlCon="(question.gradenote='g1' OR question.gradenote='g2' OR question.gradenote='g3')";
}
else
sqlCon="(question.gradenote='"+errorpad_grade+"')";
}
}
if(debug)
out.println("<br>grade sql="+sqlCon);
if(errorpad_sub!=null){
if(!errorpad_sub.equals("all")){
if (!sqlCon.equals(""))
sqlCon=sqlCon +" AND (question.SubjectID="+errorpad_sub+")";
else
sqlCon=" (question.SubjectID="+errorpad_sub+")";
}
}
if(debug)
out.println("<br>subject sql="+sqlCon);
if(errorpad_knowpoint!=null){
if(!errorpad_knowpoint.equals("all")){
if(!sqlCon.equals(""))
sqlCon=sqlCon+" AND(question.KnowPointID1="+errorpad_knowpoint +
" OR question.KnowPointID2="+errorpad_knowpoint+
" OR question.KnowPointID3="+errorpad_knowpoint+")";
else
sqlCon=" (question.KnowPointID1="+errorpad_knowpoint +
" OR question.KnowPointID2="+errorpad_knowpoint+
" OR question.KnowPointID3="+errorpad_knowpoint+")";
}
}
if(debug)
out.println("<br>knowpoint sql="+sqlCon);
if(errorpad_testtype!=null){
if(!errorpad_testtype.equals("all")){
if(!sqlCon.equals(""))
sqlCon=sqlCon+ " AND(errorpad.sourcetype="+errorpad_testtype+")";
else
sqlCon= " (errorpad.sourcetype="+errorpad_testtype+")";
}
}
if(debug)
out.println("<br>testtype sql="+sqlCon);
if(errorpad_errorcount!=null){
if(!sqlCon.equals(""))
sqlCon=sqlCon+ " AND(errorpad.errorcount>="+errorpad_errorcount+")";
else
sqlCon=" (errorpad.errorcount>="+errorpad_errorcount+")";
}
if(debug)
out.println("<br>errorcount sql="+sqlCon);
sqlCon="(`errorpad`.`stu_id` = 's11')"+" AND"+sqlCon;
//查詢滿足條件的錯(cuò)題
sql="SELECT `errorpad`.`id`, `errorpad`.`question_id`, `question`.`QuestText`, DATE_FORMAT( `errorpad`.`add_date`,\"%Y-%m-%e %H:%i:%S\") AS add_date, "+
" `errorpad`.`errorcount`, ELT(`errorpad`.`sourcetype`,\"自由測試\",\"自由單元測試\",\"模擬考試\") as sourcename, "+
" `grade`.`Name` AS `gradename`"+
" FROM `errorpad`"+
" LEFT OUTER JOIN `question` ON (`errorpad`.`question_id` = `question`.`ID`)"+
" LEFT OUTER JOIN `grade` ON (`question`.`gradenote` = `grade`.`note`)"+
" WHERE "+sqlCon+
" ORDER BY `errorpad`.`add_date` ASC";
session.setAttribute("errorpad_sqlcon",sqlCon);
session.setAttribute("errorpad_sql",sql);
if(debug)
out.println("<br>at last sql="+sql);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
//rs.last();//移到最后一條記錄;
//Total=rs.getRow();//記錄的總數(shù)；
//TotalPage=(Total%EveryPage==0)?(Total/EveryPage):(Total/EveryPage+1);
%>
<!--年級，科目，知識(shí)點(diǎn)三個(gè)下拉列表框聯(lián)動(dòng)-->
<%
out.print(Tools.sub_know(con));
out.print(Tools.grade_sub(con));
%>
<script language="JavaScript">
function changegs(locationid){
document.myform.Subject.length =1;
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gscount; i++){
if (grade_sub[i][0] == locationid) {
document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
}
}
}
function changesk(locationid){
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gskcount; i++){
if (grade_sub_know[i][1] == locationid){
document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
}
}
}
function delit(myform)
{
if (confirm("將刪除所有選擇的知識(shí)點(diǎn)數(shù)據(jù)？"))
{
myform.action="errorpaddel.jsp";
myfrom.target="_self";
myform.submit();
}
}
function del_check()
{
var count = errorpad.elements.length;
var noSelect = true;
for(var i=0;i<count;i++)
{
if(errorpad.elements[i].checked)
{
noSelect = false;
break;
}
}
if(noSelect == true)
{
alert("您還沒有選擇要?jiǎng)h除的錯(cuò)題!");
return(false);
}
else
{
if(confirm("將刪除所有選擇的錯(cuò)題嗎？"))
{
document.errorpad.method = "POST";
document.errorpad.action = "errorpad_del.jsp";
document.errorpad.target="_self";
document.errorpad.submit();
}
else
{
document.form3.method = "GET";
document.form3.action = "";
}
}
return false;
}
function addrate_check()
{
var count = errorpad.elements.length;
var noSelect = true;
for(var i=0;i<count;i++)
{
if(errorpad.elements[i].checked)
{
noSelect = false;
break;
}
}
if(noSelect == true)
{
alert("您還沒有選擇要增加錯(cuò)誤級別的錯(cuò)題!");
return(false);
}
else
{
if(confirm("增加所有選擇的錯(cuò)題的錯(cuò)誤級別嗎？"))
{
document.errorpad.method = "POST";
document.errorpad.action = "errorpad_addrate.jsp";
document.errorpad.target="_self";
document.errorpad.submit();
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -