Untitled

<!--jsp-->
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.Date"%>
<html>
<body>
<%
int ph=Integer.parseInt(request.getParameter("ph"));
String nm,fnm,gen,eml,dts,uid,pwd;
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);
	  uid=rs.getString(1);
	  pwd=rs.getString(2);
	  nm=rs.getString(3);
	  fnm=rs.getString(4);
	  dts=rs.getString(5);
	  gen=rs.getString(6);
	  ph=rs.getInt(7);
	  eml=rs.getString(8);
	  conn.close();
	}catch(Exception e){
		out.println(e);
		}

 %>
<label><b>User ID</b></label>
 <input type="text" name="uid" value="<%=uid%>"><br>
 <label><b>Password</b></label>
 <input type="text" name="pwd" value="<%=pwd%>"><br>
 <label><b>Name: </b></label>
 <input type="text" name="name" value="<%=nm%>">
 <label><b>Father's Name</b></label>
 <input type="text" name="fname" value="<%=fnm%>">
 <label><b>D.O.B</b></label>
 <input type="text" name="dt" value="<%=dts%>">
 <label><b>Gender</b></label>
 <input type="text" name="gen" value="<%=gen%>">
 <label><b>Phone</b></label>
 <input type="text" name="ph" onkeypress="return event.charCode >= 48 &amp;&amp; event.charCode <= 57" value="<%=ph%>">
 <label><b>Email</b></label>
 <input type="text" name="eml" value="<%=eml%>">
</body>
</html>
<!-->
<html>
<head>
<meta charset="ISO-8859-1">
</head>
<body>
<form action="disp.jsp" method=GET>
<label><b>Phone</b></label>
 <input type="text" name="ph" onkeypress="return event.charCode >= 48 &amp;&amp; event.charCode <= 57">
 <button type="submit" class="signupbtn">Submit</button>
</form>
</body>
</html>