java sqlite管理系统_基于SQLite的简单学生信息管理系统

package com.wyf.dao;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Date;

import java.util.GregorianCalendar;

import java.util.HashMap;

import java.util.List;

import java.util.Locale;

import java.util.Map;

import android.view.View;

import com.wyf.Bean.Records;

import com.wyf.login.R;

import android.app.Activity;

import android.content.ContentValues;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.util.Log;

import android.content.Context;

import android.database.sqlite.SQLiteOpenHelper;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

public class RecordsDao {

private static final String TAG ="DAO_TAG";

private DataBaseHelper mdbhelper;

private static RecordsDao mrecordsDao;

private static Activity activity;

private SQLiteDatabase db;

SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

//支持多线程的单例模式

public RecordsDao(Activity activity){

mdbhelper = new DataBaseHelper(activity);

}

public static RecordsDao getInstance(Activity a){

if(null == mrecordsDao){

synchronized(RecordsDao.class){

if(null == mrecordsDao){

mrecordsDao = new RecordsDao(a);

}

}

}

activity = a;

return mrecordsDao;

}

//验证用户登录

public Integer checkLogin(String username,String password){

Integer result=0;

String sql = "select * from "+ DataBaseHelper.TABLE_NAME +" where NAME='"+username+"' and PASS='"+password+"'";

try{

db = mdbhelper.getWritableDatabase();

Cursor cursor = db.rawQuery(sql, null);

result=cursor.getCount();

return result;

}catch(Exception e) {

e.printStackTrace();

return 0;

}finally{

db.close();

mdbhelper.close();

}

}

public void execSQL(String sql){

try{

db = mdbhelper.getWritableDatabase();

db.execSQL(sql);

}catch(Exception e) {

}finally{

db.close();

mdbhelper.close();

}

}

//

public void closeclose() {

mdbhelper.close();

}

//删除记录

public void delRecord(Integer idstr){

String sql = "delete from "+ DataBaseHelper.TABLE_NAME +" where _id in ("+idstr +")";

try{

db = mdbhelper.getWritableDatabase();

db.execSQL(sql);

}catch(Exception e) {

}finally{

db.close();

mdbhelper.close();

}

}

/**

* 查询

*/

public Cursor select(String username){

Cursor cursor = null;

try{

db = mdbhelper.getWritableDatabase();

String sql = "SELECT * FROM "+DataBaseHelper.TABLE_NAME+" where NAME='"+username+"'";

cursor = db.rawQuery(sql, null);

return cursor;

}catch(Exception ex){

ex.printStackTrace();

return null;

}

}

//插入记录

public long InsertRecord(Records r){

long rows = 0;

db = mdbhelper.getWritableDatabase();

Calendar c =Calendar.getInstance(Locale.CHINA);

ContentValues cv=new ContentValues();

cv.put(DataBaseHelper.COLUMN_NAME, r.getName());

cv.put(DataBaseHelper.COLUMN_PASS,r.getPass());

cv.put(DataBaseHelper.COLUMN_AGE,r.getAge());

cv.put(DataBaseHelper.COLUMN_CLASSNAME,r.getClassname());

cv.put(DataBaseHelper.COLUMN_TEL,r.getTel());

cv.put(DataBaseHelper.COLUMN_EMAIL,r.getEmail());

cv.put(DataBaseHelper.COLUMN_DATETIME,r.getDatetime());

try{

rows = db.insert(DataBaseHelper.TABLE_NAME, null, cv);

}catch(Exception e){

Log.e(TAG, e.getMessage());

}

db.close();

mdbhelper.close();

return rows;

}

//修改记录

public long UpdateRecord(Records r,Integer id){

long rows = 0;

db = mdbhelper.getWritableDatabase();

ContentValues cv=new ContentValues();

cv.put(DataBaseHelper.COLUMN_NAME, r.getName());

cv.put(DataBaseHelper.COLUMN_PASS,r.getPass());

cv.put(DataBaseHelper.COLUMN_AGE,r.getAge());

cv.put(DataBaseHelper.COLUMN_CLASSNAME,r.getClassname());

cv.put(DataBaseHelper.COLUMN_TEL,r.getTel());

cv.put(DataBaseHelper.COLUMN_EMAIL,r.getEmail());

cv.put(DataBaseHelper.COLUMN_DATETIME,r.getDatetime());

try{

rows =db.update(DataBaseHelper.TABLE_NAME, cv, "_id = "+id, null);

}catch(Exception e){

Log.e(TAG, e.getMessage());

}

db.close();

mdbhelper.close();

return rows;

}

//查询结果

public static final String[] PROJECTION ={

DataBaseHelper.COLUMN_ID,

DataBaseHelper.COLUMN_NAME,

DataBaseHelper.COLUMN_PASS,

DataBaseHelper.COLUMN_AGE,

DataBaseHelper.COLUMN_CLASSNAME,

DataBaseHelper.COLUMN_TEL,

DataBaseHelper.COLUMN_EMAIL,

};

//查询数据

public Cursor select_student()

{

db=mdbhelper.getReadableDatabase();

Cursor cursor=db.query(DataBaseHelper.TABLE_NAME, null, null, null, null, null," _id desc");

return cursor;

}

//查询匹配ID数据

public Cursor select_info(String id){

Cursor cursor = null;

try{

db = mdbhelper.getWritableDatabase();

String sql = "SELECT * FROM "+DataBaseHelper.TABLE_NAME+" where _id='"+id+"'";

cursor = db.rawQuery(sql, null);

return cursor;

}catch(Exception ex){

ex.printStackTrace();

return null;

}

}

}



更多源码 | 好库简介 | 网站地图 | 帮助中心 | 版权说明

Copyright© 2009-2012 OKBASE.NET All Rights Reserved 好库网 版权所有