package org.apache.jsp;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class GeRenCJJG$jsp extends HttpJspBase {
// begin [file="/GeRenCJJG.jsp";from=(7,0);to=(7,59)]
// end
static {
}
public GeRenCJJG$jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=GB2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/GeRenCJJG.jsp";from=(0,52);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(1,31);to=(7,0)]
out.write("\r\n<html>\r\n<head><title>个人成绩结果</title></head>\r\n<body>\r\n<center>\r\n<h1>个人成绩查询结果</h1>\r\n");
// end
// begin [file="/GeRenCJJG.jsp";from=(7,0);to=(7,59)]
ch5_6.Data1 geren = null;
boolean _jspx_specialgeren = false;
synchronized (pageContext) {
geren= (ch5_6.Data1)
pageContext.getAttribute("geren",PageContext.PAGE_SCOPE);
if ( geren == null ) {
_jspx_specialgeren = true;
try {
geren = (ch5_6.Data1) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "ch5_6.Data1");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"ch5_6.Data1", exc);
}
pageContext.setAttribute("geren", geren, PageContext.PAGE_SCOPE);
}
}
if(_jspx_specialgeren == true) {
// end
// begin [file="/GeRenCJJG.jsp";from=(7,0);to=(7,59)]
}
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(7,59);to=(8,0)]
out.write("\r\n");
// end
// begin [file="/GeRenCJJG.jsp";from=(8,2);to=(14,36)]
String xh,xm,sql;
xh = request.getParameter("xh");
if(xh!=null) xh= xh.trim(); else xh="";
xm = request.getParameter("xm");
xm = new String(xm.getBytes("ISO8859-1")); //对xm进行规范
if(xm!=null) xm= xm.trim(); else xm="";
if(xh.equals("") && xm.equals("")){
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(14,38);to=(15,0)]
out.write("\r\n");
// end
// begin [file="/GeRenCJJG.jsp";from=(15,0);to=(15,31)]
if (true) {
out.clear();
String _jspx_qfStr = "";
pageContext.forward("GeRen.jsp" + _jspx_qfStr);
return;
}
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(15,31);to=(16,0)]
out.write("\r\n");
// end
// begin [file="/GeRenCJJG.jsp";from=(16,2);to=(27,4)]
}
//以下4行是构造用于查询的SQL语句串
sql ="SELECT ssb.XM,ssb.XH,kcb.KCM,cjb.CJ FROM ssb,cjb,kcb where ssb.";
if(!xh.equals(""))sql =sql+"XH='"+xh;
else sql = sql +"XM='"+xm;
sql = sql +"'and cjb.XH=ssb.XH and kcb.KCH=cjb.KCH ";
ResultSet rs =geren.executeQuery(sql);
try {
if (rs.next()){
xh= rs.getString("XH");
xm= rs.getString("XM");
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(27,6);to=(28,11)]
out.write("\r\n <h2>学号：");
// end
// begin [file="/GeRenCJJG.jsp";from=(28,14);to=(28,16)]
out.print(xh);
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(28,18);to=(28,22)]
out.write(" 姓名：");
// end
// begin [file="/GeRenCJJG.jsp";from=(28,25);to=(28,27)]
out.print(xm);
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(28,29);to=(31,8)]
out.write("</h2>\r\n <pre>课程名 成绩\r\n <textarea name=\"ly\" rows=\"10\" cols=\"25\">\r\n ");
// end
// begin [file="/GeRenCJJG.jsp";from=(31,10);to=(35,10)]
int i=0;
do{
String kcm1= rs.getString("KCM");
int cj1= rs.getInt("CJ");
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(35,12);to=(36,10)]
out.write("\r\n ");
// end
// begin [file="/GeRenCJJG.jsp";from=(36,13);to=(36,17)]
out.print(++i );
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(36,19);to=(36,21)]
out.write(" ");
// end
// begin [file="/GeRenCJJG.jsp";from=(36,24);to=(36,28)]
out.print(kcm1);
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(36,30);to=(36,40)]
out.write(" ");
// end
// begin [file="/GeRenCJJG.jsp";from=(36,43);to=(36,46)]
out.print(cj1);
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(36,48);to=(37,10)]
out.write("\r\n ");
// end
// begin [file="/GeRenCJJG.jsp";from=(37,12);to=(39,10)]
}while (rs.next());
rs.close();
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(39,12);to=(41,10)]
out.write("\r\n </textarea></pre>\r\n ");
// end
// begin [file="/GeRenCJJG.jsp";from=(41,12);to=(43,10)]
}
else{ rs.close();
// end
// HTML // begin [file="/GeRenCJJG.jsp";from=(43,12);to=(45,10)]
out.write("\r\n <h2>对不起，没查到！</h2>\r\n ");
// end
// begin [file="/GeRenCJJG.jsp";from=(45,12);to=(45,15)]
}
jsp 成绩管理系统
需积分: 0 126 浏览量
2008-11-25
19:40:58
上传
评论 2
收藏 1.07MB RAR 举报
jsp 成绩管理系统 （225个子文件） 
LuRu_jsp.class 7KB LuRu_0002ejsp_jsp.class 7KB LuRu$jsp.class 6KB GeRenCJJG_jsp.class 6KB GeRenCJJG_0002ejsp_jsp.class 6KB GeRenCJJG$jsp.class 6KB KeChengCJJG_jsp.class 6KB KeChengCJJG_0002ejsp_jsp.class 6KB KeChengCJJG$jsp.class 6KB HeDui$jsp.class 5KB HeDui_jsp.class 5KB HeDui_0002ejsp_jsp.class 5KB ShanChu1_jsp.class 5KB ShanChu1_0002ejsp_jsp.class 5KB GengXin$jsp.class 5KB GengXin_jsp.class 4KB GengXin_0002ejsp_jsp.class 4KB ZhuYe_0002ejsp_jsp.class 3KB ZhuYe_jsp.class 3KB GeRen_0002ejsp_jsp.class 3KB GeRen_jsp.class 3KB ShanChu_0002ejsp_jsp.class 3KB ShanChu_jsp.class 3KB ChaXun_jsp.class 3KB YanZheng_0002ejsp_jsp.class 3KB YanZheng_jsp.class 3KB ZhuYe$jsp.class 3KB KeCheng_0002ejsp_jsp.class 3KB KeCheng_jsp.class 3KB ChaXun_0002ejsp_jsp.class 3KB GeRen$jsp.class 3KB ShanChu$jsp.class 3KB ChaXun$jsp.class 3KB YanZheng$jsp.class 3KB KeCheng$jsp.class 3KB Data2.class 2KB Data2.class 2KB Data2.class 2KB Data1.class 2KB Data1.class 2KB Data1.class 2KB UnnamedPackage.dep2 23KB unnamed package.dep2 17KB ch5_6.dep2 2KB
实习报告.doc 539KB 目录.doc 30KB
junit.jar 118KB servlet.jar 76KB unittest.jar 60KB GeRenCJJG$jsp.java 9KB KeChengCJJG$jsp.java 9KB LuRu$jsp.java 8KB LuRu_jsp.java 7KB LuRu_0002ejsp_jsp.java 7KB HeDui$jsp.java 6KB GengXin$jsp.java 5KB GeRenCJJG_jsp.java 5KB GeRenCJJG_0002ejsp_jsp.java 5KB KeChengCJJG_jsp.java 4KB KeChengCJJG_0002ejsp_jsp.java 4KB ShanChu1_jsp.java 3KB ShanChu1_0002ejsp_jsp.java 3KB HeDui_jsp.java 3KB HeDui_0002ejsp_jsp.java 3KB GengXin_jsp.java 3KB GengXin_0002ejsp_jsp.java 3KB ZhuYe_jsp.java 3KB ZhuYe_0002ejsp_jsp.java 3KB ZhuYe$jsp.java 3KB ShanChu$jsp.java 3KB GeRen_jsp.java 3KB GeRen_0002ejsp_jsp.java 3KB ShanChu_jsp.java 3KB GeRen$jsp.java 3KB ChaXun_jsp.java 3KB ShanChu_0002ejsp_jsp.java 3KB ChaXun$jsp.java 2KB ChaXun_0002ejsp_jsp.java 2KB YanZheng$jsp.java 2KB YanZheng_jsp.java 2KB YanZheng_0002ejsp_jsp.java 2KB KeCheng$jsp.java 2KB KeCheng_jsp.java 2KB KeCheng_0002ejsp_jsp.java 2KB Data2.java 915B Data2.java 915B Data1.java 603B Data1.java 603B Data2.java~1~ 915B
bg.jpg 83KB CH5_6.jpx 8KB CH5_6.jpx~ 0B LuRu.jsp 2KB GeRenCJJG.jsp 2KB KeChengCJJG.jsp 1KB ShanChu1.jsp 860B HeDui.jsp 771B GengXin.jsp 737B ZhuYe.jsp 650B ShanChu.jsp 491B共 225 条
- 1
- 2
- 3
资源评论
