碟碟
2016-04-02 03:55
采纳率: 50%
浏览 2.3k

Android中SQLite数据库查询不到的问题,求大神帮忙

private static String sql1="create table user(
_id integer primary key autoincrement,
name varchar(20),
pwd varchar(20))";
private static String sql2="create table account_book("+
"_id integer primary key autoincrement,"+
"name varchar(20) not null,"+
"user_id references user(_id) not null,"+
"cash double ,"+
" disposit_card double,"+
" credit_card double,"+
"alipay double )";
private static String sql3= " create table payin("+
" _id integer primary key autoincrement,"+
"account_id references account_book(_id) not null,"+
"type varchar(20),"+
"use varchar(20),"+
"date,"+
"count integer(20),"+
"qianbao varchar(20),"+
"beizhu varchar(30) )";
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(sql1);
db.execSQL(sql2);
db.execSQL(sql3);
}
以上是建表语句。
以下根据user_id 在account_book表中查询时返回的cursor中没有记录getcount=0
根据account_id在payin表中查询也是一样的情况。
下面是我的查询语句:
Cursor cursor=database.query("account_book",new String[]{"_id"},"user_id=?", new String[]{user_id+""}, null, null, null);
Cursor cursor=database.query("payin",new String[]{"_id","type","use","count","qianbao","beizhu"}, "account_id=?and type=?", new String[]{account_id.toString(),type}, null, null, "_id");
请大神解惑,拜托了

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • 碟碟 2016-04-02 09:01
    已采纳

    本人已经解决了,谢谢大家热心回答了。图片说明

    打赏 评论
  • 足球中国 2016-04-02 06:54

    用select查呢 这种查询方法没用过

    打赏 评论

相关推荐 更多相似问题