register.xml
<span style="font-size:14px;"><?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:singleLine="true"
android:text="账号:"
android:textSize="20dp" />
<EditText
android:id="@+id/edt_count"
android:layout_width="282dp"
android:layout_height="wrap_content"
android:hint="请输入你的账号"
android:singleLine="true" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:singleLine="true"
android:text="密码:"
android:textSize="20dp" />
<EditText
android:id="@+id/edt_password"
android:layout_width="282dp"
android:layout_height="wrap_content"
android:hint="请输入你的密码"
android:password="true"
android:singleLine="true" />
</LinearLayout>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:singleLine="true"
android:text="确认密码:"
android:textSize="20dp" />
<EditText
android:id="@+id/edt_passwordagain"
android:layout_width="282dp"
android:layout_height="wrap_content"
android:hint="请再次输入你的密码"
android:singleLine="true" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:gravity="center"
android:orientation="horizontal" >
<Button
android:id="@+id/btn_register"
android:layout_width="wrap_content"
android:layout_height="fill_parent"
android:text="注册" />
<Button
android:id="@+id/btn_return"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="50dp"
android:text="返回" />
</LinearLayout>
</LinearLayout></span>
login.xml
<span style="font-size:14px;"><?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:id="@+id/txt1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:singleLine="true"
android:text="账号:"
android:textSize="20dp" />
<EditText
android:id="@+id/edt_count"
android:layout_width="282dp"
android:layout_height="wrap_content"
android:hint="请输入你的账号"
android:singleLine="true" >
</EditText>
</LinearLayout>
<LinearLayout
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<TextView
android:id="@+id/txt2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:singleLine="true"
android:text="密码:"
android:textSize="20dp" />
<EditText
android:id="@+id/edt_password"
android:layout_width="282dp"
android:layout_height="wrap_content"
android:hint="请输入你的密码"
android:singleLine="true"
android:password="true" />
</LinearLayout>
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:gravity="center"
android:orientation="horizontal" >
<Button
android:id="@+id/btn_login"
android:layout_width="wrap_content"
android:layout_height="fill_parent"
android:text="登录" />
<Button
android:id="@+id/btn_gotoregsiter"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="50dp"
android:text="注册" />
</LinearLayout>
</LinearLayout></span>
<span style="font-size:14px;">package com.example.login;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "mydb.db";
private static final int VERSION = 1;
private static final String CREATE_SQL = "create table if not exists Users"+
"(id int primary key,name,password)";
private static final String DELETE_SQL = "drop table if exists Users;";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, VERSION);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO Auto-generated method stub
arg0.execSQL(CREATE_SQL);
}
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
arg0.execSQL(DELETE_SQL);
arg0.execSQL(CREATE_SQL);
}
}
</span>
register.java
<span style="font-size:14px;">package com.example.login;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class register extends Activity{
Button btnRegister;
Button btnReturn;
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.register);
//db=SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+"my.db3", null);
setupViewComponent();
}
private void setupViewComponent() {
// TODO Auto-generated method stub
btnRegister=(Button)findViewById(R.id.btn_register);
btnReturn=(Button)findViewById(R.id.btn_return);
btnRegister.setOnClickListener(btnRegisterOnClickLis);
btnReturn.setOnClickListener(btnReturnOnClickLis);
}
private Button.OnClickListener btnRegisterOnClickLis=new Button.OnClickListener(){
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
String name=((EditText)findViewById(R.id.edt_count)).getText().toString();
String password=((EditText)findViewById(R.id.edt_password)).getText().toString();
String passwordagain=((EditText)findViewById(R.id.edt_passwordagain)).getText().toString();
if(password.equals(passwordagain)){
try{
// insertData(db,name,password);
// Cursor cursor=db.rawQuery("select * from news_inf",null);
SQLiteDatabase db = new DBHelper(register.this).getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put("name",name);
cv.put("password",password);
db.insert("users", null,cv);
db.close();
// db.execSQL("Create table tb(_id integer"
// +"primary key autoincrement,"
// +"_name varchar(50),"
// +"_password varchar(50))");
// insertData(db,name,password);
}catch(SQLiteException se){
}
Toast.makeText(getApplicationContext(), "注册成功!",
Toast.LENGTH_SHORT).show();
}else{
Toast.makeText(getApplicationContext(), "两次密码不相同,请重新输入!",
Toast.LENGTH_SHORT).show();
}
}
};
private Button.OnClickListener btnReturnOnClickLis=new Button.OnClickListener(){
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
finish();
}
};
}
</span>
login.java
<span style="font-size:14px;">package com.example.login;
import android.app.Activity;
import android.app.ActionBar;
import android.app.Fragment;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.ViewGroup;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import android.os.Build;
public class login extends Activity {
private Button btn1;
private Button btn2;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.login);
setupViewComponent();
}
private void setupViewComponent() {
// TODO Auto-generated method stub
btn1=(Button)findViewById(R.id.btn_gotoregsiter);
btn2=(Button)findViewById(R.id.btn_login);
btn1.setOnClickListener(btn1OnClickLis);
btn2.setOnClickListener(btn2OnClickLis);
}
private Button.OnClickListener btn2OnClickLis = new Button.OnClickListener() {
@Override
public void onClick(View v) {
String name=((EditText)findViewById(R.id.edt_count)).getText().toString();
String password=((EditText)findViewById(R.id.edt_password)).getText().toString();
SQLiteDatabase db = new DBHelper(MainActivity.this).getReadableDatabase();
Cursor cursor=db.rawQuery("select * from users where name='"+name+"' and password='"+password+"';"
,null);
if (cursor.moveToFirst()) {
do {
if(name.equals(cursor.getString(1)) && password.equals(cursor.getString(2))){
Toast.makeText(getApplicationContext(), "登录成功!",
Toast.LENGTH_SHORT).show();
return;
}
} while(cursor.moveToNext());
}
Toast.makeText(getApplicationContext(), "登录失败!",
Toast.LENGTH_SHORT).show();
}
};
private Button.OnClickListener btn1OnClickLis=new Button.OnClickListener(){
@Override
public void onClick(View v) {
startActivity(new Intent(login.this,register.class));
}
};
}
</span>