Data not getting retrieved from database table with below code , What going wrong pls advise.........
HTML Code:<%@ page language="java" import="java.sql.*;"%> <html> <head> <style> A:hover { text-decoration: none; font-family:arial; font-size:12px; color: #000000; BORDER: none; } A { text-decoration: underline; font-family:arial; font-size:12px; color: #000000; BORDER: none; } </style> </head> <body> <br><br><br> <% Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "bank"; String driver = "com.mysql.jdbc.Driver"; String username = "root"; String userPassword = "java"; String color = "#F9EBB3"; String date = request.getParameter("value"); try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url + dbName, username, userPassword); Statement st = conn.createStatement(); String strQuery = "select * from transaction"; ResultSet rs = st.executeQuery(strQuery); %> <table width="600px" align="center" style="border:1px solid #000000;" > <tr><td><b>Transaction ID :</b></td><td><%=rs.getInt("transactionId")%></td></tr> <tr><td><b>Acc No. :</b></td><td><%=rs.getInt("accountNo")%></td></tr> <tr><td><b>Additional Information :</b></td><td><%=rs.getString("addInfo")%></td></tr> </table> <br><br><br> <table width="600px" align="center" > <tr><td align="center"><input type="submit" name="Submit" value="Save As Draft"></td> <td align="center"><input type="submit" name="Submit" value="Sent TO RBI"></td> <td align="center"><input type="submit" name="Submit" value="PRINT"></td></tr> <% System.out.println("Connected to the database"); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { e.printStackTrace(); } %> </table> </body> </html>