import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
public class Beitrag extends HttpServlet implements Serializable {
private static final String CONTENT_TYPE = "text/html";
//Process the HTTP Get request
public void service(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException
{
//String strTextfeld1, strTextfeld2;
Connection con = null;
Statement stmt = null;
PrintWriter out = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
String wert1 = null;
String wert2 = null;
response.setContentType(CONTENT_TYPE);
out = response.getWriter();
try
{
Class.forName("com.mysql.jdbc.Driver");
try
{
con = DriverManager.getConnection("jdbc:mysql://localhost/fitness","root","tokra");
}
catch (Exception ex){}
try
{
stmt = con.createStatement();
}
catch (Exception ex){}
try
{
rs1 = stmt.executeQuery("SELECT sum(Beitrag) FROM Mitgliedsdaten");
rs2 = stmt.executeQuery("SELECT sum(Beitrag) FROM Mitgliedsdaten where Vertragstyp='Fussball'");
}
catch (Exception ex){}
out.println("<html>");
out.println("<head>");
out.println("<title>Beiträge</title>");
out.println("</head>");
out.println("<body text='#000000' bgcolor='#FFFF00' link='#FF0000' alink='#FF0000' vlink='#FF0000'>");
out.println("<center>");
out.println("<h1>Beiträge aller Mitglieder</h1>");
out.println("<table>");
try
{
out.println("<tr>");
out.println("<td></td>");
out.println("<td>&&&&&</td>");
out.println("<td>[b] Summe aller Beiträge:");
out.println("
Summe aller Beiträge für Fussball:");
out.println("[/b]</td>");
out.println("<td>&&&&&</td>");
while (rs1.next())
{
wert1 = rs1.getString(1).trim();
}
while (rs2.next())
{
wert2 = rs2.getString(1).trim();
}
out.println("<td>" + wert1);
out.println("
" + wert2);
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("
");
out.println("</center>");
}
catch (Exception ex){}
out.println("</body>");
out.println("</html>");
}
catch (ClassNotFoundException e)
{
out.println(e.getMessage());
}
finally
{
try
{
if (con != null) con.close();
}
catch (SQLException ignored) {}
}
}
}