Hi!
MySQLSyntaxError means *exactly* what it sounds like: you're attempting to send an invalid SQL statement to MySQL.
Your problem appears to be here, where I've highlighted the problem point in boldface:
private static final String SQL_INSERT_PROJECT =
"INSERT INTO projects (projectnumber, project, activity, per_number, date, time "
+ "VALUES (?, ?, ?, ?, ?, ?)";
You're missing a closing parenthesis (that is, a ')' character) following "time".
If you look at the error message carefully, it even tells you where to start looking for the error:
Quote
check the manual that corresponds to your MySQL server version for the right syntax to use near
'VALUES ('p10001', 'TimeKeeper', 'DAOTest', '100101', '2015-08-05', '05:30:00')'
In such cases, "near" usually means "immediately before".
TIP: A good way to find such errors is to print the querystrings out to the screen, so you can see what you're actually trying to send to the MySQL server.
HTH!
cheers,
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle