Untitled

package employee;


import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class EntryServlet extends HttpServlet
{
	/**
	 *
	 */


	public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
	{

		Connection conn;
		Statement st;
		int rs=0;
		PrintWriter out = response.getWriter();


	    	   try {
				Class.forName("com.mysql.jdbc.Driver").newInstance();

				conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");

				st = conn.createStatement();

				String query1="select * from location_details";
				   PreparedStatement ps=conn.prepareStatement(query1);
				ResultSet result=ps.executeQuery();

				   while(result.next() )
				   {
				     String getdate = result.getString("LOC_NAME");
				     out.println("<br>"+getdate);
				    }
			} catch (InstantiationException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IllegalAccessException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		/*String id = request.getParameter("EmpID");
		int id1 = Integer.parseInt(id);
		String name = request.getParameter("EmpName");
		 String job = request.getParameter("Job");
		 String sal = request.getParameter("Sal");
		 float sal1 = Float.parseFloat(sal);

		 writeDB(id1,name,job,sal1);

		 ((ServletResponse) request).setContentType("text/html");
		PrintWriter pw = ((ServletResponse) request).getWriter();

		pw.println("<HTML><body><b> your data was added </b></body></html>");*/


	}


}