memchecklogin.jsp

JSP课件以及一个网上书店系统程序,带数据库

<%@ include file="inc/conn.jsp"%>
<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%
String user_name=request.getParameter("uid");
String user_pass=request.getParameter("pwd");
sql="select * from member where user_name='"+user_name+"'"+" and user_pass='"+user_pass+"'";
rs=dbBean.exeSQL(sql);
if(!rs.next())
{
//非法用户
out.print("<div align=center>输入的用户不存在或密码错误!   <a href=mem_Login.jsp ><font color=#FF0000>重新登录!</font></a></div>");
//out.print("<script>alert('');window.history.go(-1);</script>");
	}
else{
//登录成功
	 session.setAttribute("userid",""+rs.getString("user_id")+"");
     session.setAttribute("nick",""+rs.getString("user_namec")+"");
	 //response.sendRedirect("index.jsp");
	 response.sendRedirect("mem_Login.jsp");
	 }
%>