📄 ac.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
Connection sqlConn;
PreparedStatement pstmt;
ResultSet rs=null;
int len = 10 * 1024 * 1024; //定义字符数组长度
%>
<%
String id=request.getParameter("gkh");
System.out.println(id);
%>
<%
String driver="weblogic.jdbc.mssqlserver4.Driver";
String url="jdbc:weblogic:mssqlserver4:test@202.194.209.30:1433";
String user="teaching";
String password="0819";
byte [] buf=null; //用来存储二进制流数据的缓冲区
try
{
//连接数据库，自定义的数据库连接池管理类
Class.forName(driver);
Connection dbcon=DriverManager.getConnection(url,user,password);
sqlConn=DriverManager.getConnection(url,user,password);
String searchSql="select a.*,b.sex,c.spectName,d.TeachingUnitName from newstudInfo a,cod_sex b,Ini_makespect c,Ini_teachingUnit d where a.Inspect=c.spectselfno and d.teachingUnitNo=c.teachingUnitNo and a.sexno=b.sexno and ExamiNo = '" + id +"'";
pstmt=sqlConn.prepareStatement(searchSql);
rs=pstmt.executeQuery(searchSql);
if (rs.next())
{
//res=rs.getString("receiver");
}
else
{
response.sendRedirect("ac.htm");
}
}
catch (Exception e)
{
System.out.println(e.toString());
}
finally
{
try {
//sqlConn.close();
}catch(Exception e) {System.out.println(e.toString()); }
}
%>
<html>
<head>
<title>学生报到</title>
</head>
<body>
<form name="form1" method="post" action="sure.jsp">
<table width="100%" border="0">
<tr>
<td><table width="100%" border="0">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" align="center">学生注册信息</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"> <table width="100%" border="1" bordercolor="#000000" cellpadding="1" cellspacing="1">
<tr>
<td>高考号</td>
<td> <%=id%></td>
<td rowspan="3">照片</td>
<td rowspan="3" align="center" valign="middle"><img dynsrc="show1.jsp?id=<%=id%>" width=80 height=80></td>
</tr>
<tr>
<td>学号</td>
<td> <%=rs.getString("studno")%></td>
</tr>
<tr>
<td>姓名</td>
<td> <%=rs.getString("name")%> </td>
</tr>
<tr>
<td>学院</td>
<td colspan="3"> <%=rs.getString("TeachingUnitName")%></td>
</tr>
<tr>
<td>专业</td>
<td colspan="3"> <%=rs.getString("spectName")%></td>
</tr>
<tr>
<td>班级</td>
<%/////////////////应该写出班级名称////////////////////////////%>
<td colspan="3"> <%=rs.getString("ClassNo")%></td>
</tr>
<tr>
<td>宿舍</td>
<td colspan="3"> <%=rs.getString("DormNo")%></td>
</tr>
<tr>
<td>床号</td>
<td colspan="3"> <%=rs.getString("StudDormBedNo")%></td>
</tr>
<tr>
<td>生源地</td>
<td colspan="3"> <%=rs.getString("GraduSchoolName")%></td>
</tr>
<tr>
<td>性别</td>
<td colspan="3"> <%=rs.getString("Sex")%></td>
</tr>
<tr>
<td>已报到</td>
<%/////////////////将已经报到的设置为红色////////////////////////////%>
<td colspan="3">
<%if(rs.getBoolean("enrolFlag")==false)
out.println("未报到"); else out.println("已报到");%>
</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td align="center"> <input type="submit" name="Submit" value="确定">
</td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -