Android sqliteDataBase 操作DATETIME类型

最新推荐文章于 2024-08-26 11:08:18 发布

xiaozhe_li

最新推荐文章于 2024-08-26 11:08:18 发布

阅读量948

点赞数

分类专栏：孙鑫笔记 android-widget

本文链接：https://blog.csdn.net/xiaozhe_li/article/details/46766577

版权

孙鑫笔记同时被 2 个专栏收录

4 篇文章 0 订阅

订阅专栏

android-widget

1 篇文章 0 订阅

订阅专栏

创建表：

sql = "create table member(memberNum int(64) not null primary key, memberName varchar(64) not null,memberLevel INT(5) not null, "
                + "memPhone INT(64) not null, memberSex INT(2), memberBirthday DATE,memberAddres VARCHAR(64), "
                + "memberEffectBegin DATE, memberEffectEnd DATE,bak VARCHAR(64))";

对其进行插入操作是：

@Override
    public boolean addMember(Member member) {
        SimpleDateFormat format = new SimpleDateFormat("yyyy-mm-dd");
        String str = null;
        synchronized (helper) {
            boolean flag = false;
            try {
                if (isMemberInData(member.memberNum)) {
                    flag = false;
                } else {
                    ContentValues cv = new ContentValues();
                    cv.put(tableMemberNum, member.memberNum);
                    cv.put(tableMemberName, member.memberName);
                    cv.put(tableMemberLevel, member.memberLevel);
                    cv.put(tableMemberPhone, member.memberPhone);
                    cv.put(tableMemberSex, member.memberSex);
                    str = format.format(member.memberBirthday);
                    //cv.put(tableMemberBirthday, ember.memberBirthday.toString()); 错误的方法
                    cv.put(tableMemberBirthday, str);
                    cv.put(tableMemberAddress, member.memberAddres);
                    str = format.format(member.memberEffectBegin);
                    cv.put(tableMemberEffectBegin, str);
                    str = format.format(member.memberEffectEnd);
                    cv.put(tableMemberEffectEnd, str);
                    cv.put(tableMemberBak, member.memberBak);
                    if (writeDatabase.insert(table, null, cv) == -1) {
                        flag = false;
                    } else {
                        flag = true;
                    }
                }
            } catch (Exception e) {
                e.printStackTrace();
            } finally {
            }
            return flag;
        }
    }