Kleine "Datenbank"

1package de.testdatabase.blabla;
2
3import java.io.BufferedReader;
4import java.io.IOException;
5import java.io.InputStream;
6import java.io.InputStreamReader;
7import java.util.StringTokenizer;
8
9import android.os.Bundle;
10import android.app.Activity;
11import android.content.ContentValues;
12import android.database.Cursor;
13import android.database.sqlite.SQLiteDatabase;
14import android.database.sqlite.SQLiteOpenHelper;
15import android.view.Menu;
16import android.widget.Toast;
17
18public class MainActivity extends Activity {
19
20 @Override
21 protected void onCreate(Bundle savedInstanceState) {
22 super.onCreate(savedInstanceState);
23 setContentView(R.layout.main);
24
25 SQLiteDatabase db;
26
27 db = openOrCreateDatabase("dbmaterial",
28 SQLiteDatabase.CREATE_IF_NECESSARY,
29 null);
30
31 onCreateDB(db);
32
33 InputStream in = getResources().openRawResource(R.raw.csvwerte);
34
35 if(in != null){
36
37 BufferedReader br = new BufferedReader(new InputStreamReader(in));
38 String line = null;
39
40 try {
41 while((line = br.readLine()) != null){
42 addItem(db,line);
43 }
44 } catch (IOException e) {
45 e.printStackTrace();
46 }
47
48 }
49
50
51 Cursor result=db.rawQuery("select distinct gruppe from dbmaterial", null);
52 String s="";
53 while(result.moveToNext ())
54 s+=result.getString(0)+"\n";
55 Toast.makeText(this, s, Toast.LENGTH_LONG).show();
56
57
58 Cursor result1=db.rawQuery("SELECT dincode FROM dbmaterial WHERE gruppe = 'STAHL'", null);
59 String s1="";
60 while(result1.moveToNext ())
61 s1+=result1.getString(0)+"\n";
62 Toast.makeText(this, s1, Toast.LENGTH_LONG).show();
63
64 Cursor result11=db.rawQuery("SELECT kcwert FROM dbmaterial WHERE dincode = 'ST37'", null);
65 String s11="";
66 while(result11.moveToNext ())
67 s11+=result11.getString(0)+"\n";
68 Toast.makeText(this, s11, Toast.LENGTH_LONG).show();
69
70 db.close();
71
72
73 }
74
75 @Override
76 public boolean onCreateOptionsMenu(Menu menu) {
77 // Inflate the menu; this adds items to the action bar if it is present.
78 getMenuInflater().inflate(R.menu.main, menu);
79 return true;
80 }
81
82 public void onCreateDB(SQLiteDatabase db) {
83 String sql = "create table dbmaterial( id integer primary key autoincrement," +
84 " gruppe varchar(20) not null," +
85 " dincode varchar(20) not null," +
86 " ansicode varchar(20) not null," +
87 " isocode varchar(20) not null," +
88 " kcwert varchar(5) not null," +
89 " mcwert varchar(5) not null)";
90 db.execSQL(sql);
91 }
92
93 public void addItem(SQLiteDatabase db, String string){
94
95 StringTokenizer st = new StringTokenizer(string,";");
96
97 String sql ="insert into dbmaterial(gruppe,dincode,ansicode,isocode,kcwert,mcwert) values (" +
98 "'"+st.nextToken().toString().trim()+"',"+
99 "'"+st.nextToken().toString().trim()+"',"+
100 "'"+st.nextToken().toString().trim()+"',"+
101 "'"+st.nextToken().toString().trim()+"',"+
102 "'"+st.nextToken().toString().trim()+"',"+
103 "'"+st.nextToken().toString().trim()+"')";
104 db.execSQL(sql);
105 }
106
107}

1setContentView(R.layout.showmateriallist);
2 adapter = new ArrayAdapter<String>(this,
3 android.R.layout.simple_list_item_1, listItems);
4 setListAdapter(adapter);
5
6 Log.v("MaterialList", "onCreate");
7
8 if (listItems.isEmpty()) {
9 listItems = db.getGroupLists();
10 synchronized (listItems) {
11 listItems.add("Alle Materialien anzeigen");
12
13 for(String i:listItems)
14 Log.v("listItems", i);
15
16 getMaterialFromGroup = true;
17 adapter.notifyDataSetChanged();
18
19 }
20 }

1@Override
2 public void onCreate(Bundle savedInstanceState) {
3 super.onCreate(savedInstanceState);
4
5 db = new MaterialDB(this);
6 db.open();
7
8 if (listItems.isEmpty()) {
9
10 listItems = db.getGroupLists();
11 listItems.add(getString(R.string.stringShowAllMaterial));
12 getMaterialFromGroup = true;
13
14
15 }
16
17 setContentView(R.layout.showmateriallist);
18 adapter = new ArrayAdapter<String>(this,
19 android.R.layout.simple_list_item_1, listItems);
20 setListAdapter(adapter);