android:id=“@+id/button1”
android:layout_width=“match_parent”
android:layout_height=“wrap_content”
android:text=“创建数据库” />
<Button
android:id=“@+id/button2”
android:layout_width=“match_parent”
android:layout_height=“wrap_content”
android:text=“添加数据” />
<Button
android:id=“@+id/button3”
android:layout_width=“match_parent”
android:layout_height=“wrap_content”
android:text=“删除” />
<Button
android:id=“@+id/button4”
android:layout_width=“match_parent”
android:layout_height=“wrap_content”
android:text=“修改” />
<Button
android:id=“@+id/button5”
android:layout_width=“match_parent”
android:layout_height=“wrap_content”
android:text=“查找” />
TbUser.java定义的实体类,要继承DataSupport
package com.mcy.litepaldemo.model;
import java.util.Date;
import org.litepal.crud.DataSupport;
public class TbUser extends DataSupport {
private Integer id;
private String username;
private String password;
private String name;
private String sex;
private Date born;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public Date getBorn() {
return born;
}
public void setBorn(Date born) {
this.born = born;
}
public TbUser(String username, String password, String name, String sex,
Date born) {
super();
this.username = username;
this.password = password;
this.name = name;
this.sex = sex;
this.born = born;
}
public TbUser(Integer id, String username, String password, String name,
String sex, Date born) {
super();
this.id = id;
this.username = username;
this.password = password;
this.name = name;
this.sex = sex;
this.born = born;
}
public TbUser() {
super();
}
}
MainActivity.java增删改查实际操作:
package com.mcy.litepaldemo;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;
import org.litepal.LitePal;
import org.litepal.crud.DataSupport;
import com.mcy.litepaldemo.model.TbUser;
import android.app.Activity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity implements OnClickListener{
private Button button1;
private Button button2;
private Button button3;
private Button button4;
private Button button5;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
button1 = (Butto
n) findViewById(R.id.button1);
button2 = (Button) findViewById(R.id.button2);
button3 = (Button) findViewById(R.id.button3);
button4 = (Button) findViewById(R.id.button4);
button5 = (Button) findViewById(R.id.button5);
button1.setOnClickListener(this);
button2.setOnClickListener(this);
button3.setOnClickListener(this);
button4.setOnClickListener(this);
button5.setOnClickListener(this);
}
@Override
public void onClick(View v) {
TbUser tbUser = new TbUser();
switch (v.getId()) {
case R.id.button1:
//调用LitePal插件中getDAtabase方法创建数据库
LitePal.getDatabase();
break;
case R.id.button2: //增
SimpleDateFormat ft = new SimpleDateFormat (“yyyy-MM-dd”);
tbUser.setName(“张三”);
tbUser.setUsername(“admin”);
tbUser.setPassword(“admin”);
tbUser.setSex(“男”);
try {
tbUser.setBorn(ft.parse(“2019-03-06”));
} catch (ParseException e) {
e.printStackTrace();
}
tbUser.save();
break;
case R.id.button3: //删
//删除TbUser类中id=3的元素
DataSupport.delete(TbUser.class, 3);
//根据条件删除
//DataSupport.deleteAll(TbUser.class, “sex = ?”, “女”);
break;