How many records are present in database using JSP

//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

<%@ page import="java.sql.*" %>

<%
try
{       
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}     
catch(ClassNotFoundException e)
{        
out.println("Class not found "+ e);  
}     
out.println("JDBC Class found");  
int no_of_rows = 0;
try
{   
Connection con = DriverManager.getConnection("jdbc:odbc:mydsn","system","pintu");
Statement stmt = con.createStatement(); 
ResultSet rs = stmt.executeQuery("SELECT * FROM employee");   
while (rs.next())
{           
no_of_rows++;  
}         
out.println("There are "+ no_of_rows + " record in the table"); 
}     
catch(SQLException e){
out.println("SQL exception occured" + e); 
}

%>

Ebook Download
View all
Learn
View all