<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
		<id>http://www.jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java%2FServlets%2FJNDI</id>
		<title>Java/Servlets/JNDI - История изменений</title>
		<link rel="self" type="application/atom+xml" href="http://www.jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java%2FServlets%2FJNDI"/>
		<link rel="alternate" type="text/html" href="http://www.jexp.ru/index.php?title=Java/Servlets/JNDI&amp;action=history"/>
		<updated>2026-04-21T19:15:31Z</updated>
		<subtitle>История изменений этой страницы в вики</subtitle>
		<generator>MediaWiki 1.30.0</generator>

	<entry>
		<id>http://www.jexp.ru/index.php?title=Java/Servlets/JNDI&amp;diff=6281&amp;oldid=prev</id>
		<title>Admin: 1 версия</title>
		<link rel="alternate" type="text/html" href="http://www.jexp.ru/index.php?title=Java/Servlets/JNDI&amp;diff=6281&amp;oldid=prev"/>
				<updated>2010-06-01T06:10:57Z</updated>
		
		<summary type="html">&lt;p&gt;1 версия&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;tr style=&quot;vertical-align: top;&quot; lang=&quot;ru&quot;&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Предыдущая&lt;/td&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Версия 06:10, 1 июня 2010&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; style=&quot;text-align: center;&quot; lang=&quot;ru&quot;&gt;&lt;div class=&quot;mw-diff-empty&quot;&gt;(нет различий)&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://www.jexp.ru/index.php?title=Java/Servlets/JNDI&amp;diff=6280&amp;oldid=prev</id>
		<title> в 18:01, 31 мая 2010</title>
		<link rel="alternate" type="text/html" href="http://www.jexp.ru/index.php?title=Java/Servlets/JNDI&amp;diff=6280&amp;oldid=prev"/>
				<updated>2010-05-31T18:01:43Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;== Email JNDI Filter ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
 &lt;br /&gt;
import java.io.IOException;&lt;br /&gt;
import java.io.PrintWriter;&lt;br /&gt;
import javax.naming.Context;&lt;br /&gt;
import javax.naming.InitialContext;&lt;br /&gt;
import javax.naming.NamingException;  &lt;br /&gt;
import javax.mail.*;&lt;br /&gt;
import javax.mail.internet.*;&lt;br /&gt;
import javax.servlet.*;&lt;br /&gt;
import javax.servlet.http.*;&lt;br /&gt;
public class EmailJndiServlet extends HttpServlet {&lt;br /&gt;
  private Session mailSession;&lt;br /&gt;
  public void init() throws ServletException {&lt;br /&gt;
        &lt;br /&gt;
         Context env = null;&lt;br /&gt;
    &lt;br /&gt;
       try{&lt;br /&gt;
           &lt;br /&gt;
             env = (Context) new InitialContext();&lt;br /&gt;
             &lt;br /&gt;
             mailSession = (Session) env.lookup(&amp;quot;MyEmail&amp;quot;);&lt;br /&gt;
             &lt;br /&gt;
             if (mailSession == null)&lt;br /&gt;
                 throw new ServletException(&lt;br /&gt;
                   &amp;quot;MyEmail is an unknown JNDI object&amp;quot;);&lt;br /&gt;
                   &lt;br /&gt;
             //close the InitialContext&lt;br /&gt;
             env.close();&lt;br /&gt;
             &lt;br /&gt;
        } catch (NamingException ne) { &lt;br /&gt;
        &lt;br /&gt;
          try{ env.close();} catch (NamingException nex) { }&lt;br /&gt;
        &lt;br /&gt;
           throw new ServletException(ne);&lt;br /&gt;
        }&lt;br /&gt;
      &lt;br /&gt;
    }&lt;br /&gt;
  public void doPost(HttpServletRequest request, &lt;br /&gt;
      HttpServletResponse response) throws ServletException,&lt;br /&gt;
          java.io.IOException {&lt;br /&gt;
    &lt;br /&gt;
      response.setContentType(&amp;quot;text/html&amp;quot;);&lt;br /&gt;
      java.io.PrintWriter out = response.getWriter();&lt;br /&gt;
      out.println(&lt;br /&gt;
      &amp;quot;&amp;lt;html&amp;gt;&amp;lt;head&amp;gt;&amp;lt;title&amp;gt;Email message sender&amp;lt;/title&amp;gt;&amp;lt;/head&amp;gt;&amp;lt;body&amp;gt;&amp;quot;);&lt;br /&gt;
     &lt;br /&gt;
      String to = request.getParameter(&amp;quot;to&amp;quot;);&lt;br /&gt;
    &lt;br /&gt;
     String from = request.getParameter(&amp;quot;from&amp;quot;);&lt;br /&gt;
      String subject = request.getParameter(&amp;quot;subject&amp;quot;);&lt;br /&gt;
      String emailContent = request.getParameter(&amp;quot;emailContent&amp;quot;);&lt;br /&gt;
         &lt;br /&gt;
      try{&lt;br /&gt;
      &lt;br /&gt;
          sendMessage(to,from,subject,emailContent);&lt;br /&gt;
          &lt;br /&gt;
      } catch(Exception exc){&lt;br /&gt;
      &lt;br /&gt;
          throw new ServletException(exc.getMessage());&lt;br /&gt;
          &lt;br /&gt;
      }&lt;br /&gt;
    &lt;br /&gt;
    &lt;br /&gt;
        out.println(&lt;br /&gt;
        &amp;quot;&amp;lt;h2&amp;gt;The message was sent successfully&amp;lt;/h2&amp;gt;&amp;lt;/body&amp;gt;&amp;lt;/html&amp;gt;&amp;quot;);&lt;br /&gt;
    &lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/body&amp;gt;&amp;lt;/html&amp;gt;&amp;quot;);&lt;br /&gt;
    out.close();&lt;br /&gt;
     } //doPost&lt;br /&gt;
     &lt;br /&gt;
     public void doGet(HttpServletRequest request, &lt;br /&gt;
      HttpServletResponse response) throws ServletException,&lt;br /&gt;
          java.io.IOException {&lt;br /&gt;
          &lt;br /&gt;
              doPost(request,response);&lt;br /&gt;
          &lt;br /&gt;
    }&lt;br /&gt;
     &lt;br /&gt;
  private void sendMessage(String to, String from,String subject, &lt;br /&gt;
    String bodyContent) throws Exception {&lt;br /&gt;
    &lt;br /&gt;
      Message mailMsg = null;&lt;br /&gt;
     &lt;br /&gt;
       synchronized(mailSession){&lt;br /&gt;
       &lt;br /&gt;
          mailMsg = new MimeMessage(mailSession);//a new email message&lt;br /&gt;
       }&lt;br /&gt;
       InternetAddress[] addresses = null;&lt;br /&gt;
    &lt;br /&gt;
       try {&lt;br /&gt;
   &lt;br /&gt;
             if (to != null) {&lt;br /&gt;
        &lt;br /&gt;
                //throws &amp;quot;AddressException&amp;quot; if the &amp;quot;to&amp;quot; email address&lt;br /&gt;
                //violates RFC822 syntax&lt;br /&gt;
                addresses = InternetAddress.parse(to, false);&lt;br /&gt;
                mailMsg.setRecipients(Message.RecipientType.TO, addresses);&lt;br /&gt;
        &lt;br /&gt;
             } else {&lt;br /&gt;
        &lt;br /&gt;
                 throw new MessagingException(&lt;br /&gt;
                     &amp;quot;The mail message requires a &amp;quot;To&amp;quot; address.&amp;quot;);&lt;br /&gt;
        &lt;br /&gt;
            }&lt;br /&gt;
          &lt;br /&gt;
       if (from != null)&lt;br /&gt;
           mailMsg.setFrom(new InternetAddress(from));&lt;br /&gt;
       &lt;br /&gt;
           if (subject != null)&lt;br /&gt;
               mailMsg.setSubject(subject);&lt;br /&gt;
           if (bodyContent != null)&lt;br /&gt;
               mailMsg.setText(bodyContent);&lt;br /&gt;
        &lt;br /&gt;
           //Finally, send the mail message; throws a &amp;quot;SendFailedException&amp;quot; &lt;br /&gt;
           //if any of the message&amp;quot;s recipients have an invalid adress&lt;br /&gt;
           Transport.send(mailMsg);&lt;br /&gt;
        &lt;br /&gt;
            } catch (Exception exc) {&lt;br /&gt;
    &lt;br /&gt;
                throw exc;&lt;br /&gt;
           }&lt;br /&gt;
    }//sendMessage&lt;br /&gt;
    &lt;br /&gt;
}//EmailJndiServlet&lt;br /&gt;
&lt;br /&gt;
           &lt;br /&gt;
         &lt;br /&gt;
  &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== JNDI Filter ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
 &lt;br /&gt;
import java.io.IOException;&lt;br /&gt;
import javax.naming.Context;&lt;br /&gt;
import javax.naming.InitialContext;&lt;br /&gt;
import javax.naming.NamingException;&lt;br /&gt;
import javax.servlet.Filter;&lt;br /&gt;
import javax.servlet.FilterChain;&lt;br /&gt;
import javax.servlet.FilterConfig;&lt;br /&gt;
import javax.servlet.ServletException;&lt;br /&gt;
import javax.servlet.ServletRequest;&lt;br /&gt;
import javax.servlet.ServletResponse;&lt;br /&gt;
import javax.servlet.http.HttpServletRequest;&lt;br /&gt;
import javax.servlet.http.HttpSession;&lt;br /&gt;
public class JndiFilter implements Filter {&lt;br /&gt;
  private FilterConfig config;&lt;br /&gt;
  private Context env;&lt;br /&gt;
  public JndiFilter() {&lt;br /&gt;
  }&lt;br /&gt;
  public void init(FilterConfig filterConfig) throws ServletException {&lt;br /&gt;
    this.config = filterConfig;&lt;br /&gt;
    try {&lt;br /&gt;
      env = (Context) new InitialContext();&lt;br /&gt;
    } catch (NamingException ne) {&lt;br /&gt;
      throw new ServletException(ne);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
  public void doFilter(ServletRequest request, ServletResponse response,&lt;br /&gt;
      FilterChain chain) throws IOException, ServletException {&lt;br /&gt;
    javax.mail.Session mailSession = null;&lt;br /&gt;
    try {&lt;br /&gt;
      mailSession = (javax.mail.Session) env.lookup(&amp;quot;MyEmail&amp;quot;);&lt;br /&gt;
    } catch (NamingException ne) {&lt;br /&gt;
    }&lt;br /&gt;
    HttpServletRequest hRequest = null;&lt;br /&gt;
    if (request instanceof HttpServletRequest) {&lt;br /&gt;
      hRequest = (HttpServletRequest) request;&lt;br /&gt;
      HttpSession hSession = hRequest.getSession();&lt;br /&gt;
      if (hSession != null)&lt;br /&gt;
        hSession.setAttribute(&amp;quot;MyEmail&amp;quot;, mailSession);&lt;br /&gt;
    }//if&lt;br /&gt;
    chain.doFilter(request, response);&lt;br /&gt;
  }// doFilter&lt;br /&gt;
  public void destroy() {&lt;br /&gt;
    /*&lt;br /&gt;
     * called before the Filter instance is removed from service by the web&lt;br /&gt;
     * container&lt;br /&gt;
     */&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
           &lt;br /&gt;
         &lt;br /&gt;
  &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Servlet JNDI and Bean ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
 &lt;br /&gt;
import javax.naming.Context;&lt;br /&gt;
import javax.naming.InitialContext;&lt;br /&gt;
import javax.naming.NamingException;&lt;br /&gt;
import javax.servlet.ServletException;&lt;br /&gt;
import javax.servlet.http.HttpServlet;&lt;br /&gt;
import javax.servlet.http.HttpServletRequest;&lt;br /&gt;
import javax.servlet.http.HttpServletResponse;&lt;br /&gt;
public class BeanServlet extends HttpServlet {&lt;br /&gt;
  private StockPriceBean spbean;&lt;br /&gt;
  public void init() throws ServletException {&lt;br /&gt;
    Context env = null;&lt;br /&gt;
    try {&lt;br /&gt;
      // Compile error since there is no StockPriceBean.class&lt;br /&gt;
      // change the name according to your requirements&lt;br /&gt;
      env = (Context) new InitialContext().lookup(&amp;quot;java:comp/env&amp;quot;);&lt;br /&gt;
      spbean = (StockPriceBean) env.lookup(&amp;quot;bean/pricebean&amp;quot;);&lt;br /&gt;
      //close the InitialContext&lt;br /&gt;
      env.close();&lt;br /&gt;
      if (spbean == null)&lt;br /&gt;
        throw new ServletException(&lt;br /&gt;
            &amp;quot;bean/pricebean is an unknown JNDI object&amp;quot;);&lt;br /&gt;
    } catch (NamingException ne) {&lt;br /&gt;
      try {&lt;br /&gt;
        env.close();&lt;br /&gt;
      } catch (NamingException nex) {&lt;br /&gt;
      }&lt;br /&gt;
      throw new ServletException(ne);&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
  public void doGet(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws ServletException, java.io.IOException {&lt;br /&gt;
    //set the MIME type of the response, &amp;quot;text/html&amp;quot;&lt;br /&gt;
    response.setContentType(&amp;quot;text/html&amp;quot;);&lt;br /&gt;
    //use a PrintWriter send text data to the client who has requested the&lt;br /&gt;
    // servlet&lt;br /&gt;
    java.io.PrintWriter out = response.getWriter();&lt;br /&gt;
    //Begin assembling the HTML content&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;html&amp;gt;&amp;lt;head&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;title&amp;gt;Stock Price Fetcher&amp;lt;/title&amp;gt;&amp;lt;/head&amp;gt;&amp;lt;body&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;h2&amp;gt;Please submit a valid stock symbol&amp;lt;/h2&amp;gt;&amp;quot;);&lt;br /&gt;
    //make sure method=&amp;quot;post&amp;quot; so that the servlet service method&lt;br /&gt;
    //calls doPost in the response to this form submit&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;form method=\&amp;quot;post\&amp;quot; action =\&amp;quot;&amp;quot;&lt;br /&gt;
        + request.getContextPath() + &amp;quot;/namingbean\&amp;quot; &amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;table border=\&amp;quot;0\&amp;quot;&amp;gt;&amp;lt;tr&amp;gt;&amp;lt;td valign=\&amp;quot;top\&amp;quot;&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;Stock symbol: &amp;lt;/td&amp;gt;  &amp;lt;td valign=\&amp;quot;top\&amp;quot;&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;input type=\&amp;quot;text\&amp;quot; name=\&amp;quot;symbol\&amp;quot; size=\&amp;quot;10\&amp;quot;&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/td&amp;gt;&amp;lt;/tr&amp;gt;&amp;lt;tr&amp;gt;&amp;lt;td valign=\&amp;quot;top\&amp;quot;&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;input type=\&amp;quot;submit\&amp;quot; value=\&amp;quot;Submit Info\&amp;quot;&amp;gt;&amp;lt;/td&amp;gt;&amp;lt;/tr&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/table&amp;gt;&amp;lt;/form&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/body&amp;gt;&amp;lt;/html&amp;gt;&amp;quot;);&lt;br /&gt;
    out.close();&lt;br /&gt;
  } //end doGet&lt;br /&gt;
  public void doPost(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws java.io.IOException {&lt;br /&gt;
    String symbol;//this will hold the stock symbol&lt;br /&gt;
    float price = 0f;&lt;br /&gt;
    symbol = request.getParameter(&amp;quot;symbol&amp;quot;);&lt;br /&gt;
    boolean isValid = (symbol == null || symbol.length() &amp;lt; 1) ? false&lt;br /&gt;
        : true;&lt;br /&gt;
    //set the MIME type of the response, &amp;quot;text/html&amp;quot;&lt;br /&gt;
    response.setContentType(&amp;quot;text/html&amp;quot;);&lt;br /&gt;
    //use a PrintWriter send text data to the client who has requested the&lt;br /&gt;
    // servlet&lt;br /&gt;
    java.io.PrintWriter out = response.getWriter();&lt;br /&gt;
    //Begin assembling the HTML content&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;html&amp;gt;&amp;lt;head&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;title&amp;gt;Latest stock value&amp;lt;/title&amp;gt;&amp;lt;/head&amp;gt;&amp;lt;body&amp;gt;&amp;quot;);&lt;br /&gt;
    if ((!isValid) || spbean == null) {&lt;br /&gt;
      out.println(&amp;quot;&amp;lt;h2&amp;gt;Sorry, the stock symbol parameter was either empty or null&amp;lt;/h2&amp;gt;&amp;quot;);&lt;br /&gt;
    } else {&lt;br /&gt;
      out.println(&amp;quot;&amp;lt;h2&amp;gt;Here is the latest value of &amp;quot; + symbol + &amp;quot;&amp;lt;/h2&amp;gt;&amp;quot;);&lt;br /&gt;
      spbean.setSymbol(symbol);&lt;br /&gt;
      price = spbean.getLatestPrice();&lt;br /&gt;
      out.println((price &amp;lt; 1 ? &amp;quot;The symbol is probably invalid.&amp;quot; : &amp;quot;&amp;quot;&lt;br /&gt;
          + price));&lt;br /&gt;
    }&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/body&amp;gt;&amp;lt;/html&amp;gt;&amp;quot;);&lt;br /&gt;
  }// doPost&lt;br /&gt;
}//BeanServlet&lt;br /&gt;
&lt;br /&gt;
           &lt;br /&gt;
         &lt;br /&gt;
  &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Use JNDI to get database connection or data source ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
 &lt;br /&gt;
 &lt;br /&gt;
import java.io.IOException;&lt;br /&gt;
import java.io.PrintWriter;&lt;br /&gt;
import java.sql.Connection;&lt;br /&gt;
import java.sql.PreparedStatement;&lt;br /&gt;
import java.sql.ResultSet;&lt;br /&gt;
import java.sql.SQLException;&lt;br /&gt;
import java.text.DateFormat;&lt;br /&gt;
import java.text.SimpleDateFormat;&lt;br /&gt;
import java.util.Date;&lt;br /&gt;
import javax.naming.InitialContext;&lt;br /&gt;
import javax.naming.NamingException;&lt;br /&gt;
import javax.servlet.Servlet;&lt;br /&gt;
import javax.servlet.ServletException;&lt;br /&gt;
import javax.servlet.http.HttpServlet;&lt;br /&gt;
import javax.servlet.http.HttpServletRequest;&lt;br /&gt;
import javax.servlet.http.HttpServletResponse;&lt;br /&gt;
import javax.sql.DataSource;&lt;br /&gt;
public class Main extends HttpServlet implements Servlet {&lt;br /&gt;
  protected void doGet(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws ServletException, IOException {&lt;br /&gt;
    DateFormat dateFormat = new SimpleDateFormat(&amp;quot;dd/MM/yyyy&amp;quot;);&lt;br /&gt;
    response.setContentType(&amp;quot;text/html&amp;quot;);&lt;br /&gt;
    PrintWriter writer = response.getWriter();&lt;br /&gt;
    Connection connection = getConnection();&lt;br /&gt;
    if (connection != null) {&lt;br /&gt;
      String sql = &amp;quot;SELECT SYSDATE FROM DUAL&amp;quot;;&lt;br /&gt;
      try{&lt;br /&gt;
      PreparedStatement statement = connection.prepareStatement(sql);&lt;br /&gt;
      ResultSet rs = statement.executeQuery();&lt;br /&gt;
      while (rs.next()) {&lt;br /&gt;
        Date date = rs.getDate(&amp;quot;SYSDATE&amp;quot;);&lt;br /&gt;
        writer.println(&amp;quot;The current date is &amp;quot; + dateFormat.format(date));&lt;br /&gt;
      }&lt;br /&gt;
      connection.close();&lt;br /&gt;
      }catch(Exception e){&lt;br /&gt;
        System.out.println(e);&lt;br /&gt;
      }&lt;br /&gt;
    }&lt;br /&gt;
  }&lt;br /&gt;
  protected void doPost(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws ServletException, IOException {&lt;br /&gt;
  }&lt;br /&gt;
  private Connection getConnection() {&lt;br /&gt;
    Connection connection = null;&lt;br /&gt;
    try {&lt;br /&gt;
      InitialContext context = new InitialContext();&lt;br /&gt;
      DataSource dataSource = (DataSource) context.lookup(&amp;quot;jdbc/DataSource&amp;quot;);&lt;br /&gt;
      connection = dataSource.getConnection();&lt;br /&gt;
    } catch (NamingException e) {&lt;br /&gt;
      e.printStackTrace();&lt;br /&gt;
    } catch (SQLException e) {&lt;br /&gt;
      e.printStackTrace();&lt;br /&gt;
    }&lt;br /&gt;
    return connection;&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Web JNDI ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
 &lt;br /&gt;
import javax.naming.Context;&lt;br /&gt;
import javax.naming.InitialContext;&lt;br /&gt;
import javax.naming.NamingException;&lt;br /&gt;
import javax.rmi.PortableRemoteObject;&lt;br /&gt;
import javax.servlet.ServletException;&lt;br /&gt;
import javax.servlet.http.HttpServlet;&lt;br /&gt;
import javax.servlet.http.HttpServletRequest;&lt;br /&gt;
import javax.servlet.http.HttpServletResponse;&lt;br /&gt;
public class WebJndiServlet extends HttpServlet {&lt;br /&gt;
  public void doGet(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws ServletException, java.io.IOException {&lt;br /&gt;
    String state = request.getParameter(&amp;quot;state&amp;quot;);&lt;br /&gt;
    Context env = null;&lt;br /&gt;
    Abbrev abbrev = null;&lt;br /&gt;
    AbbrevHome home = null;&lt;br /&gt;
    try {&lt;br /&gt;
      env = (Context) new InitialContext();&lt;br /&gt;
      Object localH = env.lookup(&amp;quot;AbbrevHome&amp;quot;);&lt;br /&gt;
      home = (AbbrevHome) PortableRemoteObject.narrow(localH,&lt;br /&gt;
          AbbrevHome.class);&lt;br /&gt;
      //close the InitialContext&lt;br /&gt;
      env.close();&lt;br /&gt;
      if (home == null)&lt;br /&gt;
        throw new ServletException(&lt;br /&gt;
            &amp;quot;AbbrevHome is an unknown JNDI object&amp;quot;);&lt;br /&gt;
      abbrev = (Abbrev) PortableRemoteObject.narrow(home.create(),&lt;br /&gt;
          Abbrev.class);&lt;br /&gt;
    } catch (NamingException ne) {&lt;br /&gt;
      try {&lt;br /&gt;
        env.close();&lt;br /&gt;
      } catch (NamingException nex) {&lt;br /&gt;
      }&lt;br /&gt;
      throw new ServletException(ne);&lt;br /&gt;
    } catch (javax.ejb.CreateException ce) {&lt;br /&gt;
      throw new ServletException(ce);&lt;br /&gt;
    }&lt;br /&gt;
    //set the MIME type of the response, &amp;quot;text/html&amp;quot;&lt;br /&gt;
    response.setContentType(&amp;quot;text/html&amp;quot;);&lt;br /&gt;
    //use a PrintWriter send text data to the client who has requested the&lt;br /&gt;
    // servlet&lt;br /&gt;
    java.io.PrintWriter out = response.getWriter();&lt;br /&gt;
    //Begin assembling the HTML content&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;html&amp;gt;&amp;lt;head&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;title&amp;gt;State abbreviations&amp;lt;/title&amp;gt;&amp;lt;/head&amp;gt;&amp;lt;body&amp;gt;&amp;quot;);&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;h2&amp;gt;Here is the state&amp;quot;s abbreviation&amp;lt;/h2&amp;gt;&amp;quot;);&lt;br /&gt;
    if (state != null)&lt;br /&gt;
      out.println(abbrev.getAbbreviation(state.toUpperCase()));&lt;br /&gt;
    try {&lt;br /&gt;
      abbrev.remove();&lt;br /&gt;
    } catch (javax.ejb.RemoveException re) {&lt;br /&gt;
    }&lt;br /&gt;
    out.println(&amp;quot;&amp;lt;/body&amp;gt;&amp;lt;/html&amp;gt;&amp;quot;);&lt;br /&gt;
    out.close();&lt;br /&gt;
  } //end doGet&lt;br /&gt;
  public void doPost(HttpServletRequest request, HttpServletResponse response)&lt;br /&gt;
      throws ServletException, java.io.IOException {&lt;br /&gt;
    doGet(request, response);&lt;br /&gt;
  }// doPost&lt;br /&gt;
}//BeanServlet&lt;br /&gt;
&lt;br /&gt;
           &lt;br /&gt;
         &lt;br /&gt;
  &amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;/div&gt;</summary>
			</entry>

	</feed>