悄悄问一下

Question

String wuliao1=getStr(request.getParameter("textfield"));
String xiadanshulian=getStr(request.getParameter("textfield2"));
 String sql="Insert into xiadanbiao(xiadanbianma,xiadanpinming,kucunshulian,xiadanshulian,xiadanhoukucun)
     selcet wuliaobianma,pinming,shulian,'"+xiadanshulian+"',shulian-"+xiadanshulian+" from grubby
  where wuliaobianma='"+wuliao1+"'";
我想把grubby 表的某些字段值的记录根据用户输入的条件插入表xiadanbiao,其他字段值比如xiandanhoukucun是grubby表shulian字段的值减去用户输入的值 xiadanshulian  我编译时报错
String literal is not properly closed by a double-quote37:    String sql="Insert into xiadanbiao(xiadanbianma,xiadanpinming,kucunshulian,xiadanshulian,xiadanhoukucun)
38:      selcet wuliaobianma,pinming,shulian,'"+xiadanshulian+"',shulian-"+xiadanshulian+" from grubby
39:    where wuliaobianma='"+wuliao1+"'";
要用存储过程吗

Answer 1

insert into tablename1 select ****** from tablename2
没有你的那种写法。

Answer 2

inser into 是插入语句,怎么还带 select查询语句啊