Android——LitePal第三方数据库框架详解

<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 = (Button) 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;

case R.id.button4: //改

tbUser.setSex(“女”);

tbUser.setUsername(“abc”);

//修改

tbUser.updateAll(“id = ? or id = ?”, “2”, “4”);

break;

case R.id.button5: //查

Android开发除了flutter还有什么是必须掌握的吗？

相信大多数从事Android开发的朋友们越来越发现，找工作越来越难了，面试的要求越来越高了

除了基础扎实的java知识，数据结构算法，设计模式还要求会底层源码，NDK技术，性能调优，还有会些小程序和跨平台，比如说flutter，以思维脑图的方式展示在下图；

《Android学习笔记总结+移动架构视频+大厂面试真题+项目实战源码》，点击传送门，即可获取！
", “2”, “4”);

break;

case R.id.button5: //查

Android开发除了flutter还有什么是必须掌握的吗？

相信大多数从事Android开发的朋友们越来越发现，找工作越来越难了，面试的要求越来越高了

除了基础扎实的java知识，数据结构算法，设计模式还要求会底层源码，NDK技术，性能调优，还有会些小程序和跨平台，比如说flutter，以思维脑图的方式展示在下图；

[外链图片转存中…(img-u1mDEgvY-1714470043741)]

《Android学习笔记总结+移动架构视频+大厂面试真题+项目实战源码》，点击传送门，即可获取！