第三方框架和控件
一.为什么要使用第三方框架和控件?
1.第三方框架、控件经过大量程序员的实践、迭代,性能稳定,效率较高。
2.使用第三方框架、控件可以减少工作量。通常只需要几行代码即可实现较复杂功能。
3.无需掌握某个功能具体实现原理,调用简单方便。
二.如何使用LitePal操作数据库
1.首先配置LitePal
编辑app/build.gradle文件,在dependencies闭包中添加以下内容:
compile ‘org.litepal.android:core:1.6.1’
debugImplementation ‘com.amitshekhar.android:debug-db:1.0.3’
2.接着在project下面的main下面建一个assets的包,在包里面新建一个litepal.xml的文件。
<?xml version="1.0" encoding="utf-8"?>
<litepal>
<dbname value="demo" />
<version value="1" />
<list>
<mapping class="myapplication.com.example.zhihui.Song"/>
<mapping class="myapplication.com.example.zhihui.Album"/>
</list>
</litepal>
3.在Androidmanifest里面添加:
android:name=”org.litepal.LitePalApplication”
4.在数据库里面新建一个Song类(运用setter和getter方法)
public class Song extends DataSupport {
@Column(nullable = false)
private String name;
private int duration;
@Column(ignore = true)
private String uselessField;
private Album album;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getDuration() {
return duration;
}
public void setDuration(int duration) {
this.duration = duration;
}
public String getUselessField() {
return uselessField;
}
public void setUselessField(String uselessField) {
this.uselessField = uselessField;
}
public Album getAlbum() {
return album;
}
public void setAlbum(Album album) {
this.album = album;
}
}
5.在数据库中再新建一个Album类(运用setter和getter方法)
public class Album extends DataSupport {
@Column(unique = true, defaultValue = "unknown")
private String name;
private float price;
private List<Song> songs = new ArrayList<Song>();
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
public List<Song> getSongs() {
return songs;
}
public void setSongs(List<Song> songs) {
this.songs = songs;
}
}
6.最后在XML布局文件中写edittext控件和四个button按钮。
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
tools:context="myapplication.com.example.zhihui.MainActivity">
<EditText
android:layout_width="match_parent"
android:layout_height="50dp"
android:id="@+id/album_et"
/>
<Button
android:id="@+id/add_album_btn"
android:layout_width="match_parent"
android:layout_height="50dp"
android:text="添加专辑"/>
<Button
android:id="@+id/add_motify_btn"
android:layout_width="match_parent"
android:layout_height="50dp"
android:text="修改专辑"/>
<Button
android:id="@+id/add_delete_btn"
android:layout_width="match_parent"
android:layout_height="50dp"
android:text="删除专辑"/>
<Button
android:id="@+id/add_query_btn"
android:layout_width="match_parent"
android:layout_height="50dp"
android:text="查询专辑"/>
</LinearLayout>
7.在java代码中写:
public class MainActivity extends AppCompatActivity implements View.OnClickListener {
private EditText albumEt;
private Button addAlbumBtn;
private Button motifyBtn;
private Button deleteBtn;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Log.e("MAIN", "数据库在线查看地址:" + DebugDB.getAddressLog());
// SQLiteDatabase db= LitePal.getDatabase();
bindID();
}
private void bindID() {
albumEt = findViewById(R.id.album_et);
addAlbumBtn = findViewById(R.id.add_album_btn);
motifyBtn = findViewById(R.id.add_motify_btn);
deleteBtn = findViewById(R.id.add_delete_btn);
addAlbumBtn.setOnClickListener(this);
deleteBtn.setOnClickListener(this);
motifyBtn.setOnClickListener(this);
}
下面就是在switch语句里面进行增删改查的操作了。
@Override
public void onClick(View view) {
switch (view.getId()) {
//添加数据
case R.id.add_album_btn:
String albumName = albumEt.getText().toString();
float price = 109.9f;
Album album = new Album();
album.setName(albumName);
album.setPrice(price);
album.save();//保存至数据库
break;
//修改数据
case R.id.add_motify_btn:
Album album1 = DataSupport.find(Album.class, 2);
album1.setName("Fantasy");
album1.save();//保存至数据库
break;
//删除数据
case R.id.add_delete_btn:
int row = DataSupport.deleteAll(Album.class, "id>?", "3");
Toast.makeText(this, "您删除了吗" + row + "行数据", Toast.LENGTH_SHORT).show();
break;
//查询数据
case R.id.add_query_btn:
List<Album> albumList = DataSupport.where("name like ?", "a%").order("name").find(Album.class);
for (Album a :
albumList
) {
Log.e("MAIN", a.getName() + "***********");
}
break;
}
}