package com.com;

import java.io.IOException; import java.io.PrintWriter; import java.sql.PreparedStatement; import java.sql.ResultSet;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

import com.DButil.JdbcUtils; import com.mysql.jdbc.Connection; import com.mysql.jdbc.Statement;

public class SendMail extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    response.setContentType("text/html");
    PrintWriter out = response.getWriter();

    String to=request.getParameter("to");
    String subject=request.getParameter("subject");
    String msg=request.getParameter("msg");


    Mailer.send(to, subject, msg);
    out.print("message has been sent successfully");
    out.close();
    boolean intractWithDB=true;

    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    int x=0;
    //String emails = null;

     try{

        con=(Connection)JdbcUtils.getConnection();
        ps=con.prepareStatement("select * from emailsdb where emails=?");

        ///ps.setString(1,emails);

         rs=ps.executeQuery();

                while(rs.next()){
                    x=1;
                    }

                }catch (Exception e) {
        e.printStackTrace();
    }

    finally{

} //return true; }

}

print("code sample");