SQL problems with I/0 (updating)

I'm having troubles with after I input my data. When I hit the Return key after the last entry

I get this error which is pointer...

Error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'name= 'lkasdj', Street= '3437', City 'Fullerton', State'CA', Zip = '3', Home Pho' at line 1.

I looked at theString updatestring =

where I think the problem is at which of theHome Pho

here is my code for the update section.

publicclass DBAssign{

/**

* @param args

*/

static Scanner kbd;

static Connection conn =null;

// searches for a emp id.

publicstaticboolean findRecord(String empid){

{

}// close finally

return retval;

}// close find

// updates the a record

publicstaticvoid updateRecord(){

// get record to update

String empid =null;

boolean findemp =false;

while (!findemp){

System.out.println("Enter Employee ID to update");

empid = kbd.next();

kbd.nextLine();

findemp = findRecord(empid);

if (!findemp){

System.out.println("This Employee id record " + empid

+" does not exist - try again");

}

}// close while

// display data and request update

Statement stmt =null;

ResultSet rs =null;

String firstname;

String lastname;

String street;

String city;

String state;

String zip;

String homephone;

String officephone;

String department;

String yearsemploy;

String monthpay;

try{

stmt = conn.createStatement();

rs = stmt.executeQuery("Select * from emptable where empid = '"

+ empid +"'");

rs.next();

System.out.println("Item First Name is "

+ rs.getString("firstname"));

System.out.print("Enter new item name: ");

firstname = kbd.next();

kbd.nextLine();

System.out.println("Item Last name is " + rs.getString("lastname"));

System.out.print("Enter new item name: ");

lastname = kbd.next();

kbd.nextLine();

System.out.println("Item Street is " + rs.getString("street"));

System.out.print("Enter new item name: ");

street = kbd.next();

kbd.nextLine();

System.out.println("Item City name is " + rs.getString("city"));

System.out.print("Enter new item name: ");

city = kbd.next();

kbd.nextLine();

System.out.println("Item State name is " + rs.getString("state"));

System.out.print("Enter new item name: ");

state = kbd.next();

kbd.nextLine();

System.out.println("Item Zip Code is " + rs.getString("zip"));

System.out.print("Enter new item name: ");

zip = kbd.next();

kbd.nextLine();

System.out.println("Item Home Phone is "

+ rs.getString("homephone"));

System.out.print("Enter new item name: ");

homephone = kbd.next();

kbd.nextLine();

System.out.println("Item Office Phone is "

+ rs.getString("officephone"));

System.out.print("Enter new item name: ");

officephone = kbd.next();

kbd.nextLine();

System.out.println("Item Department is "

+ rs.getString("department"));

System.out.print("Enter new item name: ");

department = kbd.next();

kbd.nextLine();

System.out.println("Item Years Employed is "

+ rs.getString("yearsemploy"));

System.out.print("Enter new item name: ");

yearsemploy = kbd.next();

kbd.nextLine();

System.out.println("Item Monthly pay is "

+ rs.getString("monthpay"));

System.out.print("Enter new item name: ");

monthpay = kbd.next();

kbd.nextLine();

String updatestring ="Update emptable set FirstName = '"

+ firstname +"', Last name= '" + lastname +"', Street= '"

+ street +"', City '" + city +"', State'" + state

+"', Zip = '" + zip +"', Home Phone='" + homephone

+"', Office Phone '" + officephone +"', Department '"

+ department +"', Years Employed'" + yearsemploy

+"', Month Pay '" + monthpay +"' where empid = '" + empid

+"'";

stmt.execute(updatestring);

int updatenum = stmt.getUpdateCount();

if (updatenum < 1){

System.out.println("Error on update");

}else{

System.out.println("Updated " + updatenum +" records");

}

}catch (SQLException e){

System.out.println("Error - " + e.getMessage());

}finally{

try{

if (stmt !=null){

stmt.close();

}

if (rs !=null){

rs.close();

}

}catch (SQLException e2){

System.out.println("Error " + e2.getMessage());

}

}// close finally

}// close updates

publicstaticvoid showMenu(){

System.out.println("");

System.out.println("1. List employees records");

System.out.println("2. Add employees record");

System.out.println("3. Update employees record");

System.out.println("4. Delete employees record");

System.out.println("5. Exit");

}

publicstaticint getOption(){

int optn = 99;

while (optn > 5 || optn < 1){

System.out.println("");

System.out.println("Enter option");

System.out.print("===>");

optn = kbd.nextInt();

}// close while

return optn;

}

publicstaticvoid main(String[] args){

int optn = 99;

String host ="localhost";

String database ="empdata";

String user ="root";

String pass ="";

// make keyboard object

kbd =new Scanner(System.in);

String connstring ="jdbc:mysql://" + host +"/" + database +"?user="

+ user +"&password=" + pass;

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

conn = DriverManager.getConnection(connstring);

while (optn != 5){

showMenu();

optn = getOption();

switch (optn){

case 1:

listRecords();

break;

case 2:

addToTable();

break;

case 3:

updateRecord();

break;

case 4:

deleteRecord();

System.out.println("That Employee is deleted");

break;

case 5:

System.out.println("OK - later Come back soon");

default:

break;

}// close switch

}// close while

}catch (ClassNotFoundException e1){

System.out.println("ERROR - Class not found " + e1.getMessage());

}catch (SQLException e2){

System.out.println("ERROR - " + e2.getMessage());

System.out.println("ERROR - " + e2.getSQLState());

}catch (Exception e3){

System.out.println("Error - " + e3.getMessage());

}

}// close main

}// close class

Any help would be great.

Thanks

Red

[12790 byte] By [Redheadashleya] at [2007-11-27 4:20:24]