Tuesday, 13 August 2013

Trying to use Button to insert TextField into database

Trying to use Button to insert TextField into database

I am trying to use a button to insert multiple TextField's into my
database. I am able to insert raw strings into the database via:
preparedStatement.setString(1, "Sjaakie Sjaakssen");
preparedStatement.setString(2, "Sjaakssen@yahoo.nl");
preparedStatement.setString(3, "pannekoekenstraat 2");
preparedStatement.setString(4, "Rotterdam");
preparedStatement.setString(5, "3022PK");
preparedStatement.setString(6, "0101235489");
preparedStatement.setString(7, "Yahoo");
preparedStatement.executeUpdate();
I have linked the individual columns to their respective TextFields using
this method:
Label jNaam = new Label("Naam"); TextField lNaam = new TextField(30);
Label jEmail =new Label("E-Mail"); TextField lEmail=new TextField(30);
Label jAdres =new Label("Adres"); TextField lAdres =new TextField(30);
Label jPlaats =new Label("Plaats"); TextField lPlaats =new TextField(100);
Label jPostcode =new Label("Postcode"); TextField lPostcode =new
TextField(6);
Label jTelefoon =new Label("Telefoon"); TextField lTelefoon =new
TextField(13);
Label jBedrijfsNaam =new Label("Bedrijfsnaam"); TextField lBedrijfsNaam
=new TextField(30);
Then this:
preparedStatement.setString(1, lNaam.getText());
preparedStatement.setString(2, lEmail.getText());
preparedStatement.setString(3, lAdres.getText());
preparedStatement.setString(4, lPlaats.getText());
preparedStatement.setString(5, lPostcode.getText());
preparedStatement.setString(6, lTelefoon.getText());
preparedStatement.setString(7, lBedrijfsNaam.getText());
preparedStatement.executeUpdate();
The Button is in the same Frame and it all looks like this:
http://i.imgur.com/U380tP3.jpg

No comments:

Post a Comment