android Sql Login
16lz
2021-01-23
一·布局代码 Login_activity.xml
<?xml version="1.0" encoding="utf-8"?>
二 布局代码 Register_activity.xml
<?xml version="1.0" encoding="utf-8"?>
三 LoginActivity.java
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)); } }); }}
四 Register.java
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(); } }); }}
五 DataBaseHelper.java
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) { }}
六 User.java
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) { }}
七 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 Imageview 图片居左居右,自定义圆角
- Android学习知识点之相对布局
- Android TableLayout表格布局
- android 加载图片到gallery
- 布局 遗忘 整理
- Android 的一些比较好的开源代码项目
- 安卓相对布局