插入数据SQLite Android Studio [英] Insert data SQLite Android Studio

问题描述

美好的一天

我是Android编程的新手.我想在启动时插入属于应用程序的数据.我已经创建了数据库.

DatabaseHelper类

Good day

I am new to Android Programming. I want to insert data that is part of the App when it start up. I have already created the database.

DatabaseHelper class

package app.mobiledevicesecurity;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by Martin on 2015/07/28.
 */
public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "mobilesec.db";
    public static final String TABLE_NAME = "read_table";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "CATEGORY";
    public static final String COL_3 = "HEADING";
    public static final String COL_4 = "INFO";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
        SQLiteDatabase db = this.getWritableDatabase();
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, CATEGORY TEXT, HEADING TEXT, INFO TEXT)");


    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(db);
    }
}

MainActivity类

MainActivity class

package app.mobiledevicesecurity;

import android.content.Intent;
import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;


public class MainActivity extends ActionBarActivity {
    DatabaseHelper myDb;
    private static Button readbtn;
    private static Button quizbtn;
    private static Button scoresbtn;
    private static Button settingsbtn;
    private static Button helpbtn;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        myDb = new DatabaseHelper(this);
         OnClickReadButtonListener();
         OnClickQuizButtonListener();
         OnClickScoresButtonListener();
         OnClickSettingsButtonListener();
         OnClickHelpButtonListener();


    }

    public void OnClickReadButtonListener() {
        readbtn = (Button) findViewById(R.id.readbutton);
        readbtn.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Intent intent = new Intent("app.mobiledevicesecurity.Read_Category");
                        startActivity(intent);
                    }
                }
        );
    }

    public void OnClickQuizButtonListener() {
        quizbtn = (Button) findViewById(R.id.quizbutton);
        quizbtn.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Intent intent = new Intent("app.mobiledevicesecurity.Quiz");
                        startActivity(intent);
                    }
                }
        );
    }

    public void OnClickScoresButtonListener() {
        scoresbtn = (Button) findViewById(R.id.scoresbutton);
        scoresbtn.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Intent intent = new Intent("app.mobiledevicesecurity.Scores");
                        startActivity(intent);
                    }
                }
        );
    }

    public void OnClickSettingsButtonListener() {
        settingsbtn = (Button) findViewById(R.id.settingsbutton);
        settingsbtn.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Intent intent = new Intent("app.mobiledevicesecurity.Settings");
                        startActivity(intent);
                    }
                }
        );
    }

    public void OnClickHelpButtonListener() {
        helpbtn = (Button) findViewById(R.id.helpbutton);
        helpbtn.setOnClickListener(
                new View.OnClickListener() {
                    @Override
                    public void onClick(View v) {
                        Intent intent = new Intent("app.mobiledevicesecurity.Help");
                        startActivity(intent);
                    }
                }
        );
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.menu_main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }
}

我希望在应用启动时添加以下数据，例如
类别:恶意软件
标题:病毒
信息:害羞

如果有人可以帮助我，请

I want the following data for instance to be added when the app start
Category: Malware
Heading: Virus
Info: Harmfull

If anyone can help me please

推荐答案

package app.mobiledevicesecurity;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by Martin on 2015/07/28.
 */
public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "mobilesec.db";
    public static final String TABLE_NAME = "read_table";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "CATEGORY";
    public static final String COL_3 = "HEADING";
    public static final String COL_4 = "INFO";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
        SQLiteDatabase db = this.getWritableDatabase();
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT, CATEGORY TEXT, HEADING TEXT, INFO TEXT)");
        ContentValues cv = new ContentValues();
        cv.put(COL_1,1);
        cv.put(COL_2,"Malware");
        cv.put(COL_3,"Virus");
        cv.put(COL_4,"Harmfull for device");
        db.insert(TABLE_NAME, null, cv);



    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS "+TABLE_NAME);
        onCreate(db);
    }
}

我添加了插入命令.但是，当我使用SQlite浏览器打开数据库时，它似乎并没有将数据保存在数据库中.我做错什么了吗?

I have added the insert command. But it does not seem to save the data in the database when I open the database with SQlite browser. Am I doing something wrong?

这篇关于插入数据SQLite Android Studio的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！