1. MainActivity.java
<?xml version="1.0" encoding="utf-8"?> <manifest package="com.sh.appsqlitedatabase" xmlns:android="http://schemas.android.com/apk/res/android"> <application android:allowBackup="true" android:icon="@mipmap/ic_launcher" android:label="@string/app_name" android:supportsRtl="true" android:theme="@style/AppTheme"> <activity android:name=".MainActivity"> <intent-filter> <action android:name="android.intent.action.MAIN"/> <category android:name="android.intent.category.LAUNCHER"/> </intent-filter> </activity> </application> </manifest> 2.xml文件 public class MainActivity extends AppCompatActivity { SQLiteDatabase db; Button bn; ListView listView; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); //创建或打开数据库（要用绝路径） db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString() + "my.db3",null); listView = (ListView)findViewById(R.id.show); bn = (Button)findViewById(R.id.bn); bn.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { //获取用户的输入 String title = ((EditText)findViewById(R.id.title)).getText().toString(); String content = ((EditText)findViewById(R.id.content)).getText().toString(); try { insertData(db,title,content); Cursor cursor = db.rawQuery("select * from news_inf" ,null); inflateList(cursor); } catch (Exception e) { //执行ddl创建数据表 db.execSQL("create table news_inf(_id integer" +" primary key autoincrement," +" news_title varchar(50)," +" news_content varchar(255))" ); //执行insert语句 insertData(db,title,content); //执行查询 Cursor cursor = db.rawQuery("select * from news_inf" ,null); inflateList(cursor); // e.printStackTrace(); } } }); } public void insertData(SQLiteDatabase db,String title,String content) { //执行插入语句 db.execSQL("insert into news_inf values (null,?,?)" ,new String[]{title,content}); } public void inflateList(Cursor cursor) { // 填充 SimpleCursorAdapter SimpleCursorAdapter adapter = new SimpleCursorAdapter( MainActivity.this, R.layout.line,cursor, new String[]{"news_title","news_content"}, new int[]{R.id.my_title,R.id.my_content}, CursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER); // 显示数据 listView.setAdapter(adapter); } public void onDestroy() { super.onDestroy(); //退出程序时 } } 3.line.xml文件 <?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" > <TextView android:id="@+id/my_title" android:layout_width="wrap_content" android:layout_height="wrap_content"/> <TextView android:id="@+id/my_content" android:layout_width="wrap_content" android:layout_height="wrap_content"/> </LinearLayout>
