displaying data retrieved from a database in a jsp page

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(" "+title+"\n"); out.write(" \n"); out.write(" "); Developing Enterprise-wide Applications - II (Java Technologies) Assignment A.9 String dateStr = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:mydsn","sa","password@123"); String sql = "select billid, customerid, billdate, status from customerbills where customer_id=? and status='UnPaid'"; PreparedStatement stmt = conn.prepareStatement(sql); stmt.setString(1, custId); ResultSet rs = stmt.executeQuery(); if (rs.next()) { Date date = rs.getDate(3); dateStr = DateFormat.getDateInstance(DateFormat.MEDIUM).format(date); } conn.close(); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); }

View Answers

March 12, 2011 at 3:45 PM

<%@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>

July 21, 2011 at 11:55 AM

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 button. 3.In the same viewTR.jsp file, i have to display the Nodename and packageno.

i.e.,select nodename,packageno from TR_list where TR='xxx';

Plz help me