附录A 部分代码.docx
- 文档编号:143296
- 上传时间:2023-04-28
- 格式:DOCX
- 页数:9
- 大小:14.75KB
附录A 部分代码.docx
《附录A 部分代码.docx》由会员分享,可在线阅读,更多相关《附录A 部分代码.docx(9页珍藏版)》请在冰点文库上搜索。
附录A部分代码packagecom.dao;
importjava.util.ArrayList;
importjava.util.List;
importandroid.content.ContentValues;
importandroid.content.Context;
importandroid.database.Cursor;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.database.sqlite.SQLiteDatabase.CursorFactory;
importandroid.database.sqlite.SQLiteOpenHelper;
publicclassContactDaoextendsSQLiteOpenHelper{
privateSQLiteDatabasedb;
publicContactDao(Contextcontext,Stringname,CursorFactoryfactory,intversion){
super(context,name,factory,version);
}
@Override
publicvoidonCreate(SQLiteDatabasedb){
Stringsql="createtablet_contact(c_idintegerprimarykey
autoincrement,g_name,c_name,c_birthday,c_phone,c_e_mail,c_address)";
db.execSQL(sql);
}
@Override
publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
}
publicList
List
db=getReadableDatabase();
Cursorc=db.query("t_contact",newString[]{"c_id","g_name","c_name"},null,null,null,null,
null);
//cursor是什么意思有何作用
while(c.moveToNext()){
Strings=c.getString(c.getColumnIndex("g_name"));
inti=s.length();
if(i>=5){
s=s.substring(0,2)+"......";华图毕业设计网提供QQ:
8694378222}
Stringstr=c.getString(c.getColumnIndex("c_id"))+"."+s+"姓名
"+c.getString(c.getColumnIndex("c_name"));
list.add(str);
}
db.close();
returnlist;
}
publicintdeleteContact(Stringid){
db=getWritableDatabase();
inti=db.delete("t_contact","c_id=?
",newString[]{id});
db.close();
returni;
}
publicList
List
db=getReadableDatabase();
Cursorc=null;
switch(i){
case1:
c=db.query("t_contact",newString[]{"c_id","g_name","c_name"},"c_name=?
",new
String[]{name},null,null,null);
break;//string数组何用
case2:
c=db.query("t_contact",newString[]{"c_id","g_name","c_name"},"g_name=?
",new
String[]{name},null,null,null);
break;
}
while(c.moveToNext()){
Strings=c.getString(c.getColumnIndex("g_name"));
intii=s.length();
if(ii>=5){
s=s.substring(0,2)+"......";
}
Stringstr=c.getString(c.getColumnIndex("c_id"))+"."+s+"姓名
"+c.getString(c.getColumnIndex("c_name"));
list.add(str);
}
c.close();
db.close();华图毕业设计网提供QQ:
8694378223returnlist;
}
publiclongaddContact(Stringg_name,Stringc_name,Stringc_birthday,Stringc_phone,String
c_e_mail,Stringc_address){
db=getWritableDatabase();
ContentValuesvalues=newContentValues();
values.put("g_name",g_name);
values.put("c_name",c_name);
values.put("c_birthday",c_birthday);
values.put("c_phone",c_phone);
values.put("c_e_mail",c_e_mail);
values.put("c_address",c_address);
longl=db.insert("t_contact",null,values);
db.close();
returnl;
}
publicString[]getContact(Stringc_id){
String[]str=newString[6];
db=getReadableDatabase();
Cursorcursor=db.query("t_contact",new
String[]{"g_name","c_name","c_birthday","c_phone","c_e_mail","c_address"},"c_id=?
",newString[]{c_id},
null,null,null);
if(cursor.moveToNext()){
str[0]=cursor.getString(cursor.getColumnIndex("g_name"));
str[1]=cursor.getString(cursor.getColumnIndex("c_name"));
str[2]=cursor.getString(cursor.getColumnIndex("c_birthday"));
str[3]=cursor.getString(cursor.getColumnIndex("c_phone"));
str[4]=cursor.getString(cursor.getColumnIndex("c_e_mail"));
str[5]=cursor.getString(cursor.getColumnIndex("c_address"));
}
db.close();
returnstr;
}
publicintupdateContact(Stringc_id,Stringg_name,Stringc_name,Stringc_birthday,String
c_phone,Stringc_e_mail,Stringc_address){
db=getWritableDatabase();
ContentValuesvalues=newContentValues();
values.put("g_name",g_name);
values.put("c_name",c_name);
values.put("c_birthday",c_birthday);
values.put("c_phone",c_phone);
values.put("c_e_mail",c_e_mail);华图毕业设计网提供QQ:
8694378224values.put("c_address",c_address);
inti=db.update("t_contact",values,"c_id=?
",newString[]{c_id});
db.close();
returni;
}
}packagecom.dao;
importjava.util.ArrayList;
importjava.util.HashMap;
importjava.util.List;
importjava.util.Map;
importandroid.content.Context;
importandroid.database.Cursor;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.database.sqlite.SQLiteDatabase.CursorFactory;
importandroid.database.sqlite.SQLiteOpenHelper;
publicclassCreateNoteextendsSQLiteOpenHelper{
privateSQLiteDatabasedb;
publicCreateNote(Contextcontext,Stringname){
super(context,name,null,1);
//TODOAuto-generatedconstructorstub
}
@Override
publicvoidonCreate(SQLiteDatabasedb){
Stringsql="createtablet_note("
+"idintegerprimarykeyautoincrement,"+"title,timedate,type,content)";
db.execSQL(sql);
}
publicList
Cursorcur;
Stringsql="";
db=this.getReadableDatabase();
if(!
"".equals(title)){
sql="select*fromt_notewheretitle=?
";
String[]obj={title};
cur=db.rawQuery(sql,obj);华图毕业设计网提供QQ:
8694378225}
else{
sql="select*fromt_note";
cur=db.rawQuery(sql,null);
}
List
Map
while(cur.moveToNext()){
map=newHashMap
map.put("id",cur.getString(cur.getColumnIndex("id")));
map.put("title",cur.getString(cur.getColumnIndex("title")));
map.put("time",cur.getString(cur.getColumnIndex("time")));
map.put("type",cur.getString(cur.getColumnIndex("type")));
map.put("content",cur.getString(cur.getColumnIndex("content")));
list.add(map);
}
cur.close();
db.close();
returnlist;
}
publicvoidinsert(Stringtitle,Stringtime,Stringtype,Stringcontent){
db=this.getWritableDatabase();
Stringsql="insertintot_note(id,title,time,type,content)values(null,?
?
?
?
)";
Object[]obj={title,time,type,content};
db.execSQL(sql,obj);
db.close();
}
publicvoidupdate(Stringid,Stringtitle,Stringtime,Stringtype,Stringcontent){
db=this.getWritableDatabase();
Stringsql="updatet_notesettitle=?
time=?
type=?
content=?
whereid=?
";
Object[]obj={title,time,type,content,id};
db.execSQL(sql,obj);
db.close();
}
publicvoiddel(Stringid){
db=this.getWritableDatabase();
Stringsql="deletefromt_notewhereid=?
";
Object[]obj={id};
db.execSQL(sql,obj);
db.close();
}华图毕业设计网提供QQ:
8694378226publicList
Cursorcur;
Stringsql="";
db=this.getReadableDatabase();
sql="select*fromt_note";
cur=db.rawQuery(sql,null);
List
Map
while(cur.moveToNext()){
map=newHashMap
map.put("id",cur.getString(cur.getColumnIndex("id")));
map.put("title",cur.getString(cur.getColumnIndex("title")));
map.put("time",cur.getString(cur.getColumnIndex("time")));
map.put("type",cur.getString(cur.getColumnIndex("type")));
map.put("content",cur.getString(cur.getColumnIndex("content")));
list.add(map);
}
cur.close();
//db.close();
returnlist;
}
@Override
publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
//TODOAuto-generatedmethodstub
}
}packagecom.dao;
importjava.util.ArrayList;
importjava.util.List;
importandroid.content.ContentValues;
importandroid.content.Context;
importandroid.database.Cursor;
importandroid.database.sqlite.SQLiteDatabase;
importandroid.database.sqlite.SQLiteDatabase.CursorFactory;
importandroid.database.sqlite.SQLiteOpenHelper;
publicclassGroupDaoextendsSQLiteOpenHelper{
privateSQLiteDatabasedb;
华图毕业设计网提供QQ:
8694378227publicGroupDao(Contextcontext,Stringname,CursorFactoryfactory,intversion){
super(context,name,factory,version);
}
@Override
publicvoidonCreate(SQLiteDatabasedb){
Stringsql="createtablet_group(g_idintegerprimarykeyautoincrement,g_name,g_description)";
db.execSQL(sql);
sql="createtablet_contact(c_idintegerprimarykey
autoincrement,g_name,c_name,c_birthday,c_phone,c_e_mail,c_address)";
db.execSQL(sql);
sql="createtablet_notetype(idintegerprimarykeyautoincrement,name,description)";
db.execSQL(sql);
sql="createtablet_note(idintegerprimarykeyautoincrement,title,timedate,type,content)";
db.execSQL(sql);
sql="createtablet_date(idintegerprimarykeyautoincrement,name,prname,explains,remaintime)";
db.execSQL(sql);
sql="createtableprogramme(idintegerprimarykeyautoincrement,prname,prexplains)";
db.execSQL(sql);
}
@Override
publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
}
publicintdeleteGroup(Stringid){
db=getWritableDatabase();
Stringstr=null;
Cursorc=db.query("t_group",newString[]{"g_name"},"g_id=?
",newString[]{id},null,null,
null);
if(c.moveToNext()){
str=c.getString(c.getColumnIndex("g_name"));
}
Content
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 附录A 部分代码 附录 部分 代码
![提示](https://static.bingdoc.com/images/bang_tan.gif)