Android开发中,基本上都离不开操作SQLite数据库操作,最近工作上的事情不是很多,把这块捡起来复习、总结一下。加深印象,方便以后查阅,也希望能给新手带来一些帮助。
代码并不复杂,注释也比较清楚,先把代码都贴出来。
一. 代码
- AndroidManifest.xml,应用Application为AppApplication,方便后面获取上下文
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.li.testdb">
<application
android:name=".AppApplication"
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>
- MainActivity.java & activity_main.xml,增删改查四个操作按钮
package com.li.testdb;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import com.li.testdb.bean.User;
import com.li.testdb.bean.UserDao;
import java.util.List;
public class MainActivity extends Activity implements View.OnClickListener{
private static final String TAG = "MainActivity";
private Button btnInsert;
private Button btnQuery;
private Button btnUpdate;
private Button btnDelete;
private TextView tvResult;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
initViews();
}
private void initViews() {
btnInsert = (Button) findViewById(R.id.btnInsert);
btnQuery = (Button) findViewById(R.id.btnQuery);
btnUpdate = (Button) findViewById(R.id.btnUpdate);
btnDelete = (Button) findViewById(R.id.btnDelete);
tvResult = (TextView) findViewById(R.id.tvResult);
btnInsert.setOnClickListener(this);
btnQuery.setOnClickListener(this);
btnUpdate.setOnClickListener(this);
btnDelete.setOnClickListener(this);
}
@Override
public void onClick(View v) {
switch (v.getId()){
case R.id.btnInsert:
inserUser();
break;
case R.id.btnQuery:
getUserInfo();
break;
case R.id.btnUpdate:
updateUserInfo();
break;
case R.id.btnDelete:
deleteUserInfo();
break;
default:
break;
}
}
/**
* 删除userId为1001的用户信息
*/
private void deleteUserInfo() {
String userId = "1001";
int flag = UserDao.deleteUserById(userId);
Log.e(TAG, "deleteUserInfo: " + flag);
}
/**
* 更新userId为1001的用户信息
*/
private void updateUserInfo() {
User user = new User();
user.setUserId("1001");
// 测试 只更新 name
user.setName("萧峰");
// user.setPhoneNbr("159****19");
// user.setSex("男");
// user.setIdNbr("7654321X");
int flag = UserDao.updateUserById(user);
Log.e(TAG, "updateUserInfo: " + flag);
}
/**
* 添加userId为1001的用户信息
*/
private void inserUser() {
User user = new User();
user.setUserId("1001");
user.setName("乔峰");
user.setPhoneNbr("159****19");
user.setSex("男");
user.setIdNbr("1234567X");
int flag = UserDao.insert(user);
Log.e(TAG, "inserUser: " + flag);
}
/**
* 获取userId为1001的用户信息
*/
private void getUserInfo(){
List<User> userList = UserDao.getUserById