How to retrieve value from database

[ajjukumar]

Can any one tell me how to retrieve values from database? i got the column names of the table but i don't know how to get the particular value from data base
this is my code
submit.jsp:

<html>
    <body>
        <form action="EmpDeligator" method="get">
            <input type="text" name="empid"/>
            <input type="SUBMIT" name="submit"/>

        </form>
    </body>
</html>

[U]EmpDeligator.java[/U]

 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */


import DataBase.EmpDetails;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * 
 */
public class EmpDeligator extends HttpServlet {

    /** 
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
       int colcount = 0;
       
             String ss = request.getParameter("empid");
             ResultSet rs = EmpDetails.gettingString(ss);
                    try{
   ResultSetMetaData  rsmd = rs.getMetaData();
   colcount = rsmd.getColumnCount();

   out.println("<table border = 1>");

   for(int iu = 0; iu<colcount; iu++){
       out.println("<td>"+rsmd.getColumnName(iu+1));
        }out.println("<tr>");
    }catch(Exception e){}

              for(int iu = 0; iu<colcount; iu++){
            try {
                out.println("<td>" + rs.getString(iu + 1));
                out.println("<tr>");
            } catch (SQLException ex) {
                ex.printStackTrace();
            }

              }

[U]EmpDetails.java[/U]
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package DataBase;
import java.sql.*;
/**
 *
 * @author harikrishna
 */
public class EmpDetails
{
    public static ResultSet gettingString(String str)
     {
        int txtempno;
         String sqlstr;
         ResultSet rs=null;
         try
        {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con=DriverManager.getConnection("jdbc:odbc:demo","sysman","ajaykumar");
         Statement stmt=con.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
         sqlstr="select * from employee_log where empid = "+str;

                rs=stmt.executeQuery(sqlstr);


        }catch(Exception se)
        {
            se.printStackTrace();
        }

         return rs;
     }


}
[U]Table.jsp[/U]
<%-- 
    Document   : Table
    Created on : May 29, 2010, 11:15:22 AM
    Author     : harikrishna
--%>
<%@page import="java.sql.*;" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
   <table>
   <%
   ResultSet rs=(ResultSet) session.getAttribute("rs");
   ResultSetMetaData  rsmd = rs.getMetaData();
   int colcount = rsmd.getColumnCount();

   for(int iu = 0; iu< colcount;iu++)
       {%>

<td><%=rsmd.getColumnName(iu)%>

<%
}out.println("<tr>");
%>


<table>
</html>

In the "Table.jsp" i got the code for getting the column but i dnt know how to get the particular value into jsp

please help me friends i have struc here.....