import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Test2 extends HttpServlet
{
int counter=0, countPage=1, nrAktuell=1;
Statement stmt = null;
String query, query2;
ResultSet rs = null;
Connection connection = null;
int test=1;
protected void doGet(
HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
countPage = 1;
counter = 0;
out.println(nrAktuell);
query = "SELECT * FROM Kunden WHERE ID < 3*" + nrAktuell + "AND ID >=" + (3*nrAktuell-3);
query2 = "SELECT * FROM Kunden";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e)
{
out.println("Treiber konnte nicht geladen werden!!!");
e.printStackTrace();
}
try
{
connection = DriverManager.getConnection("jdbc:odbc:test");
}
catch (SQLException e1)
{
out.println("Fehler beim Aufbau der Verbindung mit der Datenbank!");
}
try
{
stmt = connection.createStatement();
rs = stmt.executeQuery(query);
out.println("<table width = 100% border=1 bgcolor=yellow>");
while(rs.next())
{
out.println("<tr>");
out.println ("<td>");
out.println (rs.getString(1));
out.println ("</td>");
out.println ("<td>");
out.println (rs.getString(2));
out.println ("</td>");
out.println ("<td>");
out.println (rs.getString(3));
out.println ("</td>");
out.println("</tr>");
}
out.println("</table>");
rs = stmt.executeQuery(query2);
while(rs.next())
{
counter++;
if(counter>=3)
{
counter=0;
countPage++;
}
}
for(int i=1;i<=countPage;i++)
{
//nrAktuell ++;
test = i;
out.println("<a href=http://p132355:50400/firstWeb/servlet/com.sap.Test2?"+(nrAktuell=i)+">"+i+"</a>");
}
}
catch (SQLException e2)
{
e2.printStackTrace();
out.println("Fehler bei Statement!");
}
}
}
