java连接数据库修改数据失败

if (e.getSource() == subMenu2[4] || e.getSource() == toolBarButton[4]) {
if ((idT.getText().trim()).equals("")
|| (nameT.getText().trim()).equals("")
|| (sexT.getText().trim()).equals("")
|| (jtaddr.getText().trim()).equals("")
|| (jtbirth.getText().trim()).equals("")) {
JOptionPane.showMessageDialog(null, "请输入信息再点击修改！");
return;
} else {
id = idT.getText();
name = nameT.getText();
sex = sexT.getText();
birthday = jtaddr.getText();
address = jtbirth.getText();
String strSQL = "update zhigong1 set 姓名=?,性别=?,生日=? ,籍贯=?, where 工号=?";
try {
pst = conn.prepareStatement(strSQL);
pst.setString(1, name);
pst.setString(2, sex);
pst.setString(3, birthday);
pst.setString(4, address);
pst.setString(5, id);
pst.executeUpdate();
} catch (SQLException e1) {
JOptionPane.showMessageDialog(null, "修改失败！");
return;
}
JOptionPane.showMessageDialog(null, "修改成功！");
}
}
if (e.getSource() == subMenu2[3] || e.getSource() == toolBarButton[3]) {
String idid = JOptionPane.showInputDialog("请输入要修改的职工工号");
if (idid.trim()!= "") {
String strSQL = "select * from zhigong1 where 工号=?";
try {
pst = conn.prepareStatement(strSQL);
pst.setString(1, idid);
rs = pst.executeQuery();
int count = 0;
while (rs.next()) {
id = rs.getString("工号");
name = rs.getString("姓名");
sex = rs.getString("性别");
birthday = rs.getString("生日");
address = rs.getString("籍贯");
count++;
}
if (count == 0)
JOptionPane.showMessageDialog(null, "对不起，没有您要修改的职工信息！");
else {
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
jtaddr.setText(address);
jtbirth.setText(birthday);
idT.setEnabled(false);
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, "抱歉，程序出现异常！");
}
}
}

为什么一直是修改失败啊，求路人大大看看。。

where 前面一个 就不要逗号了

报错呢

你把这个异常先打印下 看看哪里错了