首页 / ANDROID / Android sqlite

Android sqlite

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Android sqlite，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3191字，纯文字阅读大概需要5分钟。

内容图文

            转载 http://blog.csdn.net/s874154731/article/details/7086238
import
             android.content.Context;  

            import
             android.database.sqlite.SQLiteDatabase;  

            import
             android.database.sqlite.SQLiteDatabase.CursorFactory;  

            import
             android.database.sqlite.SQLiteOpenHelper;  

            import
             android.util.Log;  

            public
            class DatabaseHelper extends SQLiteOpenHelper {  
    static String dbName= "mydb.db";  
    staticint dbVersion = 2;     
    public DatabaseHelper(Context context) {  
        super(context, dbName, null, dbVersion);  
    }  
    //只在初次使用数据库的时候会被自动调用一次  publicvoid onCreate(SQLiteDatabase db) {  
        Log.i("TAG","onCrete被调用了");  
        String sql = "create table person(personid integer primary key autoincrement," +  
                "name varchar(20), age integer)";         
        db.execSQL(sql);  
    }  
    publicvoid onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {  
        Log.i("TAG","onUpgrade被调用了");  
        String sql = "alter table person add phone char(20) null";        
        db.execSQL(sql);  
    }  
}  
            import
             java.util.ArrayList;  

            import
             java.util.List;  

            import
             android.content.Context;  

            import
             android.database.Cursor;  

            import
             android.database.sqlite.SQLiteDatabase;  

            import
             cn.class3g.domain.Person;  

            public
            class
             PersonService {  
    
            private
             DatabaseHelper dbHelper;  
    
            public
             PersonService(Context context){  
        dbHelper = new DatabaseHelper(context);   
    }     
    publicvoid add(Person person){  
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "insert into person(name, age, phone) values(?,?,?)";  
        db.execSQL(sql,new Object[]{person.getName(), person.getAge(), person.getPhone()});  
    }  
        publicvoid delete(int id){  
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "delete from person where personid=?";  
        db.execSQL(sql,new Object[]{id});  
    }     
    publicvoid update(Person person, int id){  
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "update person set name=?, age=?, phone=? where personid=?";  
        db.execSQL(sql,new Object[]{person.getName(),person.getAge(),person.getPhone(), id});  
    }     
    public Person find(int id){  
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "select * from person where personid=?";  
        Cursor cursor = db.rawQuery(sql, new String[]{String.valueOf(id) });          
        if(cursor.moveToNext()){  
            Person person = new Person();             
            person.setPersionid(cursor.getInt(0));  
            person.setName(cursor.getString(cursor.getColumnIndex("name")));  
            person.setAge(cursor.getInt(2));  
            person.setPhone(cursor.getString(3));             
            return person;  
        }         
        returnnull;  
    }     
    publicint getRecordsCount(){  
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "select count(*) from person";  
        Cursor cursor = db.rawQuery(sql, null);  
        cursor.moveToFirst();  
        int count = cursor.getInt(0);  
        cursor.close();  
        return count;  
    }     
    //跳过前面的start条记录，读取其后count记录  public List<Person> getScrollData(int start, int count){        
        SQLiteDatabase db = dbHelper.getReadableDatabase();  
        String sql = "select * from person limit ?,?";  
        Cursor cursor = db.rawQuery(sql,  
                        new String[] { String.valueOf(start),  
                                       String.valueOf(count) });  
        List<Person> list = new ArrayList<Person>();          
        while(cursor.moveToNext()){  
            Person p = new Person();  
            p.setPersionid(cursor.getInt(0));  
            p.setName(cursor.getString(1));  
            p.setAge(cursor.getInt(2));           
            list.add(p);  
        }         
        cursor.close();  
        return list;  
    }  
}

 

原文：http://www.cnblogs.com/webglcn/p/4952284.html

内容总结

以上是互联网集市为您收集整理的Android sqlite全部内容，希望文章能够帮你解决Android sqlite所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1183539.html

来源：【匿名】