android 提示这个错误 Caused by:android.database.sqlite.SQLiteException:no such column:xuehao:这句话产生的 \x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);这个所有代码 public class Shu
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 22:27:14
![android 提示这个错误 Caused by:android.database.sqlite.SQLiteException:no such column:xuehao:这句话产生的 \x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);这个所有代码 public class Shu](/uploads/image/z/14630375-47-5.jpg?t=android+%E6%8F%90%E7%A4%BA%E8%BF%99%E4%B8%AA%E9%94%99%E8%AF%AF+Caused+by%3Aandroid.database.sqlite.SQLiteException%3Ano+such+column%3Axuehao%3A%E8%BF%99%E5%8F%A5%E8%AF%9D%E4%BA%A7%E7%94%9F%E7%9A%84+%5Cx05Cursor+cur%3Ddatabase.query%28tablename%2Cnew+String%5B%5D%7BXUEHAO%2Cxingming%7D%2Cnull%2Cnull%2Cnull%2Cnull%2Cnull%29%3B%E8%BF%99%E4%B8%AA%E6%89%80%E6%9C%89%E4%BB%A3%E7%A0%81+public+class+Shu)
android 提示这个错误 Caused by:android.database.sqlite.SQLiteException:no such column:xuehao:这句话产生的 \x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);这个所有代码 public class Shu
android 提示这个错误 Caused by:android.database.sqlite.SQLiteException:no such column:xuehao:
这句话产生的 \x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);
这个所有代码 public class Shu extends Activity {
\x05private static int miCount = 0;
\x05private ListView list;
\x05private SQLiteDatabase database;
\x05private static String databasename="xuesheng.db";
\x05private static String tablename="table1";
\x05private static String XUEHAO="xuehao";
\x05private static String xingming="xingming";
\x05private static String createtable="CREATE TABLE "+tablename+"("+XUEHAO+" INTEGER PRIMARY KEY,"+xingming+"TEXT)";
private Button add;
/** Called when the activity is first created.*/
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
list=(ListView)findViewById(R.id.listView1);
add=(Button)findViewById(R.id.button1);
database=this.openOrCreateDatabase(databasename,MODE_PRIVATE,null);
try
{
/* 在数据库mSQLiteDatabase中创建一个表 */
\x05database.execSQL(createtable);
}
catch (Exception e)
{
\x05 audata();
}
add.setOnClickListener(new View.OnClickListener() {
\x05\x05
\x05\x05@Override
\x05\x05public void onClick(View v) {
\x05\x05\x05// TODO Auto-generated method stub
\x05\x05\x05 AddData();
\x05\x05}
\x05}) ;
}
public void AddData()
{
ContentValues cv = new ContentValues();
cv.put(XUEHAO,"111");
cv.put(xingming,"sdaf");
/* 插入数据 */
database.insert(tablename,null,cv);
miCount++;
audata();
}
private void audata(){
\x05
\x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);
\x05
\x05 miCount = cur.getCount();
if (cur = null && cur.getCount() >= 0)
{
\x05ListAdapter adapter=new SimpleCursorAdapter(this,
\x05\x05\x05android.R.layout.simple_list_item_2,
\x05\x05\x05cur,
\x05\x05\x05new String[]{XUEHAO,xingming},
\x05\x05\x05new int[]{android.R.id.text1,android.R.id.text2});
\x05
\x05list.setAdapter(adapter);
}
}}
android 提示这个错误 Caused by:android.database.sqlite.SQLiteException:no such column:xuehao:这句话产生的 \x05Cursor cur=database.query(tablename,new String[]{XUEHAO,xingming},null,null,null,null,null);这个所有代码 public class Shu
Caused by:android.database.sqlite.SQLiteException:no such column:Li:SQL代码没写对,用字符串查询的时候要加单引号如 name=’Li‘,注意单引号