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

public class DBAccess extends HttpServlet
{ 
 private Connection con = null;
 String url = "jdbc:mysql://localhost/datenbankname";
 String driver = "org.gjt.mm.mysql.Driver";

 public void init(ServletConfig config) throws ServletException
 {
   super.init(config);
   try 
   {
     Class.forName(driver).newInstance(); 
   }
   catch (Exception e) 
   {
     System.err.println("Unable to load driver.");
     e.printStackTrace();
   }

   try 
   {
     Properties p = new Properties();

     p.put("user", "root");
     p.put("password","passwort");
     p.put("autoReconnect", "true");

     con = DriverManager.getConnection(url, p);
   }
   catch  (SQLException e)
   {
     System.err.println("Couln't get database connection.");
     e.printStackTrace();
   }
 }

 public void doGet (HttpServletRequest req, HttpServletResponse res) 
                   throws ServletException, IOException
 {
   res.setContentType("text/html");
   PrintWriter out = res.getWriter();
   try 
   {
     Statement stmt = con.createStatement();
     ResultSet rs = stmt.executeQuery("SELECT * FROM tabellenname");

     while (rs.next()) 
     {   
       out.println(rs.getString(1) + "<BR>");
     }
     
     rs.close();
     stmt.close();  
   }
   catch (SQLException e) 
   {
     out.println("SQLException: " + e.getMessage() );
   }
 }

 public void destroy()
 {
   try
   {
     if (con != null) { con.close(); } 
   }
   catch (SQLException ignore) { }
 }
}