xml布局:
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent">
<Button
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="写入" />
<Button
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="查询" />
</RelativeLayout>
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);
}
}