一·布局代码 Login_activity.xml
<span style="font-size:14px;color:#990000;"><?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
android:background="@drawable/aa"
tools:context="com.example.hejingzhou.login__sql.LoginActivity">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:attr/textAppearanceLarge"
android:text="Password"
android:id="@+id/textView"
android:layout_centerVertical="true"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true" />
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textAppearance="?android:attr/textAppearanceLarge"
android:text="UserName"
android:id="@+id/textView2"
android:layout_alignParentTop="true"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_marginTop="144dp" />
<EditText
android:layout_width="200dp"
android:layout_height="wrap_content"
android:id="@+id/editTextusername"
android:layout_alignBottom="@+id/textView2"
android:layout_toRightOf="@+id/textView2"
android:layout_toEndOf="@+id/textView2" />
<EditText
android:layout_width="200dp"
android:layout_height="wrap_content"
android:id="@+id/editTextpassword"
android:layout_alignBottom="@+id/textView"
android:layout_toRightOf="@+id/textView"
android:layout_toEndOf="@+id/textView" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Login"
android:id="@+id/buttonlogin"
android:layout_below="@+id/editTextpassword"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:textAllCaps="false"
android:layout_marginTop="43dp" />
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Register"
android:textAllCaps="false"
android:id="@+id/buttonregister"
android:layout_alignTop="@+id/buttonlogin"
android:layout_alignParentRight="true"
android:layout_alignParentEnd="true" />
</RelativeLayout></span><span style="color:#ff0000;">
</span>
二 布局代码 Register_activity.xml
<span style="font-size:18px;color:#ff9900;"><?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:paddingBottom="@dimen/activity_vertical_margin"
android:paddingLeft="@dimen/activity_horizontal_margin"
android:paddingRight="@dimen/activity_horizontal_margin"
android:paddingTop="@dimen/activity_vertical_margin"
android:background="@drawable/bb"
tools:context="com.example.hejingzhou.login__sql.RegisterActivity">
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Username"
android:id="@+id/textView3"
android:layout_alignParentTop="true"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_marginTop="108dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Password"
android:id="@+id/textView4"
android:layout_below="@+id/textView3"
android:layout_alignParentLeft="true"
android:layout_alignParentStart="true"
android:layout_marginTop="34dp" />
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Age"
android:id="@+id/textView5"
android:layout_marginTop="29dp"
android:layout_below="@+id/textView4"
android:layout_alignRight="@+id/textView4"
android:layout_alignEnd="@+id/textView4" />
<EditText
android:layout_width="200dp"
android:layout_height="wrap_content"
android:id="@+id/editTextnewsuername"
android:layout_above="@+id/textView4"
android:layout_centerHorizontal="true" />
<EditText
android:layout_width="200dp"
android:layout_height="wrap_content"
android:id="@+id/editTextnewpassword"
android:layout_above="@+id/textView5"
android:layout_centerHorizontal="true" />
<EditText
android:layout_width="200dp"
android:layout_height="wrap_content"
android:id="@+id/editTextnewage"
android:layout_alignBottom="@+id/textView5"
android:layout_centerHorizontal="true" />
<RadioGroup
android:layout_width="match_parent"
android:layout_height="30dp"
android:layout_below="@+id/editTextnewage"
android:layout_alignLeft="@+id/editTextnewage"
android:layout_alignStart="@+id/editTextnewage"
android:orientation="horizontal"
android:layout_marginTop="48dp"
android:id="@+id/radioGroup">
<RadioButton
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:id="@+id/radioman"
android:text="Man"/>
<RadioButton
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:id="@+id/radiogirl"
android:text="Girl"/>
</RadioGroup>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="New Text"
android:id="@+id/Sex"
android:layout_alignTop="@+id/radioGroup"
android:layout_alignRight="@+id/textView3"
android:layout_alignEnd="@+id/textView3" />
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Register"
android:background="@android:color/transparent"
android:textAllCaps="false"
android:id="@+id/buttonregister_"
android:layout_below="@+id/radioGroup"
android:textColor="#6600cc"
android:layout_centerHorizontal="true"
android:layout_marginTop="52dp" />
<Button
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Back"
android:textColor="#cc00cc"
android:background="@android:color/transparent"
android:id="@+id/buttonback"
android:textAllCaps="false"
android:layout_below="@+id/buttonregister_"
android:layout_centerHorizontal="true" />
</RelativeLayout>
</span>
三 LoginActivity.java
<span style="font-size:14px;color:#000066;">package com.example.hejingzhou.login__sql;
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import java.math.RoundingMode;
import SerVice.UserService;
public class LoginActivity extends AppCompatActivity {
private EditText editTextUserName,editTextPassword;
private Button buttonLogin,buttonRegister;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_login);
editTextUserName = (EditText)findViewById(R.id.editTextusername);
editTextPassword = (EditText)findViewById(R.id.editTextpassword);
buttonLogin = (Button)findViewById(R.id.buttonlogin);
buttonRegister = (Button)findViewById(R.id.buttonregister);
buttonLogin.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String strusername = editTextUserName.getText().toString();
String strpassword = editTextPassword.getText().toString();
UserService userService = new UserService(LoginActivity.this);
boolean TAG = userService.login(strusername,strpassword);
System.out.println(TAG);
if(TAG)
{
Toast.makeText(LoginActivity.this,"登陆成功",Toast.LENGTH_LONG).show();
}
else
{
Toast.makeText(LoginActivity.this,"登陆失败",Toast.LENGTH_SHORT).show();
}
}
});
buttonRegister.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
startActivity(new Intent(LoginActivity.this,RegisterActivity.class));
}
});
}
}
</span>
四 Register.java
<span style="font-size:14px;color:#006600;">package com.example.hejingzhou.login__sql;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
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 SerVice.User;
import SerVice.UserService;
public class RegisterActivity extends AppCompatActivity {
private EditText editTextNewUserName,editTextNewPassword,editTextNewage;
private Button buttonBack,buttonregister;
private RadioGroup radioGroupsex;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_register);
editTextNewUserName = (EditText)findViewById(R.id.editTextnewsuername);
editTextNewPassword = (EditText)findViewById(R.id.editTextnewpassword);
editTextNewage = (EditText)findViewById(R.id.editTextnewage);
buttonBack = (Button)findViewById(R.id.buttonback);
buttonregister = (Button)findViewById(R.id.buttonregister_);
radioGroupsex = (RadioGroup)findViewById(R.id.radioGroup);
buttonBack.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
finish();
}
});
buttonregister.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String strnewusername = editTextNewUserName.getText().toString();
String strnewpassword = editTextNewPassword.getText().toString();
String strnewage = editTextNewage.getText().toString();
String strnewsex = ((RadioButton)RegisterActivity.this.findViewById(radioGroupsex.getCheckedRadioButtonId())).getText().toString();
UserService userService = new UserService(RegisterActivity.this);
User user = new User();
user.setUsername(strnewusername);
user.setPassword(strnewpassword);
user.setAge(Integer.parseInt(strnewage));
user.setSex(strnewsex);
userService.register(user);
Toast.makeText(RegisterActivity.this,"注册成功",Toast.LENGTH_SHORT).show();
}
});
}
}
</span>
五 DataBaseHelper.java
<span style="font-size:14px;color:#3333ff;">package SerVice;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Hejingzhou on 2015/11/26.
*/
public class DataBaseHelper extends SQLiteOpenHelper {
static String Name = "database.db";
static int Version = 1;
public DataBaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
public DataBaseHelper(Context context)
{
super(context,Name,null,Version);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "create table tablename(id integer primary key autoincrement," +
"username verchar(20),password verchar(20),age intger,sex verchar(2)) ";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
</span>
六 User.java
<span style="font-size:14px;color:#cc33cc;">package SerVice;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Hejingzhou on 2015/11/26.
*/
public class DataBaseHelper extends SQLiteOpenHelper {
static String Name = "database.db";
static int Version = 1;
public DataBaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
public DataBaseHelper(Context context)
{
super(context,Name,null,Version);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "create table tablename(id integer primary key autoincrement," +
"username verchar(20),password verchar(20),age intger,sex verchar(2)) ";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
</span>
七 UserSer.java
package SerVice;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;
import com.example.hejingzhou.login__sql.RegisterActivity;
/**
* Created by Hejingzhou on 2015/11/26.
*/
public class UserService {
private DataBaseHelper dataBaseHelper;
public UserService (Context context)
{
dataBaseHelper = new DataBaseHelper(context);
}
/**
* 登陆查询
* */
public boolean login(String username,String password)
{
SQLiteDatabase db = dataBaseHelper.getReadableDatabase();
String sql = "select * from tablename where username = ? and password = ?";
Cursor cursor = db.rawQuery(sql,new String[]{username,password});//创建一个新的游标
if(cursor.moveToFirst()==true)
{
cursor.close();
return true;
}else
{
return false;
}
}
/**
*注册
* */
public boolean register(User user)
{
SQLiteDatabase db = dataBaseHelper.getReadableDatabase();
String sql = "insert into tablename(username,password,age,sex) values(?,?,?,?)";
Object object[] = {user.getUsername(),user.getPassword(),user.getAge(),user.getSex()};
db.execSQL(sql,object);
return true;
}
}
八完成 效果