Hallo Leute,
hier ist das Ergebnis. Weiß nicht ob der Code hierhin gehört. Aber wofür gibts die Admin's
However es ist nicht quick aber dirty programmiert und es beinhaltet alles was man braucht um eine externe Datei zu lesen (csvwerte.csv) und es zeigt wie man eine Datenbank anlegen kann und dort Daten hinzufügt und wie man diese abfragt. Vielleicht hilft es ja jemanden.
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}
Gruß und Danke an alle Unterstützer und TuTWriter's