package entity;
public class Day {
public String getKeyword() {
return keyword;
}
public void setKeyword(String keyword) {
this.keyword = keyword;
}
public String keyword;
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public String content;
public String getCreatedTime() {
return createdTime;
}
public void setCreatedTime(String createdTime) {
this.createdTime = createdTime;
}
public String createdTime;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String id;
public Day(){};
public Day(String keyword,String content,String createdTime,String id){
this.keyword=keyword;
this.content=content;
this.createdTime=createdTime;
this.id=id;
}
@Override
public String toString() {
return "Day{" +
"keyword='" + keyword + '\'' +
", content='" + content + '\'' +
", createdTime='" + createdTime + '\'' +
", id='" + id + '\'' +
'}';
}
}
package com.example.newclock;
import android.util.Log;import android.view.View;import android.widget.EditText;import android.widget.TextView;import android.widget.Toast;import androidx.appcompat.app.AppCompatActivity;import android.os.Bundle;import database.UserDBHelper;import entity.User;import org.w3c.dom.Text;
import java.util.List;
public class SQLiteHelperActivity extends AppCompatActivity implements View.OnClickListener {
private EditText et_id;
private EditText et_name;
private EditText et_ph;
private EditText et_class;
private TextView tv_show;
private UserDBHelper mHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_sqlite_helper);
et_id=findViewById(R.id.et_id);
et_name=findViewById(R.id.et_name);
et_ph=findViewById(R.id.et_ph);
et_class=findViewById(R.id.et_class);
tv_show = findViewById(R.id.tv_show);
findViewById(R.id.bt_register).setOnClickListener(this);
findViewById(R.id.bt_delete).setOnClickListener(this);
findViewById(R.id.bt_update).setOnClickListener(this);
findViewById(R.id.bt_all).setOnClickListener(this);
}
protected void onStart() {
super.onStart();
mHelper=UserDBHelper.getInstance(this);
mHelper.openWriteLink();
mHelper.openReadLink();
}
@Override
protected void onStop() {
super.onStop();
mHelper.closeLink();
}
@Override
public void onClick(View view) {
String Id=et_id.getText().toString();
String Name=et_name.getText().toString();
String Pn=et_ph.getText().toString();
String class="et_class".getText().toString();
int a=1;
User user=new User();
switch (view.getId())
{
case R.id.bt_register:
user.setId(Id);
user.setName(Name);
user.setPn(Pn);
user.setCs(Class);
if(Pn.length()!=11)
{
Toast.makeText(this, "请输入正确的手机号", Toast.LENGTH_SHORT).show();
return;
}
if(mHelper.queryOne(Id)>0)
{
Toast.makeText(this, "该学号已存在", Toast.LENGTH_SHORT).show();
return;
}
//Log.d("ning",Id); mHelper.insert(user);
Toast.makeText(this, "添加成功", Toast.LENGTH_SHORT).show();
break;
case R.id.bt_delete:
if(mHelper.deleteById(Id)>0)
{
Toast.makeText(this, "删除成功", Toast.LENGTH_SHORT).show();
}
break;
case R.id.bt_update:
user=new User(Id,Name,Pn,Class);
if(mHelper.update(user)>0)
{
Toast.makeText(this, "修改成功", Toast.LENGTH_SHORT).show();
}
break;
case R.id.bt_all:
List<User> list=mHelper.queryAll();
for(User u:list)
{
Log.d("ning",u.toString());
}
StringBuffer buffer=new StringBuffer();
if(list.size()==0){
tv_show.setText("没有数据");
}else {
for (int i=0;i<list.size();i++){
user= list.get(i);
buffer.append("id:" +user.getId()+
"用户名:"+user.getName()+
"手机号:"+user.getPn()+
"班级:"+user.getCs()+"\n");
}
tv_show.setText(buffer);
}
break;
}
}
}
package database;
import android.content.ContentValues;import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.util.Log;import entity.Day;import entity.User;
import java.util.ArrayList;import java.util.List;
public class UserDBHelper extends SQLiteOpenHelper {
private static final String DB_NAME="user.db";
private static final String TABLE_NAME="user_info";
private static final String TABLE_NAME1="day_info";
private static final int DB_VERSION=1;
private static UserDBHelper mHelper=null;
private SQLiteDatabase mRDB=null;
private SQLiteDatabase mWDB=null;
private UserDBHelper(Context context){
super(context,DB_NAME,null,DB_VERSION);
}
public static UserDBHelper getInstance(Context context){
if(mHelper==null)
{
mHelper=new UserDBHelper(context);
}
return mHelper;
}
public SQLiteDatabase openReadLink(){
if(mRDB==null||!mRDB.isOpen())
{
mRDB=mHelper.getReadableDatabase();
}
return mRDB;
}
public SQLiteDatabase openWriteLink(){
if(mWDB==null||!mWDB.isOpen())
{
mWDB=mHelper.getWritableDatabase();
}
return mWDB;
}
public void closeLink(){
if(mRDB!=null&&mRDB.isOpen())
{
mRDB.close();
mRDB=null;
}
if(mWDB!=null&&mWDB.isOpen())
{
mWDB.close();
mWDB=null;
}
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql="CREATE TABLE IF NOT EXISTS "+TABLE_NAME+"("+
" Id VARCHAR NOT NULL,"+
" Name VARCHAR NOT NULL,"+
" Pn VARCHAR NOT NULL,"+
" Class VARCHAR NOT NULL)";
db.execSQL(sql);
sql="CREATE TABLE IF NOT EXISTS "+TABLE_NAME1+"("+
" keyword VARCHAR NOT NULL,"+
" content VARCHAR NOT NULL,"+
" createdtime VARCHAR NOT NULL,"+
" id VARCHAR NOT NULL)";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
public void insert(User user)
{
Log.d("ning",user.Id);
ContentValues values=new ContentValues();
values.put("Id",user.Id);
values.put("Name",user.Name);
values.put("Pn",user.Pn);
values.put("Class",user.Cs);
mWDB.insert(TABLE_NAME,null,values);
}
public int insertDay(Day day)
{
ContentValues values=new ContentValues();
values.put("keyword",day.keyword);
values.put("content",day.content);
values.put("createdTime",day.createdTime);
values.put("id",day.id);
mWDB.insert(TABLE_NAME1,null,values);
int a=1;
return a;
}
public long deleteById(String Id)
{
return mWDB.delete(TABLE_NAME,"Id=?",new String[]{Id});
}
public long update(User user)
{
ContentValues values=new ContentValues();
values.put("Id",user.Id);
values.put("Name",user.Name);
values.put("Pn",user.Pn);
values.put("Class",user.Cs);
return mWDB.update(TABLE_NAME,values,"Id=?",new String[]{user.Id});
}
public List<User> queryAll(){
List<User> list=new ArrayList<>();
Cursor cursor=mRDB.query(TABLE_NAME,null,null,null,null,null,null);
while (cursor.moveToNext()){
User user=new User();
user.Id=cursor.getString(0);
user.Name=cursor.getString(1);
user.Pn=cursor.getString(2);
user.Cs=cursor.getString(3);
list.add(user);
}
return list;
}
public List<Day> queryAllDay(){
List<Day> list=new ArrayList<>();
Cursor cursor=mRDB.query(TABLE_NAME1,null,null,null,null,null,null);
while (cursor.moveToNext()){
Day day=new Day();
day.keyword=cursor.getString(0);
day.content=cursor.getString(1);
day.createdTime=cursor.getString(2);
day.id=cursor.getString(3);
list.add(day);
}
return list;
}
public int queryOne(String Id){
List<User> list1=new ArrayList<>();
Cursor cursor=mRDB.query(TABLE_NAME,null,"Id=?",new String[]{Id},null,null,null);
int a=0;
while (cursor.moveToNext()){
User user=new User();
user.Id=cursor.getString(0);
user.Name=cursor.getString(1);
user.Pn=cursor.getString(2);
user.Cs=cursor.getString(3);
a=1;
list1.add(user);
}
return a;
}
}
package entity;
public class User {
public String getId() {
return Id;
}
public void setId(String id) {
Id = id;
}
public String Id;
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public String Name;
public String getPn() {
return Pn;
}
public void setPn(String pn) {
Pn = pn;
}
public String Pn;
public String getCs() {
return Cs;
}
public void setCs(String cs) {
Cs = cs;
}
public String Cs;
public User(){
}
public User(String Id,String Name,String Pn,String Cs){
this.Id=Id;
this.Name=Name;
this.Pn=Pn;
this.Cs=Cs;
}
@Override
public String toString() {
return "User{" +
"Id='" + Id + '\'' +
", Name='" + Name + '\'' +
", Pn='" + Pn + '\'' +
", Cs='" + Cs + '\'' +
'}';
}
}
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
xmlns:app="http://schemas.android.com/apk/res-auto"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".AddActivity"
android:orientation="vertical"
>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="vertical"
android:padding="10dp">
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="关键字" />
<EditText
android:id="@+id/et_keyword"
android:maxLines="1"
android:layout_width="match_parent"
android:layout_marginLeft="5dp"
android:layout_height="wrap_content"/>
</LinearLayout>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="内容" />
<EditText
android:id="@+id/et_content"
android:layout_width="match_parent"
android:gravity="left"
android:layout_height="300dp"
android:layout_marginTop="5dp" />
<Button android:id="@+id/bt_add1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="添加" />
<Button android:id="@+id/bt_all1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="浏览" />
</LinearLayout>
</LinearLayout>
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
xmlns:app="http://schemas.android.com/apk/res-auto"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".LoginActicity"
android:orientation="vertical"
>
<EditText android:id="@+id/et_id1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:hint="学号"
android:layout_marginTop="200dp"
/>
<EditText android:id="@+id/et_password"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:hint="密码(初始密码为学号)"
/>
<Button android:id="@+id/bt_login"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="登录"/>
<Button android:id="@+id/bt_register1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="注册"/>
</LinearLayout>
<?xml version="1.0" encoding="utf-8"?>
<FrameLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
xmlns:app="http://schemas.android.com/apk/res-auto"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">
<androidx.recyclerview.widget.RecyclerView
android:layout_width="match_parent"
android:layout_height="match_parent"
android:id="@+id/rlv"
/>
<com.google.android.material.floatingactionbutton.FloatingActionButton
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:src="@android:drawable/ic_input_add"
android:layout_gravity="right|bottom"
android:layout_margin="20dp"
android:id="@+id/bt_add"
/>
</FrameLayout>
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
xmlns:app="http://schemas.android.com/apk/res-auto"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".SQLiteHelperActivity"
android:orientation="vertical"
>
<EditText
android:id="@+id/et_id"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_marginTop="160dp"
android:hint="学号"
/>
<EditText
android:id="@+id/et_name"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_marginTop="5dp"
android:hint="姓名"
/>
<EditText
android:id="@+id/et_ph"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_marginTop="5dp"
android:hint="手机号码"
/>
<EditText
android:id="@+id/et_class"
android:layout_width="match_parent"
android:layout_height="50dp"
android:layout_marginTop="5dp"
android:hint="班级"
/>
<Button
android:id="@+id/bt_register"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:onClick="add"
android:text="注册"
/>
<Button
android:id="@+id/bt_delete"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="删除"
/>
<Button
android:id="@+id/bt_update"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="修改"
/>
<Button
android:id="@+id/bt_all"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="浏览"
/>
<TextView
android:id="@+id/tv_show"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:layout_below="@id/bt_register"
android:textSize="10dp" />
</LinearLayout>
标签：layout,String,app,public,user,打卡,id,android From： https://www.cnblogs.com/zzfdbk/p/17472708.html