Consider a situation where we want to know about the number of rows in the particular database table without touching our database. As we are the programmers so why we should worry about the database complexities. We want to find out the number of rows without going touching our back- end.
In this example we are going to exactly the same as we said above. To make this possible we need to make a class named ServletGettingNoOfRows, the name of the program should be such, if in future there is any need to make any change in the program, you can easily understand in which program you have to make a change. As we know that in Servlet the main logic of the program is written inside the service method and in turn the service method calls the doGet() method. Now inside the doGet() method use the getWriter() method of the response object and its returns the PrintWriter object, which helps us to write on the browser. To get the number of rows from the database table there is a need for the connection between the database and the java program. After the establishment of the connection with the database, fire a query for selecting the number of rows from the database table inside the executeQuery() method of the PreparedStatement object and returns the ResultSet object. Now we have the ResultSet object, by the help of this object we can get the number of rows we have in the database table. The number of rows we have in the database table will be displayed on the browser by the PrintWriter object.
The code of the program is given below:
XML File for this program:
Table emp_sal in the database:
|mysql> select * from emp_sal;
| EmpName | salary |
| zulfiqar | 15000 |
| vinod | 12000 |
2 rows in set (0.05 sec)
The output of the program is given below:
Rs. 20,000 US$ 300
Today: Rs. 10,000 US$150
Course Duration: 30 hrs
Posted on: July 17, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles