Introduction

//To know how many records are present in database using jsp
To see total listing of .jsp files first we have to configure the web.xml file present in (E:\Program Files\Apache Software Foundation\Tomcat 6.0\conf) folder.Search the <param-name>listings</param-name> tag and below this tag <param-value>false</param-value>,change the value to true(<param-value>true</param-value>)
Create any folder in (E:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps)and save the below program as totalrecords.jsp
  1. <%@ page import="java.sql.*" %>
  2. <%
  3. try
  4. {
  5. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  6. }
  7. catch(ClassNotFoundException e)
  8. {
  9. out.println("Class not found "+ e);
  10. }
  11. out.println("JDBC Class found");
  12. int no_of_rows = 0;
  13. try
  14. {
  15. Connection con = DriverManager.getConnection("jdbc:odbc:mydsn","system","pintu");
  16. Statement stmt = con.createStatement();
  17. ResultSet rs = stmt.executeQuery("SELECT * FROM employee");
  18. while (rs.next())
  19. {
  20. no_of_rows++;
  21. }
  22. out.println("There are "+ no_of_rows + " record in the table");
  23. }
  24. catch(SQLException e){
  25. out.println("SQL exception occured" + e);
  26. }
  27. %>