数据插入语句,出现语法错误

[lishnqing]

创建表:
create table dev(
devno varchar(20) primary key,
devclass varchar(20) not null,
devfactory varchar(20) not null,
devprice int(20) not null,
devstate char(5) not null,
labno varchar(20) not null
);
接收的语句是:
String devno=new String (request.getParameter("devno").getBytes("ISO8859-1"));
String devclass=new String (request.getParameter("devclass").getBytes("ISO8859-1"));
String devfactory=new String (request.getParameter("devfactory").getBytes("ISO8859-1"));
String devprice=new String (request.getParameter("devprice").getBytes("ISO8859-1"));
String devstate=new String (request.getParameter("devstate").getBytes("ISO8859-1"));
String labno=new String (request.getParameter("labno").getBytes("ISO8859-1"));
int price=Integer.parseInt("devprice")
插入语句:
sql="insert into dev (devno,devclass,devfactory,devprice,devstate,labno) values=('"+devno+"','"+devclass"','"+devfactory+"','"+price+"','"+devstate+"','"+labno+"')";
为什么说这句语法错误?

[jastby]

sql="insert into dev (devno,devclass,devfactory,devprice,devstate,labno) values=('"+devno+"','"+devclass"','"+devfactory+"',"+price+",'"+devstate+"','"+labno+"')";

[jastby]

int 类型 不用单引号

[6216]

[Quote=引用 1 楼 jastby 的回复:]
sql="insert into dev (devno,devclass,devfactory,devprice,devstate,labno) values=('"+devno+"','"+devclass"','"+devfactory+"',"+price+",'"+devstate+"','"+labno+"')";
[/Quote]
支持一下

[lishnqing]

哦,谢谢

[HelloWorld_001]

对头
2楼的

[lishnqing]

还是不得行啊,一样出错,5555

[jastby]

sql="insert into dev (devno,devclass,devfactory,devprice,devstate,labno) values=('"+devno+"','"+devclass"','"+devfactory+"',"+price+",'"+devstate+"','"+labno+"')";

= 号 多余的

[lishnqing]

这个我开先看到了,后来我去掉"="一样不行