Znn3bq.jpeg
±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 410  |  »Ø¸´: 0

cyq_wlgbj

Ìú³æ (³õÈëÎÄ̳)

[ÇóÖú] android studioÖÐʹÓÃsqliteÊý¾Ý¿âÎÊÌâ

´ó¼ÒÓÐûÓÐÓÃandroid studio¿ª·¢µÄ£¿ÎÒÓÃandroid studio¿ª·¢ÖÐʹÓÃsqliteÊý¾Ý¿â£¬ÔÚÄ£ÄâÆ÷ÉÏ´´½¨Êý¾Ý±íûÓÐÎÊÌ⣬µ«Êǰ²×°µ½ÊÖ»úÉÏÊý¾Ý±í´´½¨²»ÁË£¬ÎÒµÄÄ£ÄâÆ÷ÊÇandroid7.0£¬³ÌÐò°²×°µ½android7.0°æ±¾µÄÊÖ»úÉÏûÓÐÎÊÌ⣬°²×°µ½6.0°æ±¾µÄÊÖ»úÉϾͳöÎÊÌ⣬±í´´½¨²»³É¹¦£¬²»ÖªµÀΪʲô£¿ÄÄλ´óÉñÄܸø½â¾öÒ»ÏÂÂð£¿ÎÒµÄÊý¾Ý¿âʹÓÃÊÇÕâÑùµÄ
public class MyDatabaseHelper extends SQLiteOpenHelper {
    public  static final String CREATE_WheatLai="create table WheatLai(" +
            "id integer primary key autoincrement," +
            "Name string," +
            "Number string," +
            "GatherDate string," +
            "GatherTime string," +
            "LAI string)";
    private Context mContext;
    public MyDatabaseHelper(Context context,String name,SQLiteDatabase.CursorFactory factory,int version){
        super(context,name,factory,version);
        mContext=context;
        Log.d("MyDatabaseHelper","success"+name);
    }
    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        Log.d("Sqlitedatabase",sqLiteDatabase.toString());
        sqLiteDatabase.execSQL(CREATE_WheatLai);
        Log.d("create wheatlaitable","success";
        Toast.makeText(mContext,"create database succeeded",Toast.LENGTH_SHORT).show();

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) {

    }
}
ÒÔÏÂÊÇÔÚ³ÌÐòÖд´½¨ºÍʹÓÃÊý¾Ý¿â
//´´½¨Êý¾Ý¿â
    public MyDatabaseHelper dbHelper;
    public SQLiteDatabase db;
dbHelper=new MyDatabaseHelper(ImageProcess.this,"WheatLAI.db",null,3);//´´½¨Êý¾Ý¿â
db=dbHelper.getWritableDatabase();
ContentValues values=new ContentValues();
                        values.put("Name",Name);
                        values.put("Number",Number);
                        values.put("GatherDate", gatherDate);
                        values.put("GatherTime",gatherTime);
                        values.put("LAI",Result);
                        db.insert("WheatLai",null,values);//дÈëÊý¾Ý¿â
                        values.clear();
                       Log.d("insert into wheatlai","wheatlai";

ÎÒÓÃandroid6.0µÄÊÖ»ú·ÂÕæÊ±·¢ÏÖ£¬ÔÚdbHelper.getWritableDatabase();³ö´í£¬²¢Ã»ÓÐÔËÐÐMyDatabaseHelperÖеÄoncreate£¨£©·½·¨£¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
»Ø¸´´ËÂ¥
¼á³Ö¾ÍÊÇʤÀû
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ cyq_wlgbj µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 288Çóµ÷¼Á +12 ûÓдð°¸_ 2026-04-05 12/600 2026-04-08 00:17 by T¿É¿ÉÎ÷ÀïT
[¿¼ÑÐ] 285Çóµ÷¼Á +6 AZMK 2026-04-07 6/300 2026-04-07 20:13 by shanqishi
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©»¯¹¤085600 310·ÖÇóµ÷¼Á +20 0856²ÄÁÏÓ뻯¹¤3 2026-04-04 22/1100 2026-04-07 15:14 by Éϰ¶¿ì¿ì
[¿¼ÑÐ] ²ÄÁϹ¤³Ì302·ÖÇóµ÷¼Á +13 zyxÉϰ¶£¡ 2026-04-04 13/650 2026-04-07 11:14 by Ê«Óë×ÔÓÉ
[¿¼ÑÐ] Ò»Ö¾Ô¸ ½­ÄÏ´óѧ 085602 »¯¹¤×¨Ë¶ 338·ÖÇóµ÷¼Á +15 ·³ÕСç÷ 2026-04-05 15/750 2026-04-06 09:27 by cql1109
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +6 Ò»ÑùYWY 2026-04-05 6/300 2026-04-05 20:30 by ÄϺ½~ÍòÀÏʦ
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +13 Ò»ÑùYWY 2026-04-03 14/700 2026-04-05 18:20 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 313Çóµ÷¼Á +5 º£ÈÕº£ÈÕ 2026-04-04 7/350 2026-04-05 13:58 by imissbao
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£© +8 ÏàÐűػá¹ââÍòÕ 2026-04-05 10/500 2026-04-05 12:19 by Hdyxbekcb
[¿¼ÑÐ] 283Çóµ÷¼Á +4 mcbbc 2026-04-03 5/250 2026-04-04 20:51 by imissbao
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +12 Ò»ÑùYWY 2026-04-02 13/650 2026-04-04 20:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 298Çóµ÷¼Á +5 zzz£¬£¬r 2026-04-02 8/400 2026-04-04 19:55 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 272Çóµ÷¼Á +4 Ëɰس£Çà5 2026-04-03 4/200 2026-04-04 17:03 by babysonlkd
[¿¼ÑÐ] ±¾9Ò»Ö¾Ô¸2 0854µÍ·Öר˶286Çóµ÷¼Á +9 âÖÖ111 2026-04-04 9/450 2026-04-04 11:01 by tangruihua
[¿¼ÑÐ] Çóµ÷¼Á +4 ѹÁ¦??´ó 2026-04-03 4/200 2026-04-03 21:36 by à£à£à£0119
[¿¼ÑÐ] 315·Ö 085602 Çóµ÷¼Á +15 26¿¼ÑÐÉϰ¶°æ26 2026-04-02 15/750 2026-04-03 12:45 by xingguangj
[¿¼ÑÐ] 285Çóµ÷¼Á +7 AZMK 2026-04-02 9/450 2026-04-03 11:12 by wanwan00
[¿¼ÑÐ] Ò»Ö¾Ô¸ÉÂÎ÷ʦ·¶´óѧÉúÎïѧ317·Ö +5 1563ÈÕ¡£ 2026-04-02 5/250 2026-04-03 06:58 by ilovexiaobin
[¿¼ÑÐ] 302Çóµ÷¼Á +9 zyxÉϰ¶£¡ 2026-04-02 9/450 2026-04-02 23:07 by Âí¶ù¿ì¿ìµØÅÜ
[¿¼ÑÐ] 265Çóµ÷¼Á +11 yelck 2026-04-01 12/600 2026-04-01 19:12 by 549790059
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û