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();
}
});
}
