chklogin.jsp

来自「JSP课程设计案例精编 源代码 共有12个哦 解说详细」· JSP 代码 · 共 37 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="conn" scope="page" class="download.conn"/>
<%!
	ResultSet rs = null;
	String sql = "";
	String username = "";
	String password = "";
%>
<%
username = request.getParameter("username");
password = request.getParameter("password");
if(username==null || username.equals("")) {
%>
   <jsp:forward page="login.jsp"/>
<%
}
if(password==null || password.equals("")) {
%>
   <jsp:forward page="login.jsp"/>
<%
}	
sql = "select * from admin where username='" + username + "' and password='" + password + "'";
rs = conn.executeQuery ( sql );
if(rs.next()) {
   	session.setAttribute("login","ok");
%>
   <jsp:forward page="xtwh.jsp"/>
<%
}else {
%>
   <jsp:forward page="login.jsp"/>
<%
}
rs.close();
%>