android 代码操作.db demo,SQL语句操作SQLite数据库Demo

布局文件如下：

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context="com.example.sqlite.MainActivity"

android:orientation="vertical">

android:id="@+id/et_name"

android:layout_width="match_parent"

android:layout_height="wrap_content"

/>

android:id="@+id/et_desc"

android:layout_width="match_parent"

android:layout_height="wrap_content"

/>

android:id="@+id/btn_insert"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="insert"/>

android:id="@+id/lv_info"

android:layout_width="match_parent"

android:layout_height="wrap_content"/>

Activity代码如下：

public class MainActivity extends AppCompatActivity {

private SQLiteDatabase db;

private Button btn_insert;

private EditText et_name,et_desc;

private ListView listView;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

// null表示使用默认的工厂

db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+"/my.db3",null);

btn_insert = (Button) findViewById(R.id.btn_insert);

listView = (ListView) findViewById(R.id.lv_info);

et_name = (EditText) findViewById(R.id.et_name);

et_desc = (EditText) findViewById(R.id.et_desc);

btn_insert.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

String name = et_name.getText().toString();

String desc = et_desc.getText().toString();

try{

insertData(db,name,desc);

Cursor cursor = db.rawQuery("select * from news_info",null);

inflateCursor(cursor);

}catch (SQLiteException e){

db.execSQL("create table news_info(_id integer primary key autoincrement," +

" news_name varchar(50),news_desc varchar(255))");

insertData(db,name,desc);

Cursor cursor = db.rawQuery("select * from news_info",null);

inflateCursor(cursor);

}

}

});

}

private void insertData(SQLiteDatabase db,String name,String desc){

db.execSQL("insert into news_info values(null,?,?)",

new String[]{name,desc});

}

private void inflateCursor(Cursor cursor){

SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,R.layout.line,cursor,

new String[]{"news_name","news_desc"},new int[]{R.id.news_name,R.id.news_desc},

CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER);

listView.setAdapter(adapter);

}

@Override

protected void onDestroy() {

super.onDestroy();

if(db != null && db.isOpen()){

db.close();

}

}

}

运行效果：