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

Java开发网

您没有登录

» Java开发网 » Java SE 综合讨论区 » 实战错误讨论

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

作者

大家帮我看看插入错误: 列名或所提供值的数目与表定义不匹配。

miranda

发贴: 2
积分: 0

于 2008-12-23 15:07

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:12

话题树型展开

人气	标题	作者	字数	发贴时间
11161	大家帮我看看插入错误: 列名或所提供值的数目与表定义不匹配。	miranda	6065	2008-12-23 15:07
9283	Re:大家帮我看看插入错误: 列名或所提供值的数目与表定义不匹配。	JiafanZhou	163	2008-12-26 23:45

已读帖子

新的帖子

被删除的帖子