Storing session variables into a Database JSP

[JSPballerzz webforumsuser@macromedia.com]

I have a form page that users fillout for a online ad
Once completed, they hit "Preview Ad" to view the information that they just entered on the next page in simple text format (no forms on this page)
Then they hit submit on the third page to insert the previewed data into a database (but that's my problem)

Here is my question, do I set session variables to store the form data form the first page so that once they view it on the second page and hit submit, I can insert all that form data from the first page into a database? And if this is how to do it, how do set the JSP code to insert a session variable into a database?

I appreciate any help on this.

[bigdog205 webforumsuser@macromedia.com]

sounds like the chapter 22 tutorial of the book "dreamweaver the missing manual" i think thats the name. it's on line. sorry i can't be more help

[dhtmlkitchen webforumsuser@macromedia.com]

Use a bean.

When the user fills out stuff on first page, put that stuff in a bean. Don't allow the second page until the user bean has the requisite data.

public class User {
private String _name;
private int _age;
private char sex;

public User(String name, int age, char sex) throws IllegalArgumentException {
_name = name;
_age = age; // check this value out
_sex = sex; // allow only 'm' , 'f', and 't'
}

public void setName(String name) {

_name = name;
}
}

Make a table in the DB. Check the bean out -- programmatically validate to make sure age is a whole number less than 110, fields aren't blank, et c.

Make a java class with a static method to connect to the DB and put each field into the DB.

DBQ.createOrModifyUser(User user);


[url]http://dhtmlkitchen.com/[/url]