Информатика и выч. техника \ Информационные технологии на железнодорожном транспорте

Разработка контента курса дистанционного обучения "DB2 универсальная база данных", страница 43

            ResultSet rs = stm.executeQuery("SELECT * FROM REPL_LOG");

            while(rs.next()){

                timeStamp.add(rs.getString("TIMESTAMP"));

                rowId.add(rs.getString("ROW_ID"));

                sqlCode.add(rs.getString("SQLCODE"));

            }

            rs.close();

            stm.close();

            conn.close();

            response.setHeader( "cache-control", "no-store" );

            response.setHeader( "pragma", "no-cache" );

            response.setContentType( "text/html; charset=Windows-1251" );

            PrintWriter out = response.getWriter();

            out.println( "<html>" );

            out.println( "    <head>" );

            out.println( "        <link href=\"css/content.css\" type=\"text/css\" rel=\"stylesheet\">");

            out.println( "        <link href=\"css/journal.css\" type=\"text/css\" rel=\"stylesheet\">");

            out.println( "        <title>АСУ ЛР: Журнал репликации</title>" );

            out.println( "    </head>" );

            out.println( "    <body>" );

            out.println( "        <h2>АСУ ЛР: Журнал репликации</h2>" );

            out.println( "      <table cellspacing=\"0\" cellpadding=\"5\">" );

            out.println( "          <tr>" );

            out.println( "              <td>" );

            out.println( "                  Отметка времени XML-документа" );

            out.println( "              </td>" );

            out.println( "              <td>" );

            out.println( "                  ID строки XML-документа" );

            out.println( "              </td>" );

            out.println( "              <td>" );

            out.println( "                  Код завершения SQL-операции" );

            out.println( "              </td>" );

            out.println( "          </tr>" );

            for(int i = 0; i < timeStamp.size(); i++){

                out.println( "          <tr>" );

                out.println( "              <td>"+(String)timeStamp.get(i)+"</td>" );

                out.println( "              <td>"+(String)rowId.get(i)+"</td>" );

                out.println( "              <td align=\"right\">"+(String)sqlCode.get(i)+"</td>" );

                out.println( "          </tr>" );

            }

            out.println( "      </table>" );

            out.println( "      <br>" );

            out.println( "      <a href=\"index.jsp\">Страница загрузки XML-документов</a><br>" );

            out.println( "  </body>" );

            out.println( "</html>" );

            out.close();

        } catch(Exception ex){

            session.setAttribute("ERR", "Ошибка журнала репликации");

            session.setAttribute("ERR_DESCRIPTION", ex.getMessage());

            response.sendRedirect("error.jsp");

        }

    }

}

EJB-компоненты

ReplicatorBean.java

package courseExample;

import javax.ejb.SessionBean;

import javax.ejb.CreateException;

import javax.ejb.SessionContext;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import java.util.ArrayList;

import java.sql.Statement;

import java.sql.SQLException;

import java.sql.Connection;

import javax.sql.DataSource;

Скачать файл