软件工程日报——第十四天

今天完成了app开发中的页面信息填写并存入数据库功能。

如图三个java类就是信息填写并存入数据库所需要的东西

 

 

ContentActivity.java

 

 

package com.example.myapplication;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.CalendarView;
import android.widget.EditText;
import android.widget.Toast;


public class ContentActivity extends Activity {
    // 调用Actvity
    private SQlite2 mSQlite;
    private EditText time;
    private EditText word;
    private EditText text;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_content);

      //  mSQlite = new SQlite2(this);
        // 关联用户名、密码和登录、注册按钮

        EditText time = (EditText) this.findViewById(R.id.time);
        EditText word = (EditText) this.findViewById(R.id.word);
        EditText text = (EditText) this.findViewById(R.id.text);

        // 登录按钮监听器
        Button successButton = (Button) this.findViewById(R.id.successButton);
        successButton.setOnClickListener(
                new OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        String strtime = time.getText().toString().trim();
                        String strword= word.getText().toString().trim();
                        String strtext = text.getText().toString().trim();
                        mSQlite.add(strtime,strword,strtext);

                        Toast.makeText(ContentActivity.this, "提交成功！", Toast.LENGTH_SHORT).show();
                    }
                    //@Override
                    public void onSelectedDayChange(CalendarView view, int year, int month, int dayOfMonth) {
                        Toast.makeText(ContentActivity.this,"您选择的时间是："+ year + "年" + month + "月" + dayOfMonth + "日",Toast.LENGTH_SHORT).show();
                    }

                }
        );
        mSQlite = new SQlite2(ContentActivity.this);

      }

}


Word.java

package com.example.myapplication;

public class Word {
    private  String time;
    private  String word;
    private  String text;
    public Word(String time,String word,String text){
        super();
        this.time = time;
        this.word = word;
        this.text = text;
    }

    public String getWord() {
        return word;
    }

    public String getText() {
        return text;
    }

    public void setWord(String word) {
        this.word = word;
    }

    public String getTime() {
        return time;
    }

    public void setText(String text) {
        this.text = text;
    }

    public void setTime(String time) {
        this.time = time;
    }

    @Override
    public String toString() {
        return "Word{time ="+ time + ", word = "+ word +",text ="+text +"}";
    }
}

 

 SQlite.java

 

package com.example.myapplication;

import android.annotation.SuppressLint;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.EditText;

import com.example.myapplication.User;

import java.util.ArrayList;

public class SQlite2 extends SQLiteOpenHelper {
    private SQLiteDatabase db;
    public SQlite2(Context context){
        super(context,"db_text",null,1);
        db = getReadableDatabase();

    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE IF NOT EXISTS word(" +
                "_id INTEGER PRIMARY KEY AUTOINCREMENT," +
                "time TEXT," +
                "word TEXT," +
                "text TEXT)");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS word");
        onCreate(db);
    }
    public void add(String time,String word,String text ){
        db.execSQL("INSERT INTO word (time,word,text) VALUES(?,?,?)",new Object[]{time,word,text});
    }

    public ArrayList<Word> getAllDATA(){
        ArrayList<Word> list = new ArrayList<Word>();
        Cursor cursor = db.query("world",null,null,null,null,null,"name DESC");
        while(cursor.moveToNext()){
            String time = cursor.getString(cursor.getColumnIndex("time"));
            String word = cursor.getString(cursor.getColumnIndex("word"));
            String text = cursor.getString(cursor.getColumnIndex("text"));
            list.add(new Word(time,word,text));
        }
        return list;
    }


}