Count Records Using the Prepared Statement

package example.preparedstatement;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
public class CountRecordsUsingPreparedStatement {
    public static Connection getConnection() throws Exception {
	String driver = "oracle.jdbc.driver.OracleDriver";
	String url = "jdbc:oracle:thin:@localhost:1521:databaseName";
	String username = "name";
	String password = "password";
	Class.forName(driver);
	Connection conn = DriverManager.getConnection(url, username, password);
	return conn;
    }
 
    public static void main(String[] args) {
	ResultSet rs = null;
	Connection conn = null;
	PreparedStatement pstmt = null;
	try {
	    conn = getConnection();
	    String query = "select count(*) from tableName";
	    pstmt = conn.prepareStatement(query);
	    rs = pstmt.executeQuery();
	    if (rs.next()) {
		int numberOfRows = rs.getInt(1);
		System.out.println("numberOfRows= " + numberOfRows);
	    } else {
		System.out.println("error: could not get the record counts");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	} finally {
	    try {
		rs.close();
		pstmt.close();
		conn.close();
	    } catch (SQLException e) {
		e.printStackTrace();
	    }
	}
    }
}