创建表:
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+"')";
为什么说这句语法错误?
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+"')";
为什么说这句语法错误?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货