Newbie:how to create a page with 4 textfields and send data to MySql DB

Dear all,

i have created a page called page1 with 1 submit button named 'submitButton' and 4 textfields named:

'date'

'item'

'contact'

'phone'

I have created a MySql DB table with the schema named 'association' and table named todolist3. Fields created in the table are :

'Date' - >INTEGER->Primary

'Item' ->VARCHAR(100)

'Contact'->VARCHAR(45)

'Phone_contact'->INTEGER

what i want to do is to send the data from the 4 textfields to the database when i click the submit button. Below is the code i out in submit button. please kindly help as i have tested different ways but none of them works. thank you!!!

public String submitButton_action() {

try {

if ( todolist3DataProvider.canAppendRow() )

{

String item1=(String)item.getText();

String contact1=(String)contact.getText();

Integer phone1=(Integer)phone.getText();

Integer date1=(Integer)date.getText();

RowKey rowKey = todolist3DataProvider.appendRow();

todolist3DataProvider.setCursorRow(rowKey);

todolist3DataProvider.setValue("todolist3.Date", date1);

todolist3DataProvider.setValue("todolist3.Item",item1);

todolist3DataProvider.setValue("todolist3.Contact",contact1);

todolist3DataProvider.setValue("todolist3.Phone_contact",phone1);

} else {

error("submitButton_action() -- cannot append todolist3 record");

}

} catch (Exception e) {

error("Page1::submitButton_action-- something's wrong trying to append todolist3 record");

}

return null;

}

}

[1664 byte] By [jaybuffer88a] at [2007-11-27 6:24:29]