chklogin.jsp

来自「center you may down load soft?may be you」· JSP 代码 · 共 31 行

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