安卓连接SQLite数据库（android登陆/注册 入门级示例）

利用Android Studio实现连接SQLite数据库实现登陆注册

package cn.csdn.service;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import cn.csdn.domain.User;

public class UserService {
	private DatabaseHelper dbHelper;
	public UserService(Context context){
		dbHelper=new DatabaseHelper(context);
	}
	
	//登录用
	public boolean login(String username,String password){
		SQLiteDatabase sdb=dbHelper.getReadableDatabase();
		String sql="select * from user where username=? and password=?";
		Cursor cursor=sdb.rawQuery(sql, new String[]{username,password});		
		if(cursor.moveToFirst()==true){
			cursor.close();
			return true;
		}
		return false;
	}
	//注册用
	public boolean register(User user){
		SQLiteDatabase sdb=dbHelper.getReadableDatabase();
		String sql="insert into user(username,password,age,sex) values(?,?,?,?)";
		Object obj[]={user.getUsername(),user.getPassword(),user.getAge(),user.getSex()};
		sdb.execSQL(sql, obj);	
		return true;
	}
}

资源下载

此资源下载价格为3D币（VIP免费），请先登录

资源文件列表

SQLiteLogin/.classpath , 364
SQLiteLogin/.idea/codeStyles/Project.xml , 1803
SQLiteLogin/.idea/encodings.xml , 138
SQLiteLogin/.idea/misc.xml , 1815
SQLiteLogin/.idea/modules.xml , 274
SQLiteLogin/.idea/SQLiteLogin.iml , 1266
SQLiteLogin/.idea/workspace.xml , 32430
SQLiteLogin/.project , 847
SQLiteLogin/AndroidManifest.xml , 1007
SQLiteLogin/bin/classes/cn/csdn/activity/LoginActivity$1.class , 1932
SQLiteLogin/bin/classes/cn/csdn/activity/LoginActivity$2.class , 998
SQLiteLogin/bin/classes/cn/csdn/activity/LoginActivity.class , 1330
SQLiteLogin/bin/classes/cn/csdn/activity/R$attr.class , 334
SQLiteLogin/bin/classes/cn/csdn/activity/R$drawable.class , 401
SQLiteLogin/bin/classes/cn/csdn/activity/R$id.class , 711
SQLiteLogin/bin/classes/cn/csdn/activity/R$layout.class , 420
SQLiteLogin/bin/classes/cn/csdn/activity/R$string.class , 421
SQLiteLogin/bin/classes/cn/csdn/activity/R.class , 517
SQLiteLogin/bin/classes/cn/csdn/activity/RegisterActivity$1.class , 2539
SQLiteLogin/bin/classes/cn/csdn/activity/RegisterActivity.class , 1380
SQLiteLogin/bin/classes/cn/csdn/domain/User.class , 1894
SQLiteLogin/bin/classes/cn/csdn/service/DatabaseHelper.class , 1386
SQLiteLogin/bin/classes/cn/csdn/service/UserService.class , 1869
SQLiteLogin/bin/classes/cn/csdn/test/UserTest.class , 1711
SQLiteLogin/bin/classes.dex , 9604
SQLiteLogin/bin/res/drawable-hdpi/ic_launcher.png , 3966
SQLiteLogin/bin/res/drawable-ldpi/ic_launcher.png , 1537
SQLiteLogin/bin/res/drawable-mdpi/ic_launcher.png , 2200
SQLiteLogin/bin/resources.ap_ , 12767
SQLiteLogin/bin/SQLiteLogin.apk , 19261
SQLiteLogin/gen/cn/csdn/activity/BuildConfig.java , 258
SQLiteLogin/gen/cn/csdn/activity/Manifest.java , 186
SQLiteLogin/gen/cn/csdn/activity/R.java , 1347
SQLiteLogin/proguard.cfg , 1248
SQLiteLogin/project.properties , 361
SQLiteLogin/res/drawable-hdpi/ic_launcher.png , 4147
SQLiteLogin/res/drawable-ldpi/ic_launcher.png , 1723
SQLiteLogin/res/drawable-mdpi/ic_launcher.png , 2574
SQLiteLogin/res/layout/main.xml , 2303
SQLiteLogin/res/layout/register.xml , 3476
SQLiteLogin/res/values/strings.xml , 188
SQLiteLogin/src/cn/csdn/activity/LoginActivity.java , 1685
SQLiteLogin/src/cn/csdn/activity/RegisterActivity.java , 1797
SQLiteLogin/src/cn/csdn/domain/User.java , 1216
SQLiteLogin/src/cn/csdn/service/DatabaseHelper.java , 749
SQLiteLogin/src/cn/csdn/service/UserService.java , 997
SQLiteLogin/src/cn/csdn/test/UserTest.java , 980
SQLiteLogin/教程说明见这里.txt , 66