Source of Java/VrlVrz.java

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

public class VrlVrz extends HttpServlet {

  public void doGet (HttpServletRequest request,HttpServletResponse response)
                     throws ServletException, IOException {
    Connection con = null;
    Statement stmt = null;
    ResultSet rs   = null;
    response.setContentType("Text/html");
    PrintWriter out = response.getWriter();
    try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      con = DriverManager.getConnection(
      "jdbc:microsoft:sqlserver://arnold.informatik.uni-osnabrueck.de:1433",
                                        "erika","mustermann");
      stmt = con.createStatement();
      String query = "select v.vorlnr, v.titel, v.sws " +
                     "from vorlesungen v, professoren p " +
                     "where v.gelesenvon = p.persnr and p.name ='" +
                      request.getParameter("professor_name") + "'";
      rs = stmt.executeQuery(query);
      out.println("<HTML>");
      out.println("<HEAD><TITLE>Java Servlet</TITLE></HEAD>");
      out.println("<BODY>");
      out.println("<H1>Vorlesungen von Prof. " +
                  request.getParameter("professor_name") +": </H1>");
      out.println("<UL>");
      while (rs.next()) 
        out.println("<LI>" + 
          rs.getInt("VorlNr") + ": " + rs.getString("Titel") + " (mit " +
          rs.getInt("SWS") + " SWS)" + "</LI>");
      out.println("</UL>"); 
      out.println("<BODY></HTML>");
    }
    catch(ClassNotFoundException e) {
      out.println("Datenbanktreiber nicht gefunden: " + e.getMessage());
    }
    catch(SQLException e) {
      out.println("SQLException: " + e.getMessage());
    }
    finally {
      try { if (con != null ) con.close();
      } catch (SQLException ignorieren) {}
    }
  }
}