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 );
}
数据库用的是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 );
}
解决方案 »
- mysql在cmd中可以显示中文了,但在vc里查询数据中文还是乱码
- 有关表的字符编码问题,字段与表定义的编码格式不一致
- MySQL 5.0 实现同步复制后, 当主服务器 crash 后, 如何切换到从服务器上工作呢?
- pgsql中,如何将查询的结果导出成excel文件
- 如果有一个excel这样的数据导入成text文档 里面很多字段都是乱七八糟的 将其导入到mysql中需要进行哪些处理 希望各位能给个详细的步骤 谢谢了
- MYSQL里数据表类型怎么转换?
- 求助: 创建数据库报表出错!
- NT 上已安装好mysql服务器,WIN98 client连接不上,求救
- mysql 排序加索引的问题(where+order+limit)
- 数据库如何查询三个表,将三个表的数据全部查出,这三个表字段不同
- 实现数据库连接池
- linux mysql 权限设置 引出问题 急!!!
stmt.execute( SQL );
stmt.execute( SQL );