logon.jsp

来自「基于J2EE的门诊划价系统 目 录 第1章 绪论 1 1.1 引言 1 」· JSP 代码 · 共 37 行

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<jsp:directive.page import="java.sql.ResultSet" />
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>
<jsp:useBean id="Rs" scope="page" class="MyWeb.db.DBManager" />
<%
	request.setCharacterEncoding("GB2312");
	String username = request.getParameter("userid");
	String password = request.getParameter("password");
	out.println(username);
	out.println(password);
	ResultSet rs;
	String sql;
	if (username == "") {
		response.sendRedirect("index.jsp?error=2");
	} else {
		sql = "select * from administrator where Username=" + "'"
		+ username + "'";
		out.println(sql);
		rs = Rs.executeQuery(sql);
		if (rs.next()) {
			String p = rs.getString("Password");
			out.println(p);
			if (p.equals(password)) {
		response.sendRedirect("main.jsp?page=check");
		session.setAttribute("username", username);
			} else
		response.sendRedirect("index.jsp?error=1");
		}
	}
%>