2023年7月7日发(作者：)

androidsql语句博客,通过SQL语句查询在中：encoding="utf-8"?>xmlns:android="/apk/res/android"android:id="@+id/mylayout"android:layout_width="fill_parent"android:layout_height="fill_parent"android:orientation="vertical"android:gravity="center_horizontal">android:id="@+id/findBut"android:layout_marginTop="8dp"android:background="#0066ff"android:textColor="#ffffff"android:layout_width="100dp"android:layout_height="40dp"android:text="查询全部数据" />在类中：package ;//数据库的辅助操作类import t;import Database;import OpenHelper;public class MyDatabaseHelper extends SQLiteOpenHelper {private static final String DATABASENAME ="" ;private static final int DATABASERVERSION = 1; // 设置数据库的版本private static final String TABLENAME ="mytab" ;public MyDatabaseHelper(Context context){ // ⽤户最关⼼的也肯定只是Contextsuper(context, DATABASENAME, null, DATABASERVERSION);}@Overridepublic void onCreate(SQLiteDatabase db) { //创建数据表String sql = "CREATE TABLE " + TABLENAME + "("+ "id INTEGER PRIMARY KEY ," // 在SQLite中设置为Integer、PRIMARYKEY则ID⾃动增长+ "name VARCHAR(50) NOT NULL,"+ "birthday DATE NOT NULL" +")";L(sql) ; // 执⾏n("****************** 创建：onCreate()。");}@Overridepublic void onUpgrade(SQLiteDatabase db, intoldVersion, int newVersion) {String sql = "DROP TABLE IF EXISTS " + TABLENAME ;L(sql) ;n("****************** 更新：onUpgrade()。");te(db) ;}}在类中：package ;import ist;import ;import ;import Database;public class MytabCursor {private static final String TABLENAME ="mytab" ;private SQLiteDatabase db = null ;public MytabCursor(SQLiteDatabase db) { = db ;}publicList find(){List all = newArrayList() ; //此时只是StringString sql = "SELECT id,name,birthday FROM " + TABLENAME ;Cursor result = ry(sql, null); // 执⾏查询语句for (First(); !rLast();Next()) { // 采⽤循环的⽅式检索数据("【" + (0) + "】" + " " +ing(1)+ "，" + ing(2));}() ;return all ;}}在中：package ;import ty;import OpenHelper;import ;import ;import kListener;import dapter;import ;import Layout;import ew;public class MySQLiteDemo extends Activity {private Button findBut = null;private SQLiteOpenHelper helper = null;private LinearLayout mylayout = null;@Overridepublic void onCreate(BundlesavedInstanceState) {te(savedInstanceState);tentView();t = (Button)ewById(t);ut =(LinearLayout)ewById(ut);lickListener(new OnClickListenerImpl());}private class OnClickListenerImpl implementsOnClickListener{public void onClick(View v) { = newMyDatabaseHelper();ListView listView = new ListView();pter( //设置数据newArrayAdapter //所有的数据是字符串(, //上下⽂_list_item_1, //列表显⽰的布局newMytabCursor( //实例化查询dableDatabase()) //取得SQLiteDatabase对象.find())); //调⽤find()⽅法，返回w(listView);}}}