public static int tripListCnt() throws NamingException
	{
		int cnt=0;
		
		PreparedStatement stmt = null;
		ResultSet rs = null;
		DataSource ds = getDataSource();
		
		try 
		{
			conn =  ds.getConnection();
			stmt = conn.prepareStatement(
					"SELECT count(*) AS total FROM trip "
					);
			rs = stmt.executeQuery();
			
		    while(rs.next())
		    {                
		    	cnt = rs.getInt("total");
		    }
		}
		catch (SQLException e)
		{					
		} 
		finally
		{
			if (rs != null) try{rs.close();} catch(SQLException e) {}
			if (stmt != null) try{stmt.close();} catch(SQLException e) {}
			if (conn != null) try{conn.close();} catch(SQLException e) {}
		}
		return cnt;
	}