Statement statementFields=connection.createStatement();
	String sqlFields ="SELECT categories.name, products.name, products.price, products.img_path FROM products INNER JOIN categories ON products.category_id = categories.id";
	ResultSet resultSet = statementFields.executeQuery(sqlFields);

	String _category = "";
	String _name = "";
	int _price = 0;
	String _imgpath = "";

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

<%
	    while(resultSet.next()){

	      _category =  resultSet.getString(1);
	      _name =  resultSet.getString(2);
	      _price = resultSet.getInt(3);
	      _imgpath = resultSet.getString(4);

	  %>