sqlite

创建sqlite

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;

public class MyDateBasrHelp extends SQLiteOpenHelper {

    final static String DBNAME = "mynews.db";// 数据库的名字

    final static int version = 1;// 数据库版本

    public MyDateBasrHelp(Context context) {

        super(context, DBNAME, null, version);

    }

    // 第一次启动时加载执行

    @Override

    public void onCreate(SQLiteDatabase db) {

        // 创建表

        String usersql = "create table user(uid integer primary key autoincrement,username varchar,password varchar,sex varchar,age integer)";

        db.execSQL(usersql);// 执行sql语句

        String newsql = "create table news(uid integer primary key autoincrement,title varchar,content varchar,newstime varchar,username varchar)";

        db.execSQL(newsql);// 执行sql语句

    }

    // 升级数据库时执行

    @Override

    public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {

    }

-------------------------------------------------------------------------------------------------------------------------------------------

添加数据到数据库

SQLiteDatabase db = Myapp.dp.getWritableDatabase();

                    String sql = "insert into user(username,password,sex,age)values('"

                            + username.getText().toString()

                            + "','"

                            + password.getText().toString()

                            + "','"

                            + sex.getText().toString()

                            + "','"

                            + Integer.parseInt(age.getText().toString()) + "')";

                    db.execSQL(sql);

-------------------------------------------------------------------------------------------------------------------------------------------

读取数据库

// 接收账户名和密码

                    //得到输入的值

                     String username0 = username.getText().toString();

                    String password0 = password.getText().toString();

                    SQLiteDatabase db = Myapp.dp.getReadableDatabase();

                     //查找符合条件的数据

                    String sql = "select * from user where  username='"

                            + username0 + "' and  password = '" + password0

                            + "'";

                    Cursor cursor = db.rawQuery(sql, null);

                    /**

                     * 判断是否有下一条数据

                     */

                    if (cursor.moveToNext()) {

                        Toast.makeText(LoginActivity.this, "登录成功",

                                Toast.LENGTH_SHORT).show();

                    } else {

                        Toast.makeText(LoginActivity.this, "登录失败",

                                Toast.LENGTH_SHORT).show();

                    }

-------------------------------------------------------------------------------------------------------------------------------------------

获取数据库内容：

SQLiteDatabase sj = App.dp.getReadableDatabase();

        String sql = "select * from phones";

        // 查询 Cursor游标

        Cursor cursor = sj.rawQuery(sql,null);

        while (cursor.moveToNext()) {

            String phoneString =cursor.getString(cursor.getColumnIndex("phone"));        

        }