Raible's Wiki: HibernateRelationshipsUI

At line 18 added 2 lines.

* [7] Show an Entry's Category, and allow modification of it

* [8] Add the ability to add and delete entries

At line 287 added 1 line.

<nested:hidden property="categoryId"/>

At line 306 added 1 line.

At line 331 changed 1 line.

]}

}]

At line 333 changed 1 line.

For the purpose of this tutorial, you'll need to replace your ''src/service/org/appfuse/util/__DateConverter.java__'' with the [latest one from CVS|https://appfuse.dev.java.net/source/browse/*checkout*/appfuse/src/service/org/appfuse/util/DateConverter.java].

For the purpose of this tutorial, you'll need to replace your ''src/service/org/appfuse/util/__DateConverter.java__'' with the [latest one from CVS|https://appfuse.dev.java.net/source/browse/*checkout*/appfuse/src/service/org/appfuse/util/DateConverter.java]. After replacing this file and running __ant deploy__, you should be able to save the form successfully.

At line 339 added 1 line.

!!Show an Entry's Category, and allow modification of it [#7]

At line 336 changed 3 lines.

# Modify struts_form.xdt so collections ending with "ies" will get their POJO's names ending with "y" (i.e. entries -> Entry).

# TODO: Figure out how to get DateConverter and TimestampConverter to play nicely with each other (maybe combine them)

# Style up the "posted at" text

The last piece of the relationships puzzle is to show an entry's category, as well as allow it to be changed. To show the category of an entry, change:

At line 340 changed 4 lines.

# Add AVAILABLE_CATEGORIES to Constants.java

# Grab Categories in StartupListener and expose them, discuss why not do it in edit() method

# Add "extends Manager" to LookupManager interface so getObjects() can be used in StartupListener

# LookupManager.getObjects results in NPE, change signature of setLookupDAO() method to call super.dao = dao:

[{Java2HtmlPlugin

At line 345 added 5 lines.

Posted at: <nested:write property="timeCreated"/>

}]

To:

At line 347 changed 4 lines.

public void setLookupDAO(LookupDAO dao) {

super.dao = dao;

this.dao = dao;

}

<strong>Category:</strong> <nested:write property="category.name"/>,

<strong>Posted at:</strong> <nested:write property="timeCreated"/></span>

At line 353 changed 2 lines.

# Add html:select tag to weblogForm.jsp, include prettying up - show screenshot

# POSSIBLITY: Add "title" to Entry.java

Run __ant deploy-web__ and refresh the weblog form. Your screen should resemble the screenshot below:

At line 359 added 3 lines.

%%(width: 700px; height: 316px; border: 1px solid black; margin: 10px auto 0 auto)

[WeblogWithCategory.png]

%%

At line 357 changed 1 line.

!!Add the ability to delete an entry

In order to allow modification of the Category, you'll need to change the ''categoryId'' from being a hidden field to being a drop-down. With Struts, the easiest way to populate a drop-down is when the application starts up. You ''could'' populate it in the Action's ''edit()'' method, but if any validation errors occur, the variable would not be re-added to the request.

At line 359 changed 1 line.

# Wrap nested:iterate with div id

Add an AVAILABLE_CATEGORIES field to ''src/dao/**/__Constants.java__'':

At line 361 changed 21 lines.

<nested:iterate property="entries" id="entry" indexId="index">

<nested:hidden property="entryId"/>

<nested:hidden property="weblogId"/>

<nested:textarea property="text" style="width: 400px; height: 100px"/>

<br />

Category:

<nested:select property="categoryId" style="color: #333; font-size: 11px; margin: 2px 10px 0 0">

<html:options collection="availableCategories" property="categoryId" labelProperty="name"/>

</nested:select>

Posted at: <nested:write property="timeCreated"/></span>

<input type="submit" class="button" style="font-size: 11px"

onclick="parentNode.parentNode.removeChild($('entry<%=index%>'))" value="Delete"/>

</div>

</nested:iterate>

# This will delete, but only the first one - might need some more JavaScript magic to shuffle the numbers

# Delete only works if last entry is deleted

# Add only works if there's already an existing one to replicate.

[{Java2HtmlPlugin

/**

* The name of the available categories list in application scope

*/

public static final String AVAILABLE_CATEGORIES = "availableCategories";

}]

Grab the list of possible categories in ''src/web/**/listener/__StartupListener.java__'' and stuff them into the servlet context:

[{Java2HtmlPlugin

context.setAttribute(Constants.AVAILABLE_ROLES, mgr.getAllRoles());

context.setAttribute(Constants.AVAILABLE_CATEGORIES, mgr.getObjects(Category.class));

}]

If you're using < AppFuse 1.9, you'll need to fix [LookupManager.java|http://fisheye4.cenqua.com/browse/~raw,r=1453/appfuse/trunk/src/service/org/appfuse/service/LookupManager.java] and [LookupManagerImpl.java|http://fisheye4.cenqua.com/browse/~raw,r=1453/appfuse/trunk/src/service/org/appfuse/service/impl/LookupManagerImpl.java] so the above code works.

Remove the hidden ''categoryId'' field from __weblogForm.jsp__:

[{Java2HtmlPlugin

<nested:hidden property="categoryId"/>

}]

And change <nested:write property="category.name"/> to:

[{Java2HtmlPlugin

<nested:select property="categoryId" style="color: #333; font-size: 11px; margin: 2px 10px 0 0">

<html:options collection="availableCategories" property="categoryId" labelProperty="name"/>

</nested:select>

}]

Run __ant deploy__ and refresh your browser. You should now be able to modify the category for an entry.

This covers most of the things you need to know for using Hibernate's relationships and modifying child elements. However, it doesn't cover adding or deleting child elements.

!!Add the ability to add and delete entries [#8]

There are many different ways to add and delete child elements from a form. This section is a work in progress and shows a quick-n-dirty (complete with bugs!) way of doing this.

In __weblogForm.jsp__, add a "Delete" button just after the "Posted at" information:

[{Java2HtmlPlugin

Posted at: <nested:write property="timeCreated"/></span>

<input type="button" class="button" name="delete" style="font-size: 11px"

onclick="parentNode.parentNode.removeChild($('entry<%=index%>'))" value="Delete"/>

}]

Run __ant deploy-web__, refresh your browser - and you should be able to delete the entry. Click "Save" after clicking "Delete" to complete the process. While this works, it's not the ideal solution. Since it just removes the entry (and it's form elements) from the form, it doesn't re-adjust the index numbers on other entries. This means that deleting will only work for the last entry. In addition, the entry won't be deleted from the "entry" table (try ''select * from entry''). Both of these issues could likely be fixed if you linked the "Delete" button to an action (or Ajax) that deleted the entry from the database.

To add a new entry, there are also a number of things you can do. The simplest one I've found is to duplicate an existing set of entry fields, re-index the input element names and clear the values. To do this: add the following after the ending </nested:iterate> for the "entries":

[{Java2HtmlPlugin

<hr />

<input type="button" class="button" onclick="toggleDisplay('newentry');

if ($('newentry').style.display == '') {

var entries = parentNode.getElementsByTagName('div');

$('newentry').innerHTML = entries[entries.length-2].innerHTML;

// reset all fields to blank, and change their names

var inputs = $('newentry').getElementsByTagName('input');

var index = inputs[0].name.substring(inputs[0].name.indexOf('[')+1, inputs[0].name.indexOf(']'));

var next = parseInt(index) + 1;

for (i=0; i < inputs.length; i++) {

inputs[i].name = inputs[i].name.replace(index, next);

if (inputs[i].name == 'delete') {

inputs[i].onclick =

function() { $('newentry').innerHTML = ''; $('newentry').style.display='none'; };

} else if (inputs[i].name.indexOf('weblogId') == -1) {

inputs[i].value = '';

}

// reset any textareas

var boxes = $('newentry').getElementsByTagName('textarea');

for (i=0; i < boxes.length; i++) {

boxes[i].name = boxes[i].name.replace(index, next);

boxes[i].value = '';

}

// reset any selects

var dropdowns = $('newentry').getElementsByTagName('select');

for (i=0; i < dropdowns.length; i++) {

dropdowns[i].name = dropdowns[i].name.replace(index, next);

dropdowns[i].selectedIndex = 0;

}

boxes[0].focus();

this.value = this.value.replace('Add', 'Cancel');

} else {

this.value = this.value.replace('Cancel', 'Add');

}" value="Add New Entry"/>

}]

Run __ant deploy-web db-load__ and you should be able to add a new Entry by clicking on the <button>Add New Entry</button> button. There are a couple of issues with this technique:

* Adding a new entry will only work if there is (at least) one entry already in the weblog.

* The "timeCreated" field won't be set as part of the new entry.

Since this tutorial is designed to show Hibernate relationships and how to edit them (moreso than techniques for adding/deleting child records), I'll leave the issues with Delete and Add as an exercise for the reader. <img src="http://raibledesigns.com/images/smileys/wink.gif" alt="Wink" style="vertical-align: middle" /> Of course, if you do figure out a good solution - please send an e-mail to the mailing list (or enter an issue in [JIRA|http://issues.appfuse.org]) so we can enhance this tutorial.

Raible's Wiki

AppFuse

Other Applications

HibernateRelationshipsUI