为什么我在mysql命令控制台能执行的Insert语句放到java代码里只能insert数字了?
代码如下:
...
String name = "abc";//这里改为数字可以通过,如"123"
...
String sql = "Insert into sms(TaskID,Discribe,Code,Number,Type,State1,State2,Pname,Usertype) values("+name+","+discribe+","+code+","+number+","+type+','+state1+','+state2+','+pname+','+user+");";
statement.executeUpdate(sql);
...
报错
java.sql.SQLException: Column not found: Unknown column 'abc' in 'field list'这里的TaskID,Discribe等是char型求教
代码如下:
...
String name = "abc";//这里改为数字可以通过,如"123"
...
String sql = "Insert into sms(TaskID,Discribe,Code,Number,Type,State1,State2,Pname,Usertype) values("+name+","+discribe+","+code+","+number+","+type+','+state1+','+state2+','+pname+','+user+");";
statement.executeUpdate(sql);
...
报错
java.sql.SQLException: Column not found: Unknown column 'abc' in 'field list'这里的TaskID,Discribe等是char型求教
String类型要用"包起来
//---------------送个笑话----------------------
煤矿发生事故,一无名男尸,只幸存下半身,叫来村里村妇前来辨认。
妇人甲看了看:不是我男人,不是村长,也不是村支书;
妇人乙:不是我姐夫,不是村会计;
一个寡妇过来,摸了摸:哎,都回去吧,不是咱村的! www.xiaohua007.com