Android打开已有数据库查询

时间:2015-04-17 20:15:58   收藏:0   阅读:248
private SQLiteDatabase stuDb;
        /**
         * 查询数据库
         * openOrCreateDatabase(数据库路径,数据库名)
         * rawQuery(Sql语句,参数)
         */
        private void queryDatabase() {
                stuDb = SQLiteDatabase.openOrCreateDatabase(absolutePath + "/" + dbname, null);
                String trim = et_input.getText().toString().trim();
                System.out.println(trim);
                Cursor rawQuery = stuDb.rawQuery("select * from article where id=?", new String[] { trim });
                System.out.println(rawQuery.moveToFirst());
                if (rawQuery.moveToFirst())
                        et_show.setText(rawQuery.getString(1));
        }

 

原文:http://www.cnblogs.com/spadd/p/4435675.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!