Kode Java

 
package org.kodejava.example.jndi;
 
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
 
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.Servlet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
 
public class JNDITestServlet extends HttpServlet implements Servlet {
 
    protected void doGet(HttpServletRequest request,
	    HttpServletResponse response) throws ServletException, IOException {
	//
	// This implementation of doGet method show us an example to use
	// connection obatained in the getConnection() method.
	//
 
	DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
 
	response.setContentType("text/html");
	PrintWriter writer = response.getWriter();
 
	Connection connection = getConnection();
	if (connection != null) {
	    try {
		//
		// A query to get current date time from Oracle database
		//
		String sql = "SELECT SYSDATE FROM DUAL";
		PreparedStatement statement = connection.prepareStatement(sql);
		ResultSet rs = statement.executeQuery();
 
		while (rs.next()) {
		    Date date = rs.getDate("SYSDATE");
		    writer.println("The current date is "
			    + dateFormat.format(date));
		}
	    } catch (SQLException e) {
		e.printStackTrace();
	    } finally {
		try {
		    if (!connection.isClosed()) {
			connection.close();
		    }
		} catch (SQLException e) {
		    e.printStackTrace();
		}
	    }
	}
    }
 
    protected void doPost(HttpServletRequest request,
	    HttpServletResponse response) throws ServletException, IOException {
    }
 
    /**
     * Get a database connection from the registered data source in the servlet
     * container. To registered the JNDI data source you should refer to your
     * servlet container documentation.
     * 
     * @return a database connection
     */
    private Connection getConnection() {
	Connection connection = null;
	try {
	    InitialContext context = new InitialContext();
	    DataSource dataSource = (DataSource) context
		    .lookup("jdbc/DataSource");
	    connection = dataSource.getConnection();
	} catch (NamingException e) {
	    e.printStackTrace();
	} catch (SQLException e) {
	    e.printStackTrace();
	}
	return connection;
    }
}
 
 

• How do I convert String to Date object?
• How do I convert array to collection?
• How do I get day, month, year value from the current date?
• How do I read a text file?
• How do I format a number?
• How do I get the current month name?
• How do I use StringTokenizer to split a string?
• How do I convert collection into array?
• How do I do a date add or substract?
• How do I write string data to file?

• How do I reverse a string?
• What need to be prepared for learning Java Programming?
• How do I implement a Singleton pattern?
• How do I split a string?
• How do I read text file content line by line using commons-io?
• How do I create a zip file?
• How do I calculate days difference between two dates?
• Hello World example in Java
• How do I create a connection to database?
• How do I create a beep sound?

• Java Programming Keywords Summary
• How do I read an XML document using JDOM?
• How do I sort items of an ArrayList?
• How do I sort array values in case insensitive order?
• How do I sort array values in descending order?
• How do I limit the Hibernate query result?
• How do I store properties as XML file?
• How do I load properties from XML file?
• How do I convert InputStream to String?
• How do I convert string into InputStream?

• How do I determine bean's property type?
• How do I read mapped bean's property value?
• How do I read indexed bean's property value?
• How do I read bean's nested property value?
• How do I read bean's property value?
• How do I find text between two strings?
• How do I check for an empty string?
• How do I get the nearest hour, minute, second of a date?
• How do I format date and time using DateFormatUtils class?
• How do I find items in an array?