使用FinalDb操作数据库出现SqliteConstraintException异常

package com.aaagamewater;


public class UserData {

    public UserData() {

    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }


    @Override
    public String toString() {
        StringBuilder sb=new StringBuilder();
        sb.append("您好,你的手机信息如下:\n");
        sb.append("PhoneNumber:"+getPhoneNumber()+"\n");
        sb.append("Ip:"+getIp()+"\n");
        sb.append("Os:"+getOs()+"\n");
        sb.append("Cpu:"+getCpu()+"\n");
        sb.append("ProcessorSum:"+getProcessorSum()+"\n");
        sb.append("RawMemory:"+getRawMemory()+"\n");
        return sb.toString();
    }


    public String getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(String phoneNumber) {
        this.phoneNumber = phoneNumber;
    }
    public String getIp() {
        return ip;
    }
    public void setIp(String ip) {
        this.ip = ip;
    }
    public String getOs() {
        return os;
    }
    public void setOs(String os) {
        this.os = os;
    }
    public String getCpu() {
        return cpu;
    }
    public void setCpu(String cpu) {
        this.cpu = cpu;
    }
    public String getProcessorSum() {
        return processorSum;
    }
    public void setProcessorSum(String processorSum) {
        this.processorSum = processorSum;
    }
    public String getRawMemory() {
        return rawMemory;
    }
    public void setRawMemory(String rawMemory) {
        this.rawMemory = rawMemory;
    }

    private int id;//不需要无码给他设定值,框架会自动设定值
//  @Id(column="phoneNumber")//当bean里面没有id字段,就需要使用这个注解映射其他的字段作为主键
    private String phoneNumber;
    private String ip;
    private String os;
    private String cpu;
    private String processorSum;
    private String rawMemory;
}

        FinalDb finalDb=FinalDb.create(this);
        UserData u1=new UserData();
        u1.setCpu("545");
        u1.setIp("552");
        u1.setOs("2250");
        u1.setPhoneNumber("22551");
        u1.setProcessorSum("2252");
        u1.setRawMemory("552236");
        finalDb.save(u1);
        finalDb.save(u1);

03-15 13:17:13.402: E/SQLiteLog(1097): (1555) abort at 15 in [INSERT INTO com_aaagamewater_UserData (processorSum,ip,rawMemory,phoneNumber,os,cpu) VALUES ( ?,?,?,?,?,?)]: UNIQUE constraint failed: com_aaagamewater_UserData.phoneNumber

终于找到原因了,是因为之前使用的这个类是这样的

package com.aaagamewater;


public class UserData {

    public UserData() {

    }

    @Override
    public String toString() {
        StringBuilder sb=new StringBuilder();
        sb.append("您好,你的手机信息如下:\n");
        sb.append("PhoneNumber:"+getPhoneNumber()+"\n");
        sb.append("Ip:"+getIp()+"\n");
        sb.append("Os:"+getOs()+"\n");
        sb.append("Cpu:"+getCpu()+"\n");
        sb.append("ProcessorSum:"+getProcessorSum()+"\n");
        sb.append("RawMemory:"+getRawMemory()+"\n");
        return sb.toString();
    }


    public String getPhoneNumber() {
        return phoneNumber;
    }

    public void setPhoneNumber(String phoneNumber) {
        this.phoneNumber = phoneNumber;
    }
    public String getIp() {
        return ip;
    }
    public void setIp(String ip) {
        this.ip = ip;
    }
    public String getOs() {
        return os;
    }
    public void setOs(String os) {
        this.os = os;
    }
    public String getCpu() {
        return cpu;
    }
    public void setCpu(String cpu) {
        this.cpu = cpu;
    }
    public String getProcessorSum() {
        return processorSum;
    }
    public void setProcessorSum(String processorSum) {
        this.processorSum = processorSum;
    }
    public String getRawMemory() {
        return rawMemory;
    }
    public void setRawMemory(String rawMemory) {
        this.rawMemory = rawMemory;
    }


    @Id(column="phoneNumber")//当bean里面没有id字段,就需要使用这个注解映射其他的字段作为主键
    private String phoneNumber;
    private String ip;
    private String os;
    private String cpu;
    private String processorSum;
    private String rawMemory;
}

手机号做的主键,由于更改为id作为主键,但是之前的那张表已经建立了,表的结构不会变化,现在把类的结构更改了,id为主键,插入的手机相同就会出现SqliteConstraintException异常,解决办法就是把之前的表结构删除掉(drop而不是delete),再使用的时候会重新再新建这张表(名字一样),但是结构不一样

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值