android调用数据库,Android调用数据库

xml布局：

android:layout_width="match_parent"

android:layout_height="match_parent">

android:id="@+id/btn_w"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignParentTop="true"

android:layout_centerHorizontal="true"

android:layout_marginTop="155dp"

android:text="写入" />

android:id="@+id/btn_r"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignStart="@+id/btn_w"

android:layout_centerVertical="true"

android:text="查询" />

java：

import android.app.Activity;

import android.content.Intent;

import android.os.Bundle;

import android.support.annotation.Nullable;

import android.view.View;

import android.widget.Button;

import com.maeeage.administrator.androidlearn.testSql.AtyRead;

import com.maeeage.administrator.androidlearn.testSql.AtyWrite;

/**

* Created by Administrator on 2018/2/2/002.

*/

public class TestSQlite extends Activity {

Button btn_w,btn_r;

@Override

protected void onCreate(@Nullable Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.testsqlite);

findById();

inti();

}

private void inti() {

btn_w.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

write();

}

});

btn_r.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

read();

}

});

}

private void findById() {

btn_r=(Button)findViewById(R.id.btn_r);

btn_w=(Button)findViewById(R.id.btn_w);

}

//bnt_w的onclick

void write(){

Intent intent=new Intent(TestSQlite.this, AtyWrite.class);

startActivity(intent);

}

//btn_r的哦click

void read(){

Intent intent=new Intent(TestSQlite.this, AtyRead.class);

startActivity(intent);

}

}

AtyWrite.java:

package com.maeeage.administrator.androidlearn.testSql;

import android.app.Activity;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.annotation.Nullable;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.RadioButton;

import android.widget.RadioGroup;

import android.widget.Toast;

import com.maeeage.administrator.androidlearn.R;

/**

* Created by Administrator on 2018/2/2/002.

*/

public class AtyWrite extends Activity {

EditText username;

RadioButton male,female;

Button btn_write;

RadioGroup radioGroup;

SQLiteDatabase db;

@Override

protected void onCreate(@Nullable Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.write);

findById();

init();

}

private void init() {

//每个程序都要自己数据库，默认情况下各自互不干扰

//创建一个数据库，并且打开；

//通过下面这个方法，创建，如果存在就打开，不存在就创建并打开

db=  openOrCreateDatabase("user.db",MODE_PRIVATE,null);

db.execSQL("create table if not exists tb_user(_id integer primary key autoincrement,name text not null,sex text not null)");

btn_write.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

toSql();

}

});

}

private void findById() {

username=(EditText)findViewById(R.id.et_name);

male=(RadioButton)findViewById(R.id.rb_male);

female=(RadioButton)findViewById(R.id.rd_female);

btn_write=(Button)findViewById(R.id.btn_write);

radioGroup=(RadioGroup)findViewById(R.id.check_group);

}

//btn_write的onclick事件

void  toSql(){

String name=username.getText().toString();

String sex;

if(male.isChecked())

sex="男";

else

sex="女";

Toast.makeText(AtyWrite.this,name+"  "+sex,Toast.LENGTH_SHORT);

String sql="insert into tb_user(name,sex) values('"+name+"','"+sex+"')";

Toast.makeText(AtyWrite.this,name+"  "+sex,Toast.LENGTH_SHORT).show();

db.execSQL(sql);

}

}