login.jsp

本系统采用jsp编写,数据库采用的是MYSQL,使用JDBC驱动

<%
/**
********************************
*          NTsky留言本V 1.0           *
*          功能：验证用户登陆
*          代码编写：姚君林
*          编写日期：2003/4/5
*	   代码修改：
           修改日期：			
********************************
*/
%>

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="login" scope="page" class="note.Jdbc_conn"/>

<%
	String name=request.getParameter("username");
	String password=request.getParameter("passwd");
	if (name.length()==0)
		out.println ("<script language=javascript>alert('用户名不能为空');javascript:history.back();</script>");
	if (password.length()==0) 
		out.println ("<script language=javascript>alert('密码不能为空');javascript:history.back();</script>");
	ResultSet rs=login.executeQuery("select * from admin where admin_name='"+name+"'");
	if(!rs.next())
		out.println("<script language=javascript>alert('请输入正确的用户名！');javascript:history.back();</script>");
	ResultSet rt=login.executeQuery("select * from admin where admin_name='"+name+"' and admin_password='"+password+"'");
	if(!rt.next())
		out.println("<script language=javascript>alert('密码不正确');javascript:history.back();</script>");
	else
	session.putValue("user",name);
		out.println("<script language=javascript>alert('欢迎进入管理！');location.href='default.jsp';</script>");
%>