
the page should display username, emailid, telephone in addition to tthe tagline however none of the required information is displayed except the tagline
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); String title = request.getParameter("PageTitle"); try { response.setContentType("text/html;charset=UTF-8"); response.setHeader("X-Powered-By", "JSP/2.1"); out.write("\n"); out.write("
\n"); out.write(" \n"); out.write("
<%@page import="java.sql.*"%>
<table border=1>
<tr><th>Name</th><th>Age</th><th>Address</th><th>Phone No</th></tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student","","");
String sql = "select * from data where id= ?";
PreparedStatement stmt = con.prepareStatement(sql);
stmt.setInt(1, 1);
ResultSet rs = stmt.executeQuery();
if(rs.next()){
%>
<tr><td><%=rs.getString("name")%></td><td><%=rs.getInt("Age")%></td><td><%=rs.getString("address")%></td><td><%=rs.getInt("phoneNo")%></td></tr>
<%
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e){
System.out.println(e);
}
%>
</table>

hi, great job. I have the same problem.plz help me.
I have MySQL DataBase/DB Name:lokesh
Table Name:TR_list
columns:nodename,packageno,TR
Values(crs,cs 4.0,xxx)
Values(sdp,cs 5.0,yyy)
Values(air,cs 6.0,zzz)
i want to create a viewTR.jsp file in netbeans IDE,
where i have to :
1.connect to DB in MYSQL and
2.TR List:input Text Box and
i.e.,select nodename,packageno from TR_list where TR='xxx';
Plz help me