android Sql Login
来源:互联网 发布:c语言 生成时间戳 编辑:程序博客网 时间:2024/06/15 02:15
一·布局代码 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; }}
八完成 效果
0 0
- android Sql Login
- login.sql
- login.sql
- android login
- Oracle login.sql
- oracle login.sql
- sqlplus初始化login.sql
- glogin.sql 和 login.sql
- glogin.sql和login.sql
- android---login---passwd
- 定义自己的login.sql
- sqlplus环境配置(login.sql)
- sqlplus环境配置(login.sql)
- SQL *Plus设置login.sql登录设置
- oracle glogin.sql 和login.sql
- oracle glogin.sql和login.sql
- sqlplus之glogin.sql and login.sql
- oracle glogin.sql 和login.sql使用
- FigurePanel 类应用举例
- 安卓开发-Activity中finish() onDestroy() 和System.exit()的区别
- haproxy.conf示例
- 阅读《代码大全》后的读书笔记(第三部分)(未完待续......)
- dubbo
- android Sql Login
- Android中Activity启动模式详解
- Druid
- Centos配置国内yum源
- 高性能MySql进化论(四):Summary,Cache,Counter表的使用
- Jenkins简单使用介绍
- solr
- jquery ajax
- natas16 题解