package org.apache.jsp.bbs;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.sql.*;
import java.util.*;
import java.util.Date;
import java.text.*;

public final class userloginact_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

  private static java.util.Vector _jspx_dependants;

  static {
    _jspx_dependants = new java.util.Vector(1);
    _jspx_dependants.add("/bbs/../inc/conn.jsp");
  }

  public java.util.List getDependants() {
    return _jspx_dependants;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			null, true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write(" \r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write('\r');
      out.write('\n');


  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String url="jdbc:odbc:db2000";

Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 


      out.write('\r');
      out.write('\n');

  String username = new String(request.getParameter("bbsuser").getBytes("iso-8859-1"));
  String pass = new String(request.getParameter("password").getBytes("iso-8859-1"));
  String rand = session.getAttribute("rand").toString();

  String useryz = request.getParameter("useryz");

 if (rand.equals(useryz))
     { 
    String sql="select * from clubuser where clubuser_name='"+username+"' and clubuser_password='"+pass+"'";
    ResultSet rs=stmt.executeQuery(sql);
     //rs.next();
	 if (rs.next())
	    {
		String bbsuser=rs.getObject("clubuser_nickname").toString();
		String name=rs.getObject("clubuser_name").toString();
		String bz=rs.getObject("bbsmanager").toString();
		String bbsadmin=rs.getObject("bbsadmin").toString();
		String payuser=rs.getObject("payuser").toString();
	    if (rs.getObject("payuser").toString().equals("3"))
	       {
           out.print("<script language='javascript'>");
           out.print("alert('對(duì)不起,你的用戶名被管理員封鎖了!');");
           out.print("history.go(-1);");
           out.print("</script>");
           out.close();
		   }
		else
		  {
     //Cookie c=new Cookie("clubusername",username);
     //response.addCookie(c);
	 //Cookie d=new Cookie("pass",pass);
     //response.addCookie(d);
	 session.setAttribute("bbsuser",bbsuser);
	 session.setAttribute("name",name);
	 session.setAttribute("bz",bz);
	 session.setAttribute("bbsadmin",bbsadmin);
	 session.setAttribute("payuser",payuser);
	 
	 String sqlstr="update clubuser set clubuser_lasttime=DATE(),tili=tili+100 where clubuser_name='"+(String)session.getAttribute("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('用戶名或密碼錯(cuò)誤');");
         out.print("window.location.href='userlogin.jsp';");
         out.print("</script>");		   
		}
	 stmt.close(); 
     conn.close();
	}
  else
	{
  	     out.print("<script>");
         out.print("alert('驗(yàn)證碼輸入有誤!請(qǐng)核對(duì)!');");
         out.print("window.location.href='userlogin.jsp';");
         out.print("</script>");	
	}
	

    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}