JSP,DB,SERVLET

hi thank you for your reply.With this code i can insert the data successfully into database but In ajax.jsp once i give the name;;;age and city are not automatically fetched......instead sumthing get filled in dose textfields....can u help me??????

Name: Ram I entered dtls of ram into database...once i give ram age n city r populated lyk dis....help me....

Age: Tahoma,Arial,sans-serif;color City: white;background-color Phone No:

Code u sent to me::

1)insert.jsp:

<%@page import="java.sql.*"%>

Name:
Age:
City:

3)AjaxServlet.java:

import java.io.; import javax.servlet.; import javax.servlet.http.; import java.sql.;

public class AjaxServlet extends HttpServlet { public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { res.setContentType("text/html"); PrintWriter out = res.getWriter(); String name = req.getParameter("name").toString(); System.out.println(name); String data =""; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:student"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from data where name='"+name+"'"); while(rs.next()) { data =":"+Integer.toString(rs.getInt("age")) + ":" + rs.getString("city"); }

out.println(data); System.out.println(data); } catch (Exception e) { System.out.println(e); } } }

2)ajax.jsp:

<%@ page import="java.sql.*" %> <% String name=request.getParameter("name"); if(name!=null){ int age=Integer.parseInt(request.getParameter("age")); String city=request.getParameter("city"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:student"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into data(name,age, city) values('"+name+"',"+age+",'"+city+"')"); con.close(); }

%>

Name:
Age:
City:
Phone No: