JSP,DB,SERVLET

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:


View Answers

December 10, 2010 at 5:36 PM

Hello Friend,

Please go through the following link:

Visit Here

Thanks









Related Tutorials/Questions & Answers:
JSP,DB,SERVLET
JSP,DB,SERVLET  I have a jsp page with 3 text fields name,age ,city.i populated these datas into a database table.I have another jsp page with 4... be automatically populated from database throush servlet..Can u give me the code
JSP,DB,SERVLET
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
Advertisements
JSP,DB,SERVLET
JSP,DB,SERVLET  I have a jsp page called page1.jsp with 3 text fields name,phone ,city.i populated these datas into a database table through servlet (page1servlet.java) and bean(page1bean.java).I have another jsp page(display.jsp
JSP,DB,SERVLET
JSP,DB,SERVLET  hi thank you for your reply.With this code i can insert the data successfully into database but once i give submit button... servlet Code u sent to me::ADS_TO_REPLACE_1 1)insert.jsp: <%@page import

Ads