public Livro getLivro(int id) { // 1. get reference to readable DB Livro livro = new Livro(); SQLiteMaterial dbMaterial = new SQLiteMaterial(con); SQLiteDatabase db = banco.getReadableDatabase(); // 2. build query Cursor cursor = db.query( TABLE_LIVRO, // a. table COLUMNS, // b. column names " id = ?", // c. selections new String[] {String.valueOf(id)}, // d. selections args null, // e. group by null, // f. having null, // g. order by null); // h. limit // 3. if we got results get the first one if (cursor != null) cursor.moveToFirst(); idLivro = cursor.getColumnIndex(KEY_ID); autor = cursor.getColumnIndex(KEY_AUTOR); cutter = cursor.getColumnIndex(KEY_CUTTER); isbn = cursor.getColumnIndex(KEY_ISBN); numeroTombo = cursor.getColumnIndex(KEY_NUMERO_TOMBO); idMaterial = cursor.getColumnIndex(sqlLiteMaterial.KEY_ID); ano = cursor.getColumnIndex(sqlLiteMaterial.KEY_ANO); classificacao = cursor.getColumnIndex(sqlLiteMaterial.KEY_CLASSIFICACAO); editora = cursor.getColumnIndex(sqlLiteMaterial.KEY_EDITORA); local = cursor.getColumnIndex(sqlLiteMaterial.KEY_LOCAL); referencia = cursor.getColumnIndex(sqlLiteMaterial.KEY_REFERENCIA); titulo = cursor.getColumnIndex(sqlLiteMaterial.KEY_TITULO); unitermo = cursor.getColumnIndex(sqlLiteMaterial.KEY_UNITERMO); volume = cursor.getColumnIndex(sqlLiteMaterial.KEY_VOLUME); // 4. tabela material livro = new Livro(); livro.setCodigoMaterial(Integer.parseInt(cursor.getString(idMaterial))); livro.setAno(cursor.getString(ano)); livro.setClassificacao(cursor.getString(classificacao)); livro.setEditora(cursor.getString(editora)); livro.setLocal(cursor.getString(local)); livro.setReferencia(cursor.getString(referencia)); livro.setTitulo(cursor.getString(titulo)); livro.setUnitermo(cursor.getString(unitermo)); livro.setVolume(cursor.getString(volume)); livro.setCodigoLivro(Integer.parseInt(cursor.getString(idLivro))); livro.setAutor(cursor.getString(autor)); livro.setCutter(cursor.getString(cutter)); livro.setIsbn(cursor.getString(isbn)); livro.setNumeroTombo(cursor.getString(numeroTombo)); Log.d("getLivro(" + id + ")", livro.toString()); return livro; }
@Override public List<Event> getAllEntries() { List<Event> events = new ArrayList<Event>(); String[] allColumnNames = dbHelper.getAllColumnNames(MySQLiteHelper.TABLE_EVENTS); if (database == null) database = dbHelper.getReadableDatabase(); Cursor cursor = database.query(MySQLiteHelper.TABLE_EVENTS, allColumnNames, null, null, null, null, null); cursor.moveToFirst(); while (!cursor.isAfterLast()) { Event event = cursorToEvent(cursor); events.add(event); cursor.moveToNext(); } // Make sure to close the cursor cursor.close(); return events; }
protected void onCreate(Bundle savedInstanceState) { requestWindowFeature(Window.FEATURE_NO_TITLE); super.onCreate(savedInstanceState); setContentView(R.layout.add_medicine); mySQLiteHelper = new MySQLiteHelper(add_medicine.this, "notepad.db", null, 1); db = mySQLiteHelper.getReadableDatabase(); text21m = (EditText) findViewById(R.id.text21m); latest_medicine = (TextView) findViewById(R.id.latest_medicine); latest_mdcount = (TextView) findViewById(R.id.latest_mdcount); latest_time = (TextView) findViewById(R.id.latest_truetime); input_count = (EditText) findViewById(R.id.input_count); medicine_name = (EditText) findViewById(R.id.medicine_name); TabHost tabHost; tabHost = getTabHost(); tabHost.addTab(tabHost.newTabSpec("tab1").setIndicator("录入").setContent(R.id.text1m)); tabHost.addTab(tabHost.newTabSpec("tab2").setIndicator("笔记").setContent(R.id.text2m)); tabHost.addTab(tabHost.newTabSpec("tab3").setIndicator("日志").setContent(R.id.text3m)); tabHost.setCurrentTab(0); // 用SharedPreference储存note SharedPreferences sp1 = getSharedPreferences("mdnote", MODE_PRIVATE); String notesString = sp1.getString("mdnote", ""); text21m.setText(notesString); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); if (cursor.moveToNext() != true) { latest_medicine.setText(""); latest_time.setText(""); latest_mdcount.setText(""); // cursor.close(); } else { cursor.moveToLast(); int mdindex = cursor.getColumnIndex("md"); String md = cursor.getString(mdindex); int mdcountindex = cursor.getColumnIndex("mdcount"); String mdcount = cursor.getString(mdcountindex); int timeindex = cursor.getColumnIndex("time"); String date = cursor.getString(timeindex); latest_medicine.setText(md); latest_time.setText(date); latest_mdcount.setText(mdcount); // cursor.close(); } tv = (TextView) findViewById(R.id.TextView001m); lv = (ListView) findViewById(R.id.ListView01m); // 数据库 // db=mySQLiteHelper.getReadableDatabase(); // cursor=db.query("medicinetable", new String[]{"_id","md","mdcount","time"}, null, null, null, // null, null); if (cursor.getCount() > 0) { tv.setVisibility(View.GONE); } SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] {R.id.TextView01m, R.id.TextView02m, R.id.TextView03m}); lv.setAdapter(sca); lv.setOnItemClickListener( new OnItemClickListener() { public void onItemClick(AdapterView<?> arg0, View arg1, int which, long arg3) { Builder builder = new Builder(add_medicine.this); builder.setSingleChoiceItems( new String[] {"查看", "修改", "删除"}, -1, new OnClickListener() { public void onClick(DialogInterface dialog, int which) { if (which == 0 && cursor.getCount() != 0) { int mdindex = cursor.getColumnIndex("md"); mdString = cursor.getString(mdindex); int ctindex = cursor.getColumnIndex("mdcount"); ctString = cursor.getString(ctindex); Toast.makeText( add_medicine.this, mdString + "|" + ctString + "片", Toast.LENGTH_SHORT) .show(); } else if (which == 2 && cursor.getCount() != 0) { int myidindex = cursor.getColumnIndex("_id"); myid = cursor.getInt(myidindex); Builder builder02 = new Builder(add_medicine.this); LayoutInflater inflater = LayoutInflater.from(add_medicine.this); View view = inflater.inflate(R.layout.deleteview, null); builder02.setView(view); builder02.setPositiveButton( "确定", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { db.delete("medicinetable", "_id=" + myid, null); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] { R.id.TextView01m, R.id.TextView02m, R.id.TextView03m }); lv.setAdapter(sca); } }); builder02.setNegativeButton( "取消", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); builder02.show(); } else if (which == 1 && cursor.getCount() != 0) { // 取得数据 int myidindex = cursor.getColumnIndex("_id"); myid = cursor.getInt(myidindex); Builder builder01 = new Builder(add_medicine.this); builder01.setTitle("编辑"); LayoutInflater inflater = LayoutInflater.from(add_medicine.this); View view = inflater.inflate(R.layout.md_updatedialogview, null); et01 = (EditText) view.findViewById(R.id.ed1m); et02 = (EditText) view.findViewById(R.id.ed2m); builder01.setView(view); builder01.setPositiveButton( "确定", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { String md = et01.getText().toString(); String ct = et02.getText().toString(); if (TextUtils.isEmpty(md) || TextUtils.isEmpty(ct)) { } else { ContentValues cv = new ContentValues(); cv.put("md", md); cv.put("mdcount", ct); db.update("medicinetable", cv, "_id=" + myid, null); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] { R.id.TextView01m, R.id.TextView02m, R.id.TextView03m }); lv.setAdapter(sca); } } }); builder01.setNegativeButton( "取消", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); builder01.show(); } } }); builder.show(); } }); }