Program: przenoszący zawartość pliku bazodanowego do zwykłego txt.
Kod programu:
Baza do pliku – backend:
package com.example.txt_z_bd;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import android.os.Bundle;
import android.os.Environment;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity {
public boolean databaseExist()
{
File dbFile = new File(Environment.getExternalStorageDirectory().getPath()+"/"+"ParkHotel.db");
return dbFile.exists();
}
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
final File file=new File(Environment.getExternalStorageDirectory().getPath()+"/"+"dane.txt");
Button bID=(Button)findViewById(R.id.buttonID);
bID.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
databaseExist();
SQLiteDatabase baza=openOrCreateDatabase(Environment.getExternalStorageDirectory().getPath()
+"/"+"ParkHotel.db", SQLiteDatabase.OPEN_READWRITE, null);
String kolumny[]={"kod_kreskowy","nazwa"};
Cursor kursor=baza.query("Towary", kolumny, null, null, null, null, null);
kursor.moveToFirst();
for(int i=1;i<kursor.getCount();i++)
{
String kod=kursor.getString(0);
String nazwa=kursor.getString(1);
FileOutputStream fos=null;
try {
fos=new FileOutputStream(file,true);
fos.write((kod+", "+nazwa+";\n").getBytes());
fos.close();
} catch (FileNotFoundException e1) {
e1.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
kursor.moveToNext();
}
baza.close();
kursor.close();
}
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
} Layout:
<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"
tools:context=".MainActivity" >
<Button
android:id="@+id/buttonID"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentTop="true"
android:layout_centerHorizontal="true"
android:layout_marginTop="71dp"
android:text="@string/przenies" />
</RelativeLayout> Bazy danych Eclipse Java Operacje na plikach Technologie mobilne