scanner variables into object for insertion into database.

Hi all,

In one class im using scanner to store information, such as forename, surname.

What im trying to do is take those variables, then create a new object and pass those variables into the object, which will then store in the database.

so scanner is

the following is me creating the new object, but the content is static, where i want it to be the variables, but if i replace PAUL with forename, it passes out.

this is my constructor

hi all,

this is as far as i have got but

a) if i javac in cmd, i get 2 errors. its pointing at the N of telNumber, and the P of Personal, saying it cant find symbol.

b) i compile in netbeans, it asks for all the input, but then says "cant connect"

here is the code

//declare package
package database;

import java.sql.*;
import java.util.Scanner;

public class PersonalDriver
{
	public static void main (String []arguments)
	{

Scanner myScanner = new Scanner( System.in );
       System.out.println("Please enter first name:");
       String forename = myScanner.nextLine();

System.out.println("Please enter your surname: ");
        String surname = myScanner.nextLine();

System.out.println("Please enter your date of birth (DDMMYYYY): ");
        int dob = myScanner.nextInt();

System.out.println("Please enter the 1st line of your address: ");
        String add1 = myScanner.nextLine();

System.out.println("Please enter the 2nd line of your address: ");
        String add2 = myScanner.nextLine();

System.out.println("Please enter your county ");
        String county = myScanner.nextLine();

System.out.println("Please enter your post code: ");
        String postCode = myScanner.nextLine();

System.out.println("Please enter your telephone (+44): ");
        long telNumber = myScanner.nextLong();

Personal User = new Personal(forename,surname,dob ,add1,add2,county,postCode,telNumber);
        
Connection conn = null;

try
        {
            String userName = "pword";
            String password = "username";
            String url = "jdbc:mysql://localhost:3306/test";
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection(url, userName, password);
            System.out.println("connection established");
            Statement statement = conn.createStatement();

String createTable = "CREATE TABLE account (forename CHAR(50), surname CHAR(50), dob CHAR(8), add1 CHAR(50), add2CHAR(50), county CHAR(50), postcode CHAR (50), telnumber CHAR(50))";
               String insertRows1 = "INSERT INTO account VALUES (forename, surname, dob, add1, add2, county, postCode, telNumber)";

String select = "SELECT * FROM account";

statement.executeUpdate(createTable);
               statement.executeUpdate(insertRows1);

ResultSet rset = statement.executeQuery(select);
               while (rset.next() == true)
               {
                   System.out.print(rset.getString(1)+"\t");
                   System.out.println(rset.getString(2));
               }

System.out.println("Your record has been created");
                System.out.println("The users name is " + forename + " " + surname);
                System.out.println("Their telephone number is:" + "0" + telNumber);

rset.close();
        }
        catch (Exception e)
        {
            System.err.println("cant connect");
        }
        finally
        {
            if (conn != null)
            {
               try
               {
                   conn.close ();
                   System.out.println("Connection terminated");
               }
               catch (Exception e) { }
            }
	}
    }
}