public class MainActivity extends AppCompatActivity {
private SQLiteDatabase db;
private final String DATABASE_PATH = "/mnt/mmcblk1/mmcblk1p1/SQL";
private String DATABASE_FILENAME = "song.db";
private EditText eT;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;
eT = (EditText)findViewById(R.id.EDT);
// db = openOrCreateDatabase("song.db", Context.MODE_PRIVATE, null);
db = SQLiteDatabase.openOrCreateDatabase(databaseFilename, null);
new Thread(new Runnable() {
@Override
public void run() {
Cursor c = null;
c = db.rawQuery("SELECT * FROM song where SongName like "+ eT , null);
while (c.moveToNext()) {
String name = c.getString(c.getColumnIndex("SongName"));
Log.i("db", " SongName= " + name);
}
}
}).start();
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}
这是我写的代码 想在界面中输入一两个字对应查找数据库中的数据 我知道现在写的这个是不对的 要怎么写啊 求指点!!!!!!!!!