2login.jsp

一个用java开发的购物系统。使用tomcat作为服务器,mysql的数据库

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="mdb" class="ckstudio.db.faq" scope="page"/>
<%
if(request.getParameter("action").equals("login")){
String admin_name=request.getParameter("admin_name");
String admin_pass=request.getParameter("admin_pass");
if((admin_name.indexOf("'")!=-1)||(admin_pass.indexOf("'")!=-1))
out.print("请不要使用非法字符");
else{
String sql="select * from admin where admin_name='"+admin_name+"' and admin_pass='"+admin_pass+"'";
ResultSet rs=mdb.executeQuery(sql);
    if(!rs.next())
        out.print("<center>用户名和密码不匹配");
    else{
		
        session.setAttribute("admin_name",""+rs.getString("admin_name")+"");
        response.sendRedirect("manage.jsp");
    }
mdb.Close();
	}
}
%>