android Sql Login
16lz
2021-12-04
一·布局代码 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; }}
源代码http:/ download.csdn.netdownloadcsdnhejingzhou9303185
八完成 效果
更多相关文章
- Android(安卓)全屏
- 提示Android(安卓)dependency 'com.android.support:appcompat-v
- android百度地图标记点代码
- build WebRTC for android
- Android使用代码模拟HOME键的功能
- Android(安卓)Gradle使用详解
- android九宫格实现
- Android高手进阶教程(三)之----Android(安卓)中自定义View的应用
- scrollview--android