android连接数据库

activity_main.xml:
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">
<TextView
    android:id="@+id/tv1"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="用户名:"
    android:textSize="30dp"
    android:layout_marginTop="60dp"
    />
<EditText
    android:id="@+id/et1"
    android:layout_width="600dp"
    android:layout_height="wrap_content"
    android:layout_toRightOf="@+id/tv1"
    android:layout_marginTop="50dp"
    android:textSize="30dp"
    />
<TextView
    android:id="@+id/tv2"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="密码:"
    android:textSize="30dp"
    android:layout_marginTop="50dp"
    android:layout_below="@+id/tv1"
    />
<EditText
    android:id="@+id/et2"
    android:layout_width="600dp"
    android:layout_height="wrap_content"
    android:layout_toRightOf="@+id/tv2"
    android:layout_marginTop="30dp"
    android:textSize="30dp"
    android:layout_below="@+id/et1"
    />
    <Button
        android:layout_marginTop="80dp"
        android:layout_width="300dp"
        android:layout_height="wrap_content"
        android:text="注册"
        android:textSize="50dp"
        android:layout_below="@+id/et2"
        android:layout_centerHorizontal="true"
        android:onClick="click"
        />
</RelativeLayout>

MainActivity.java:
package com.example.test;
import android.content.ContentValues;
import android.os.Bundle;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.widget.EditText;
public class MainActivity extends Activity {
    private String username;
    private String password;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
 }
    public void click(View view){
        username =((EditText) findViewById(R.id.et1)).getText().toString();
        password =((EditText) findViewById(R.id.et2)).getText().toString();
        StuOpenHelper helper = new StuOpenHelper(this);
        SQLiteDatabase db =helper.getReadableDatabase();
        ContentValues cv = new ContentValues();
        cv.put("username",username);
        cv.put("password",password);
        db.insert("stu",null,cv);
        db.close();
    }
}

helper.java:
package com.example.test;
import android.content.ContentValues;
import android.os.Bundle;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.widget.EditText;
public class MainActivity extends Activity {
    private String username;
    private String password;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
 }
    public void click(View view){
        username =((EditText) findViewById(R.id.et1)).getText().toString();
        password =((EditText) findViewById(R.id.et2)).getText().toString();
        StuOpenHelper helper = new StuOpenHelper(this);
        SQLiteDatabase db =helper.getReadableDatabase();
        ContentValues cv = new ContentValues();
        cv.put("username",username);
        cv.put("password",password);
        db.insert("stu",null,cv);
        db.close();
    }
}

 

posted @ 2020-11-28 19:13  white_poplar  阅读(146)  评论(0编辑  收藏  举报