loginchk.jsp

用JSP写的一个在线购物网站的代码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="data" scope="page" class="shop.data.conn" />
<%
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
String sql="select * from manager where name='"+name+"' and pwd='"+pwd+"'";
ResultSet rs=data.executeQuery(sql);
if(!rs.next())
{%>
<script language="JavaScript">
alert("对不起，您的用户ID或密码错误");
history.back();
</script>
<%}else{
java.util.Date today=new java.util.Date();
String logintime=today.toLocaleString();
sql="update manager set lastTime='"+logintime+"' where name='"+name+"'";
rs=data.executeQuery(sql);
session.putValue("manager",name);
response.sendRedirect("index.jsp");
}%>