求助，貌似是很简单的问题，大家帮帮啊。

Question

NetBeans IDE编译提示，SQL语句有误，到底哪错了，求高人指点。
数据库用的是MYSQL
        String SQL = "select EmployeeID from WorkTime where EmployeeID  = '" +
            item.GetEmployeeID() + "'";
        rs = stmt.executeQuery( SQL ); //查找是否存在该员工的记录        //如果已经存在该员工的记录则更新，如果不存在则插入新的记录
        if ( rs.next() ) {
            SQL = "update WorkTime set EmployeeName='" + item.GetEmployeeName() +
                "',"
                + " EmployeeSex='" + item.GetEmployeeSex() + "',"
                + " EmployeeNum='" + item.GetEmployeeNum() + "',"
                + " WorkAge='" + item.WorkAge() + "',"
                + " Department='" + item.GetDepartment() + "',"
                + " OnworkTime='" + item.GetOnWorkTime() + "',"
                + " OffworkTime='" + item.GetOffWorkTime() + "',"
                + " LeaveworkTime='" + item.GetLeaveWorkTime() + "',"
                + " Describe='" + item.GetDescribe() + "'"
                + " where EmployeeID = '" + item.GetEmployeeID() + "'";
            stmt.execute( SQL );
        }
        else {
            SQL =
                "insert into WorkTime(EmployeeID,EmployeeName, EmployeeSex, EmployeeNum, WorkAge, Department, OnworkTime, OffworkTime, LeaveworkTime, Describe) "
                + " values('" + item.GetEmployeeID() + "', '"
                + item.GetEmployeeName() + "','"
                + item.GETEmployeeSex() + "','"
                + item.GetEmployeeNum() + "','"
                + item.GetWorkAge() + "','"
                + item.GetDepartment() + "','"
                + item.GetOnWorkTime() + "','"
                + item.GetOffWorkTime() + "','"
                + item.GetLeaveWorkTime() + "','"
                + item.GetDescribe() + "')";
            stmt.execute( SQL );
        }

Answer 1

将你的SQL语句显示出来，看看内容是什么，检查变量类型与字段类型是否一致

Answer 2

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '='123'WHERE EmployeeID = '10002'' at line 1出错提示说语法问题。

Answer 3

JAVA调试中看一下你的SQL的实际内容是什么？ 估计有值 没有取到。比如这个 item.GetWorkAge()

Answer 4

System.out.println(SQL); // 添加这行看看SQL语句到底是什么
stmt.execute( SQL ); 

Answer 5

System.out.println(SQL); // 添加这行看看SQL语句到底是什么
stmt.execute( SQL );