原代码:
public boolean OutProTable(String compName) throws SQLException {
boolean Isout = false;
long SAFETYID = 0,USERID = 0;
String PROBCONTENT ="",REMARKS = "",COMPANYNAME ="", CREATION_TIME = "",SAF_FLAG = "";
String SQL = "delete from SAFETYPROBLEM where COMPANYNAME='" + compName.trim()+
"'";
System.out.println("SQL = "+SQL);
pool.executeUpdate(SQL);
sql = "select * from SAFETYPROBLEM where COMPANYNAME='" + compName.trim() + "'";
System.out.println("sql = "+sql);
rs = db.executeQuery(sql);
while (rs.next()) {
System.out.println("111111");
SAFETYID = rs.getLong("SAFETYID");
System.out.println("SAFETYID = "+SAFETYID);
USERID = rs.getLong("USERID");
PROBCONTENT = rs.getString("PROBCONTENT").trim();
REMARKS = rs.getString("REMARKS");
COMPANYNAME = rs.getString("COMPANYNAME");
CREATION_TIME = rs.getString("CREATION_TIME");
SAF_FLAG = rs.getString("SAF_FLAG");
sql1 = "insert into SAFETYPROBLEM ("+
"SAFETYID,"+
"PROBCONTENT,"+
"REMARKS,"+
"COMPANYNAME,"+
"USERID,"+
"CREATION_TIME,"+
"SAF_FLAG"+
")values("
+SAFETYID + ",'" + PROBCONTENT + "'," +
REMARKS + "','" + COMPANYNAME+ "'," +
USERID + ",'" + CREATION_TIME + "','" +
SAF_FLAG + "')";
pool.executeUpdate(sql1);
pool.close();
Isout = true;
}
rs.close();
db.close();
return Isout;
}调用这个方法后报java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作
符丢失) 在查询表达式 '2','工区1 ',60,'2005-06-
13 04:42:52','4.10.1 ')' 中。 这个错
这是为什么呀
public boolean OutProTable(String compName) throws SQLException {
boolean Isout = false;
long SAFETYID = 0,USERID = 0;
String PROBCONTENT ="",REMARKS = "",COMPANYNAME ="", CREATION_TIME = "",SAF_FLAG = "";
String SQL = "delete from SAFETYPROBLEM where COMPANYNAME='" + compName.trim()+
"'";
System.out.println("SQL = "+SQL);
pool.executeUpdate(SQL);
sql = "select * from SAFETYPROBLEM where COMPANYNAME='" + compName.trim() + "'";
System.out.println("sql = "+sql);
rs = db.executeQuery(sql);
while (rs.next()) {
System.out.println("111111");
SAFETYID = rs.getLong("SAFETYID");
System.out.println("SAFETYID = "+SAFETYID);
USERID = rs.getLong("USERID");
PROBCONTENT = rs.getString("PROBCONTENT").trim();
REMARKS = rs.getString("REMARKS");
COMPANYNAME = rs.getString("COMPANYNAME");
CREATION_TIME = rs.getString("CREATION_TIME");
SAF_FLAG = rs.getString("SAF_FLAG");
sql1 = "insert into SAFETYPROBLEM ("+
"SAFETYID,"+
"PROBCONTENT,"+
"REMARKS,"+
"COMPANYNAME,"+
"USERID,"+
"CREATION_TIME,"+
"SAF_FLAG"+
")values("
+SAFETYID + ",'" + PROBCONTENT + "'," +
REMARKS + "','" + COMPANYNAME+ "'," +
USERID + ",'" + CREATION_TIME + "','" +
SAF_FLAG + "')";
pool.executeUpdate(sql1);
pool.close();
Isout = true;
}
rs.close();
db.close();
return Isout;
}调用这个方法后报java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作
符丢失) 在查询表达式 '2','工区1 ',60,'2005-06-
13 04:42:52','4.10.1 ')' 中。 这个错
这是为什么呀
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货