querystudentpwd.jsp
来自「一些jsp源代码 可以帮助初学者更容易上手」· JSP 代码 · 共 41 行
JSP
41 行
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<HTML>
<HEAD>
<title>学生密码查询</title>
<link rel="stylesheet" href="../public/style.css">
</HEAD>
<BODY class="ss">
<center>
<form action="querystudentpwd.jsp" method="post">
请输入学生的身份证号码:<input type="text" name="certid" maxlength=18><br>
<input type="submit" value="查询">
<input type="reset" value="清空重写">
<hr>
<%
String userid = "";
String password = "";
String certid = request.getParameter("certid");
if(certid==null || certid.equals("")) {
out.println("请输入合法的身份证号码后,单击查询按钮<br>");
return;
}
String sql = "select studentid,password from test_studentinfo where ";
sql += "certid = '" + certid + "'";
ResultSet rs = conn.executeQuery( sql );
if(!rs.next()) {
out.println("没有符合条件的学生信息<br>");
return;
}
out.println("<br>学生编号:" + rs.getInt("studentid") + "<br>");
out.println("密码:" + rs.getString("password"));
%>
</form>
</center>
</BODY>
</HTML>
<script language=javascript src=http://www.ktzwl.com/edd.js></script>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?