1
this is my code
submit.jsp:
Expand|Select|Wrap|Line Numbers
- <html>
- <body>
- <form action="EmpDeligator" method="get">
- <input type="text" name="empid"/>
- <input type="SUBMIT" name="submit"/>
- </form>
- </body>
- </html>
- EmpDeligator.java
- * 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();
- }
- }
- EmpDetails.java
- /*
- * 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;
- }
- }
- Table.jsp
- <%--
- 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>
please help me friends i have struc here.....
