插入数据库的代码哪里有错？请教~~

显示全部楼层 · 2010-10-19 12:09:09

String FactorUnit1;
int FactorCode1=0,IsQualitative1=0;
String sql = "";
request.setCharacterEncoding("GBK");
FactorUnit1 = request.getParameter("textUnit");
FactorCode1 = Integer.parseInt(request.getParameter("textCode"));
IsQualitative1 = Integer.parseInt(request.getParameter("IsQualitative"));

data.connect();
sql = "insert into FactorCharacter(FactorCode,FactorUnit,IsQualitative) values (FactorCode1,"'"+FactorUnit1+"'",IsQualitative1)";
data.executeUpdate(sql);
data.close();
这是有关的代码，谢谢了~~

千问 · 2010-10-19 12:09:09

楼上的也不对 "insert into FactorCharacter(FactorCode,FactorUnit,IsQualitative) values ("+inttostr(FactorCode1)+",'"+FactorUnit1+"',"+inttostr(IsQualitative1)+")";问题出在类型不匹配，FactorCode1，IsQualitative1需要转换成字符串才能放到这个串里，另外，FactorUnit1前后需要加上“'”，注意引号的用法，不是你那样的。顺便提一下，我这个函数inttostr可能不对，你再找一下类型转换的函数吧

千问 · 2010-10-19 12:09:09

sql写错了。 googleyeyou正解！！

千问 · 2010-10-19 12:09:09

sql = "insert into FactorCharacter(FactorCode,FactorUnit,IsQualitative) values (" + FactorCode1 + ","+FactorUnit1+"," + IsQualitative1 + ")";