Kode Java

 
package org.kodejava.example.servlet;
 
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics2D;
import java.awt.RenderingHints;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class HitCounter extends HttpServlet {
	public HitCounter() {
		super();
	}   	
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		updateHitCounter();
		getHitCounterImage(request, response);
	}  	
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		updateHitCounter();
		getHitCounterImage(request, response);
	}
 
	private void updateHitCounter() {
		Connection connection = getConnection();
		try {
			// 
			// Update the hits counter table by incrementing the counter every time
			// a user hits our page.
			//
			String sql = "UPDATE hits SET counter = counter + 1";
			PreparedStatement stmt = connection.prepareStatement(sql);
			stmt.executeUpdate();			
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			closeConnection(connection);
		}
	}
	
	private void getHitCounterImage(HttpServletRequest request, HttpServletResponse response) throws IOException {
		Connection connection = getConnection();
		String hits = "";
		try {
			// 
			// Get the current hits counter from database.
			//
			String sql = "SELECT counter FROM hits";
			PreparedStatement stmt = connection.prepareStatement(sql);
			ResultSet rs = stmt.executeQuery();
			while (rs.next()) {
				hits = rs.getString("counter");
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			closeConnection(connection);
		}
		
		// 
		// Create an image of our counter to be sent to the browser.
		//
		BufferedImage buffer = new BufferedImage(50, 20, BufferedImage.TYPE_INT_RGB);
		Graphics2D g = buffer.createGraphics();
		g.setRenderingHint(RenderingHints.KEY_ANTIALIASING, RenderingHints.VALUE_ANTIALIAS_ON);
		g.setFont(new Font("Monospaced", Font.PLAIN, 14));
		g.setColor(Color.WHITE);
		g.fillRect(0, 0, 50, 20);
		g.setColor(Color.BLACK);
		g.drawString(hits, 0, 20);
		
		response.setContentType("image/png");
		OutputStream os = response.getOutputStream();
		ImageIO.write(buffer, "png", os);
		os.close();
	}
	
	private Connection getConnection() {
		Connection connection = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection("jdbc:mysql://localhost/sampledb", "root", "");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return connection;
	}
	
	private void closeConnection(Connection connection) {
		try {
			if (connection != null && !connection.isClosed()) {
				connection.close();	
			}
		} catch (SQLException e) {
			e.printStackTrace();			
		}
	}
}
 
 

• 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?