failall.jsp

来自「javamail发送程序」· JSP 代码 · 共 68 行

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="JspPost" scope="page" class="myjsp.JspGetString" />
<%!
    String sValue=new String();
    public String getStr(String str)
  {

    try
    {
        String temp1=str;
        byte[] temp2=temp1.getBytes("GBK");
        String temp=new String(temp2);
        return temp;

    }
    catch(Exception e)
    {

    }
    return "null";
  }
  private static Connection DataConnection;
  private static Statement statement;
  private static ResultSet DataResultSet1;
  private static String DirverName ="sun.jdbc.odbc.JdbcOdbcDriver";
  private static String OdbcURL="jdbc:odbc:emaillist1";
%>
<%
  //获得传入的参数值
  sValue=request.getParameter("B11");

  if(sValue.equals("前日失败用户"))
  {
    response.sendRedirect("email-fail.jsp?jsplei=zuo");
  }
  else if(sValue.equals("显示删除用户"))
  {
    response.sendRedirect("email-fail.jsp?jsplei=del");
  }
  else if(sValue.equals("转回有效用户"))
  {
    String sEmail=request.getParameter("hidd");
      try
      {
        Class.forName(DirverName);
        DataConnection=DriverManager.getConnection(OdbcURL);
        statement=DataConnection.createStatement();
        int num=statement.executeUpdate("UPDATE xiao SET jilu='sYes',cishu=0,biaozhu=0 WHERE tomail = '"+sEmail+"'");
        statement.close();
       }
       catch(ClassNotFoundException cnfe)
       {
           System.err.println(cnfe);
       }
        catch(SQLException sqle)
       {
           System.err.println(sqle);
       }
      response.sendRedirect("email-fail.jsp?jsplei=del");
  }
  else if(sValue.equals("返回发送管理"))
  {
    response.sendRedirect("email.jsp");
  }

%>