Untitled

  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
  {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    out.println("<html>");
    out.println("<head><title>Servlet24</title></head>");
    out.println("<body>");
    StringValueCollection vars=new StringValueCollection();
    try{
      Class.forName("oracle.jdbc.driver.OracleDriver");
      String driverurl="jdbc:oracle:thin:@172.26.99.42:1521:asunt1";
      Connection Connection1 = DriverManager.getConnection(
      driverurl,"isk_kont","isk_kont01");
      Statement Statement1=Connection1.createStatement();
      vars.importData(request,"s_grupstu grupstu.idz");
      printTitle(out,Statement1,vars);
      printBody(out,Statement1,vars);
    }
    catch (Exception e)
    {
      out.println(e.toString());
      out.println("Current vars:");
      out.println(vars.getAllValues());
    }
    out.println("</body></html>");
    out.close();
  }
  private void printTitle(PrintWriter out,Statement Statement1,StringValueCollection vars) throws Exception
  {
    String sq="select g.namgruk,s.shifr,s.nam\n"+
              "from isk_kont.grupstu g\n"+
              "inner join iss_spr.special s on g.s_special=s.idz\n"+
              "where g.idz="+vars.getString("grupstu.idz");
    vars.setString("currentSQL",sq);
    vars.importData(Statement1,sq,"namgruk grupstu.nam,shifr special.shifr,nam special.nam");
    out.println("<p>Титульный лист</p>");
    out.println("<p>По специальности "+vars.getToHTML("special.shifr")+" "+vars.getToHTML("special.nam")+"</p>");
  }
  private void printBody(PrintWriter out,Statement Statement1,StringValueCollection vars) throws Exception
  {
    vars.setString("partHTML","<p>Перечень студентов специальности "+vars.getToHTML("special.nam")+",");
    vars.appendString("partHTML","обучающихся в группе "+vars.getToHTML("grupstu.nam")+"</p>");
    out.println(vars.getString("partHTML"));
    String sq="select l.fam\n"+
              "from isk_kont.teksost t\n"+
              "inner join isk_kont.lichkr l on t.idlich=l.id\n"+
              "where t.s_grupstu="+vars.getString("grupstu.idz");
    vars.setString("currentSQL",sq);
    ResultSet Query1=Statement1.executeQuery(sq);
    while (Query1.next())
    {
      out.println("<p>"+vars.getInc("studIndex")+". "+func.ToHtml(Query1.getString("fam"))+"</p>");
    }
  }