2 sinat 25127735 sinat_25127735 于 2016.04.02 11:55 提问

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个回答

sinat_25127735
sinat_25127735   2016.04.02 17:01
已采纳

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

qq_36160933
qq_36160933 求问是怎么解决的,,,无论我查询的id是几都没有对应的数据,,,
18 天之前 回复
zanfeng
zanfeng   2016.04.02 14:54

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

sinat_25127735
sinat_25127735 一样的,不是语句的问题
一年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!