userloginact.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="../inc/md5.jsp"%>
<%
  String username = new String(request.getParameter("bbsuser").getBytes("iso-8859-1"));
  String pass = new String(request.getParameter("password").getBytes("iso-8859-1"));
  String rand = (String)session.getAttribute("rand");
  int ckies = new Integer(request.getParameter("ckies")).intValue(); 
  String useryz = request.getParameter("useryz");
  pass=md5(pass);
  if (rand.equals(useryz))
     {
    String sql="select * from clubuser where clubuser_name='"+username+"' and clubuser_password='"+pass+"'";
    ResultSet rs=stmt.executeQuery(sql);
	 if (rs.next())
	    {
		String bbsuser=rs.getString("clubuser_nickname");
		String name=rs.getString("clubuser_name");
		String bz=rs.getString("bbsmanager");
		String bbsadmin=rs.getString("bbsadmin");
		String payuser=rs.getString("payuser");
	    if (rs.getString("payuser").equals("3"))
	       {
           out.print("<script language='javascript'>");
           out.print("alert('对不起,你的用户名被管理员封锁了!');");
           out.print("history.go(-1);");
           out.print("</script>");
           out.close();
		   }
		else
		  {
     Cookie un=new Cookie("clubusername",username);
	 un.setMaxAge(ckies*24*3600);
	 un.setPath("/"); 
     response.addCookie(un);
	 Cookie pw=new Cookie("pass",pass);
	 pw.setMaxAge(ckies*24*3600);
	 pw.setPath("/"); 
     response.addCookie(pw);
	 Cookie ftbbsbz=new Cookie("bz",bz);
	 ftbbsbz.setMaxAge(ckies*24*3600);
	 ftbbsbz.setPath("/"); 
     response.addCookie(ftbbsbz);
	 Cookie ftbbsadmin=new Cookie("bbsadmin",bbsadmin);
	 ftbbsadmin.setMaxAge(ckies*24*3600);
	 ftbbsadmin.setPath("/"); 
     response.addCookie(ftbbsadmin);
	 Cookie ftpayuser=new Cookie("payuser",payuser);
	 ftpayuser.setMaxAge(ckies*24*3600);
	 ftpayuser.setPath("/"); 
     response.addCookie(ftpayuser);
	 
	 String sqlstr="update clubuser set clubuser_lasttime=getdate(),tili=tili+100 where clubuser_name='"+name+"'";
     stmt.executeUpdate(sqlstr);
	 
     out.print("<script language='javascript'>");
     out.print("window.location.href='main.jsp';");
     out.print("parent.left.document.location.reload();");
	 //out.print("history.go(-1);");
     out.print("</script>");
     out.close();
	      }
	    }
	 else
	   {
  	     out.print("<script>");
         out.print("alert('用户名或密码错误');");
         out.print("window.location.href='userlogin.jsp';");
         out.print("</script>");		   
		}
	 stmt.close(); 
     conn.close();
	}
  else
	{
  	     out.print("<script>");
         out.print("alert('验证码输入有误!请核对!');");
         out.print("window.location.href='userlogin.jsp';");
         out.print("</script>");	
	}
%>