ä¸ãæ°å»ºå¤é¨SQLiteæ°æ®åº
ï¼1ï¼ä¸è½½å¹¶å®è£
SQLiteå¯è§å管çå·¥å
·(SQLite Expert Pro) v3.4.17 ç ´è§£ç
http://www.cr173.com/soft/36343.htmlï¼2ï¼å°ä½ æ头ä¸çæ°æ®æ¾å°EXCELè¡¨æ ¼ä¸ï¼ä¿å为CSVæ ¼å¼çæ°æ®
ï¼3ï¼å¨æ¤å·¥å
·ä¸æç
§ä½ ç°æçæ°æ®æ ¼å¼æ°å»ºæ°æ®åºå表ï¼å¦æ°æ®åºä¸ºï¼contact.dbï¼è¡¨ä¸ºemployee
ï¼4ï¼éè¿æ¤å·¥å
·èåæ ä¸Import/Exportä¸çImport text file(CSV,TSC)åè½ï¼å°ä½ ç°æçCSVæ°æ®å¯¼å
¥å°ä½ æ°å»ºçæ°æ®è¡¨ä¸ï¼ä¸»è¦ç®çæ¯ççä¸ä¸ªä¸ä¸ªçå½å
¥äºï¼
äºãå¨eclipseä¸æ°å»ºä¸ä¸ªandroid appå·¥ç¨ï¼å¹¶å¨æ°å»ºçå·¥ç¨æ件夹ç¹å³é®new->folderï¼å¨resæ件夹ä¸æ°å»ºrawæ件夹(å¦ææå°±ä¸ç¨æ°å»ºäº)
ä¸ãç¨é¼ æ å°æ°å»ºçSQLiteæ°æ®åºæ件contact.dbæå¨å°æ°å»ºå·¥ç¨çresä¸çrawæ件ä¸ï¼åºç°æ示ï¼éæ©copy
åãç¨åºä»£ç
private static final String DATABASE_PATH = "/data/data/ä½ ç主ç¨åºå
è·¯å¾ï¼å¦ï¼com.szair.contact)/databases";
private static final int DATABASE_VERSION = 0;
private static final String DATABASE_NAME = "contact.db";
private static String outFileName = DATABASE_PATH + "/" + DATABASE_NAME;
try {
buildDatabase();//è§ä¸
} catch (Exception e) {
e.printStackTrace();
}
//SQLiteDatabase对象
SQLiteDatabase db=SQLiteDatabase.openDatabase(outFileName, null,SQLiteDatabase.NO_LOCALIZED_COLLATORS);
String t="SELECT å段å1,å段å2 FROM employee WHERE **** ORDER BY ***";
Cursor c =db.rawQuery(t, null);
if(c.moveToFirst()){
for(int i=0;i
{
String ziduan1=c.getString(0);//å段1çæ°æ®
String ziduan2=c.getString(1);//å段1çæ°æ®
}
}
------------------------------------------------
//åé¢ç¨å°çbuildDatabaseæ¹æ³
private void buildDatabase() throws Exception{
InputStream myInput = getResources().openRawResource(R.raw.sz_contact);
File file = new File(outFileName);
File dir = new File(DATABASE_PATH);
if (!dir.exists()) {
if (!dir.mkdir()) {
throw new Exception("å建失败");
}
}
if (!file.exists()) {
try {
OutputStream myOutput = new FileOutputStream(outFileName);
byte[] buffer = new byte[1024];
int length;
while ((length = myInput.read(buffer))>0){
myOutput.write(buffer, 0, length);
}
myOutput.close();
myInput.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
äºãç¨åºåå¸
æç
§ä»¥ä¸æ¹å¼ï¼å¯ä»¥å°å¤é¨å»ºçSQLiteæ°æ®åºæåçåå¸åºæ¥