📄 dct_log_in.jsp

📁 实现了一个医院门诊预约系统

💻 JSP

字号:

<SCRIPT language="javascript">
function backward()
{
      history.back();
}
</SCRIPT>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page pageEncoding="gb2312"%>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
	<title>医生登陆</title>
</head>

<body>	
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:HCRS";
Connection conn = DriverManager.getConnection(driver,"sa","605605");
Statement stmt = conn.createStatement();
boolean a;

String DctNo=request.getParameter("DctNo");
String DctPw=request.getParameter("DctPw");

String sql=null;
ResultSet rs=null;
sql="select * from Doctor where DctNo='"+DctNo+"'and DctPw='"+DctPw+"'";
rs=stmt.executeQuery(sql);
a=rs.next();
if(a==true)//用户id及密码输入正确的情况
{
	session.setAttribute("DctNo",DctNo);
	//out.print((String)session.getValue("DctNo"));
	rs.close();
	String s=new String("123456"); 
	if(DctPw.equals(s)!=true)
	{%>
	<SCRIPT language="javascript">self.location="dct_index.jsp"</SCRIPT>
	<%}
	else
	{%>
	<SCRIPT language="javascript">alert("请修改您的初始密码");self.location="dct_log_edit1.jsp"</SCRIPT>
<%}
}
else
{
	rs.close();
%>
	<br><br><br><br><center><font size='3'><b>对不起！您的输入有误，请重新填写！</b></font></center></p>
	<br><br><br>
	<p><center><input type="button" value="返回" onClick="backward()"></center></p>
<%}%>


</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -