pg2.jsp

<%@page import="java.awt.print.Printable"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Date"%>
<%@ page import="javax.servlet.http.HttpServlet"%>
<%@ page import="javax.servlet.http.HttpServletRequest"%>
<%@ page import="javax.servlet.http.HttpServletResponse"%>
<%@ page import="javax.servlet.http.HttpSession"%>
<%@ page import="javax.servlet.RequestDispatcher"%>
<%
int ph=Integer.parseInt(request.getParameter("ph"));
String str;
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/satish","root","root");
Statement st=null;
ResultSet rs=null;
String s="SELECT * FROM details WHERE ph_no="+ph;
st=conn.createStatement();
rs=st.executeQuery(s);
if(rs.next())
{
java.sql.Date dbSqlDate = rs.getDate(5);
str=rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+","+rs.getString(4)+","+dbSqlDate.toString()+","+rs.getString(6)+","+rs.getString(7)+","+rs.getString(8);
session.setAttribute("data",str);
}
conn.close();
RequestDispatcher rd = request.getRequestDispatcher("pg1.jsp");
rd.forward(request, response);
}
catch(Exception e)
{out.println(e);}
%>