<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>个人信息查询</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head><body>
<div align="center">
<img src="image/1_01.gif" width="770" height="111" />
<table width="774" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="774"> </td>
</tr>
</table>
<table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="152" rowspan="2"><img src="image/1_02.gif" width="154" height="79" /></td>
<td width="597" height="39">
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=TRSS";
String user="sa";
String password="123";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String Sname="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs=stmt.executeQuery(Sname);
rs.next();
String ok=rs.getString(2);
out.println(ok+"同学,欢迎,你好,欢迎进入web信息管理查询系统!");
String information="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs1=stmt.executeQuery(information);
while(rs1.next()) {
Sno=rs.getString("Sno");
Sname=rs.getString("Sname");
Sgender=rs.getString("Sgender");
Birthday=rs.getString("Birthday");
Shp=rs.getString("Shp");
Sp=rs.getString("Sp");
Sfzc=rs.getString("Sfzc");
Sfa=rs.getString("Sfa");
Sdept=rs.getString("Sdept");
Classs=rs.getString("Class");
Sidc=rs.getString("Sidc");}
String information="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs1=stmt.executeQuery(information);
while(rs1.next()) {
Sno=rs.getString("Sno");
Sname=rs.getString("Sname");
Sgender=rs.getString("Sgender");
Birthday=rs.getString("Birthday");
Shp=rs.getString("Shp");
Sp=rs.getString("Sp");
Sfzc=rs.getString("Sfzc");
Sfa=rs.getString("Sfa");
Sdept=rs.getString("Sdept");
Classs=rs.getString("Class");
Sidc=rs.getString("Sidc");}%>
</td>
<td width="24" rowspan="2" align="center"><img src="image/1_04.gif" width="18" height="79" /></td>
</tr>
<tr>
<td height="38" valign="top"><img src="image/1_07.gif" width="597" height="38" /></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="image/1_08.gif" width="155" height="44" /></td>
<td rowspan="9" valign="top"><table width="917" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="72" align="center"><p class="STYLE1">
学号</p></td>
<td width="66" align="center" class="STYLE1">姓名</td>
<td width="64" align="center" class="STYLE1">性别</td>
<td width="66" align="center" class="STYLE1">出生日期</td>
<td width="69" align="center" class="STYLE1">生源地</td>
<td width="68" align="center" class="STYLE1">政治面貌</td>
<td width="68" align="center" class="STYLE1">家庭邮编</td>
<td width="66" align="center" class="STYLE1">家庭地址</td>
<td width="70" align="center" class="STYLE1">所在系</td>
<td width="75" align="center" class="STYLE1">所在班级</td>
<td width="71" align="center" class="STYLE1">身份证号</td>
<td width="80" align="center" class="STYLE1"> </td>
<td width="82" align="center" class="STYLE1"> </td>
</tr>
<tr>
<td><%=Sno%></td>
<td><%=Sname%></td>
<td><%=Sgender%></td>
<td><%=Birthday%></td>
<td><%=Shp%></td>
<td><%=Sp%></td>
<td><%=Sfzc%></td>
<td><%=Sfa%></td>
<td><%=Sdept%></td>
<td><%=Classs%></td>
<td><%=Sidc%></td>
<td></td>
<td></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="18"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
<td rowspan="9"><img src="image/1_11.gif" width="18" height="403" /></td>
</tr>
<tr>
<td><img src="image/1_12.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_14.gif" width="154" height="38" /></td>
</tr>
<tr>
<td><img src="image/1_15.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_16.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_17.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><a href="updatec.jsp"><img src="image/1_18.gif" width="154" height="38" border="0" /></a></td>
</tr>
<tr>
<td><a href="exit2.jsp"><img src="image/1_19.gif" width="154" height="39" border="0" /></a></td>
</tr>
<tr>
<td><img src="image/1_20.gif" width="154" height="88" /></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="image/1_21.png" width="770" height="62" /></td>
</tr>
</table>
</div>
<p> </p>
</body>
</html>报错:~~~~~~~~~~~
描 述 服务器遇到内部错误,无法满足这个访问请求异 常 org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)是什么原因,我其他网页可以运行,这个就不行了,为啥??
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>个人信息查询</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>
</head><body>
<div align="center">
<img src="image/1_01.gif" width="770" height="111" />
<table width="774" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="774"> </td>
</tr>
</table>
<table width="773" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="152" rowspan="2"><img src="image/1_02.gif" width="154" height="79" /></td>
<td width="597" height="39">
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=TRSS";
String user="sa";
String password="123";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String Sname="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs=stmt.executeQuery(Sname);
rs.next();
String ok=rs.getString(2);
out.println(ok+"同学,欢迎,你好,欢迎进入web信息管理查询系统!");
String information="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs1=stmt.executeQuery(information);
while(rs1.next()) {
Sno=rs.getString("Sno");
Sname=rs.getString("Sname");
Sgender=rs.getString("Sgender");
Birthday=rs.getString("Birthday");
Shp=rs.getString("Shp");
Sp=rs.getString("Sp");
Sfzc=rs.getString("Sfzc");
Sfa=rs.getString("Sfa");
Sdept=rs.getString("Sdept");
Classs=rs.getString("Class");
Sidc=rs.getString("Sidc");}
String information="select * from Stu where Sno='"+session.getAttribute("Sno")+"'";
ResultSet rs1=stmt.executeQuery(information);
while(rs1.next()) {
Sno=rs.getString("Sno");
Sname=rs.getString("Sname");
Sgender=rs.getString("Sgender");
Birthday=rs.getString("Birthday");
Shp=rs.getString("Shp");
Sp=rs.getString("Sp");
Sfzc=rs.getString("Sfzc");
Sfa=rs.getString("Sfa");
Sdept=rs.getString("Sdept");
Classs=rs.getString("Class");
Sidc=rs.getString("Sidc");}%>
</td>
<td width="24" rowspan="2" align="center"><img src="image/1_04.gif" width="18" height="79" /></td>
</tr>
<tr>
<td height="38" valign="top"><img src="image/1_07.gif" width="597" height="38" /></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="image/1_08.gif" width="155" height="44" /></td>
<td rowspan="9" valign="top"><table width="917" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="72" align="center"><p class="STYLE1">
学号</p></td>
<td width="66" align="center" class="STYLE1">姓名</td>
<td width="64" align="center" class="STYLE1">性别</td>
<td width="66" align="center" class="STYLE1">出生日期</td>
<td width="69" align="center" class="STYLE1">生源地</td>
<td width="68" align="center" class="STYLE1">政治面貌</td>
<td width="68" align="center" class="STYLE1">家庭邮编</td>
<td width="66" align="center" class="STYLE1">家庭地址</td>
<td width="70" align="center" class="STYLE1">所在系</td>
<td width="75" align="center" class="STYLE1">所在班级</td>
<td width="71" align="center" class="STYLE1">身份证号</td>
<td width="80" align="center" class="STYLE1"> </td>
<td width="82" align="center" class="STYLE1"> </td>
</tr>
<tr>
<td><%=Sno%></td>
<td><%=Sname%></td>
<td><%=Sgender%></td>
<td><%=Birthday%></td>
<td><%=Shp%></td>
<td><%=Sp%></td>
<td><%=Sfzc%></td>
<td><%=Sfa%></td>
<td><%=Sdept%></td>
<td><%=Classs%></td>
<td><%=Sidc%></td>
<td></td>
<td></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="18"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
<td rowspan="9"><img src="image/1_11.gif" width="18" height="403" /></td>
</tr>
<tr>
<td><img src="image/1_12.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_14.gif" width="154" height="38" /></td>
</tr>
<tr>
<td><img src="image/1_15.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_16.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><img src="image/1_17.gif" width="154" height="39" /></td>
</tr>
<tr>
<td><a href="updatec.jsp"><img src="image/1_18.gif" width="154" height="38" border="0" /></a></td>
</tr>
<tr>
<td><a href="exit2.jsp"><img src="image/1_19.gif" width="154" height="39" border="0" /></a></td>
</tr>
<tr>
<td><img src="image/1_20.gif" width="154" height="88" /></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="image/1_21.png" width="770" height="62" /></td>
</tr>
</table>
</div>
<p> </p>
</body>
</html>报错:~~~~~~~~~~~
描 述 服务器遇到内部错误,无法满足这个访问请求异 常 org.apache.jasper.JasperException: Unable to load class for JSP
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)是什么原因,我其他网页可以运行,这个就不行了,为啥??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货