stable.java

连接数据库

package query;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;

import jbtmailproxy.SQLObject;

/**
 * http://127.0.0.1:80/query/stable?mailid=
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class stable extends HttpServlet{
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    SQLObject sqlo = new SQLObject();
    //Initialize global variables
    public void init() throws ServletException {
    }
    public String getResult() {
        return sqlo.getResult();
    }

    //Process the HTTP Get request
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        try {
            String mailid = request.getParameter("mailid");
            if (mailid != null) {
                response.sendRedirect("billing.html");
                return;
            } else {
                response.sendRedirect("erro.jsp");
                //System.out.println("mailid不能为空!");

            }

        } finally {
            out.close();
        }

        //    String url="sun.jdbc.odbc.jdbcodbcdriver";
        //    String logid="root";
        //
        //    String logpass="123";


        try {
            String sql = "SELECT COUNT(*) FROM MailFolder F WHERE F.Mailid = '2007110111533567195555' AND F.MailType = 0";
            sql = "SELECT F.UserPhone FROM MailFolder F WHERE F.Mailid = '2007110111533567195555' AND F.MailType= 0";
            sql = "SELECT COUNT(DISTINCT UserId) FROM MailActionLog A WHERE MailId='2007110111533567195555' AND Action='openmail'";
            sql = "SELECT COUNT(DISTINCT L.UserPhone) FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='openmail'";
            sql = "SELECT DISTINCT L.UserPhone FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='openmail'";
            sql = "SELECT COUNT(DISTINCT UserId) FROM MailActionLog A WHERE MailId='2007110211570221813240469248' AND Action='downloadattach'";
            sql = "SELECT COUNT(DISTINCT L.UserPhone) FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId=' 2007110211570221813240469248' AND A.Action= 'downloadattach'";
            sql = "SELECT DISTINCT L.UserPhone FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110211570221813240469248' AND A.Action='downloadattach'";
            sql = "SELECT NumberArgu, COUNT(DISTINCT UserId) FROM MailActionLog A WHERE MailId='2007110211570221813240469248' AND Action='downloadattach' GROUP BY NumberArgu";
            sql = "SELECT NumberArgu, COUNT(DISTINCT L.UserPhone) FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110211570221813240469248' AND A.Action= 'downloadattach' GROUP BY NumberArgu";
            sql = "SELECT DISTINCT L.UserPhone FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110211570221813240469248' AND A.Action='downloadattach' AND NumberArgu = 0 /*附件序号*/";
            sql = "SELECT COUNT(DISTINCT L.UserPhone) FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='replymail'";
            sql = "SELECT DISTINCT L.UserPhone FROM MailActionLog A,LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='replymail'";
            sql = "SELECT COUNT(DISTINCT L.UserPhone) FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='forwardmail'";
            sql = "SELECT DISTINCT L.UserPhone FROM MailActionLog A, LoginUser L WHERE A.UserId = L.UserId AND A.MailId='2007110111533567195555' AND A.Action='forwardmail'";
            sqlo.setSql(sql);
            sqlo.fillParam("Mailid");
            String[][] query = sqlo.executeQuery();
            System.out.println(sql);
        } catch (Exception ex1) {
            out.println("SQL" + ex1.getMessage());
            System.out.println("数据库错误:" + ex1.getMessage());
        }
    }

    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        doGet(request, response);
    }

    //Clean up resources
    public void destroy() {
    }
}