Java开发网 - 大家帮忙看一下：谢谢！插入错误: 列名或所提供值的数目与表定义不匹配。

Java开发网

您没有登录

» Java开发网 » Java EE 综合讨论区 » J2EE SDK

打印话题 寄给朋友 订阅主题

作者

大家帮忙看一下：谢谢！插入错误: 列名或所提供值的数目与表定义不匹配。

miranda

发贴: 2
积分: 0

于 2008-12-23 15:14

The SQL Is:insert addressList values(?,?,?)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]插入错误: 列名或所提供值的数目与表定义不匹配。

怎么解决啊？代码在下面
create table addressList
(userId int IDENTITY (1, 1) not null,
userName varchar(20) NOT NULL,
sex bit not null,
phone varchar(20) not null,
address varchar(50),
mobphone varchar(20),
company varchar(50),
comphone varchar(20),
comAddress varchar(50),
relation int)

package com.miranda.myHome.po;

public class AddressList {
private Integer userId;
private String userName;
private Byte sex;
private String phone;
private String address;
private String mobphone;
private String company;
private String comphone;
private String comAddress;
private Integer relation;

public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public Byte getSex() {
return sex;
}
public void setSex(Byte sex) {
this.sex = sex;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getMobphone() {
return mobphone;
}
public void setMobphone(String mobphone) {
this.mobphone = mobphone;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public String getComphone() {
return comphone;
}
public void setComphone(String comphone) {
this.comphone = comphone;
}
public String getComAddress() {
return comAddress;
}
public void setComAddress(String comAddress) {
this.comAddress = comAddress;
}
public Integer getRelation() {
return relation;
}
public void setRelation(Integer relation) {
this.relation = relation;
}

}

public void insertAddress(AddressListActionForm vo) throws SQLException {
DBHelper.createConnection(DBHelper.SQL_CNN);
String sql = "insert addressList values(";
List<Object> params = new ArrayList<Object>();
if(vo.getUserName()!=null&&!"".equals(vo.getUserName())){
sql+="?,";
params.add(vo.getUserName());
}

if(vo.getSex()!=null&&!"".equals(vo.getSex())){
sql+="?,";
params.add(String.valueOf(vo.getSex()));
}

if(vo.getPhone()!=null&&!"".equals(vo.getPhone())){
sql+="?,";
params.add(vo.getPhone());
}

if(vo.getAddress()!=null&&!"".equals(vo.getAddress())){
sql+="?,";
params.add(vo.getAddress());
}

if(vo.getMobphone()!=null&&!"".equals(vo.getMobphone())){
sql+="?,";
params.add(vo.getMobphone());
}

if(vo.getCompany()!=null&&!"".equals(vo.getCompany())){
sql+="?,";
params.add(vo.getCompany());
}

if(vo.getComphone()!=null&&!"".equals(vo.getComphone())){
sql+="?,";
params.add(vo.getComphone());
}

if(vo.getComAddress()!=null&&!"".equals(vo.getComAddress())){
sql+="?,";
params.add(vo.getComAddress());
}
if(vo.getRelation()!=null&&!"".equals(vo.getRelation())){
sql+="?)";
params.add(String.valueOf(vo.getRelation()));
}

try {
DBHelper.executeSQL(sql, params);
}catch (SQLException e) {
e.printStackTrace();
}finally {
DBHelper.close();
}

}
}

miranda edited on 2008-12-23 15:18

作者	Re:大家帮忙看一下：谢谢！插入错误: 列名或所提供值的数目与表定义不匹配。 [Re:miranda]
JiafanZhou 版主发贴: 736 积分: 61	于 2008-12-26 23:49 Check the link below for more information: http://www.cjsdn.net/post/view?bid=1&id=196914&tpg=1&ppg=1&sty=1#196947 When I was a kid I used to pray every night for a new bike. Then I realized that The Lord doesn't work that way, so I stole one and asked him to forgive me.

作者	Re:大家帮忙看一下：谢谢！插入错误: 列名或所提供值的数目与表定义不匹配。 [Re:miranda]
zxj7957 发贴: 1 积分: 0	于 2009-01-07 13:22 如果有值是NULL,当然就不匹配了

已读帖子

新的帖子

被删除的帖子