This is my database code:
This is the JSP:
How can I do this?
Code:
public List getListingData() {
//clear the list
managerList.clear();
//fill the list with new data
try {
open();
try {
CallableStatement cs = null;
String query = "{ call CP_LISTINGS.Get_Listings(?,?,?,?,?,?,?,?,?,?,?) }";
cs = conn.prepareCall(query);
cs.setInt(1, getEntityId());//294677);//entityId);
cs.setString(2, getUserType());//"Agent");//userType);
cs.setString(3, "Listing_View");//Listing View Data Set
cs.setInt(4, 1);//Default to page 1
cs.setInt(5, 25);//default to 25
cs.setString(6, "");//"Agent");Order By
cs.setString(7, "");//"Agent");//Filter By
// register the type of the out param - an Oracle specific type
cs.registerOutParameter(8, java.sql.Types.SMALLINT);//total count<<-- [B]i NEED THIS VALUE TO APPEAR ON MY JSP[/B]
cs.registerOutParameter(9, java.sql.Types.SMALLINT);//flag, value 0 if all OK
cs.registerOutParameter(10, java.sql.Types.VARCHAR);//error message
cs.registerOutParameter(11, OracleTypes.CURSOR);//the ResultSet returned
//logger.warning("Query is " + query);
cs.executeQuery();
//logger.warning("cs.getObject(9) " + cs.getObject(9));
//cast to a short and check if ResultSet has been returned ok.
short ok = (Short) cs.getObject(9);
if (ok == 0) {
ResultSet rs = (ResultSet) cs.getObject(11);
//iterate through the ResultSet
while (rs.next()) {
//create a new bean
ListingManagerBean lmb = new ListingManagerBean();
lmb.setPropId(rs.getInt("Propid"));
lmb.setListId(rs.getInt("Listid"));
lmb.setImageUrl(rs.getString("ImageURL"));
lmb.setAddress(rs.getString("Address"));
lmb.setCity(rs.getString("City"));
lmb.setState(rs.getString("State"));
lmb.setZip(rs.getString("Zip"));
lmb.setPrice(rs.getInt("Price"));
lmb.setMls(rs.getString("MLS"));
lmb.setExpires(rs.getString("Expires"));
lmb.setSold(rs.getString("Sold"));
//get source, "HE" or "MLS" or "SEC"
lmb.setSource(rs.getString("Source"));
//lmb.setImpressions(rs.getInt("Impressions"));
//lmb.setFeaturedImpressions(rs.getInt("FeaturedImpressions"));
//lmb.setViews(rs.getInt("Views"));
//lmb.setFeaturedViews(rs.getInt("FeaturedViews"));
//sum the portal impressions data
// this.totalImps += rs.getInt("Impressions");
//this.totalFeaturedImps += rs.getInt("FeaturedImpressions");
//this.totalViews += rs.getInt("Views");
//this.totalFeaturedViews += rs.getInt("FeaturedViews");
//add the bean to the list
managerList.add(lmb);
} //end loop
//this.setList(managerList);
rs.close();
cs.close();
} else {
logger.warning("Error message = " + cs.getObject(10));
}
} finally {
close();
Code:
<fmt:message key='lm.perpage' />
<select onchange="resetPagination(this.value)" name="pagSelect" id="pagSelect">
<option value="10">10</option>
<option value="25" selected="selected">25</option>
<option value="50">50</option>
<option value="100">100</option>
<option value="${listSize}">All</option>
</select>
<span id="totallistings"></span>[B]I need the value from the database call to go here[/B]