006_02SQLite_OpenHelper

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了006_02SQLite_OpenHelper，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3207字，纯文字阅读大概需要5分钟。

内容图文

package com.example.sqliteopenhelper; 2 3 import android.content.Context; 4 import android.database.sqlite.SQLiteDatabase; 5 import android.database.sqlite.SQLiteDatabase.CursorFactory; 6 import android.database.sqlite.SQLiteOpenHelper; 7 import android.util.Log; 8 9 public class MydbOpenHelper extends SQLiteOpenHelper{ 10 11 public MydbOpenHelper(Context context, String name, CursorFactory factory, int version){ 12 super(context, name, factory, version); 13 } 14 15 @Override 16 public void onCreate(SQLiteDatabase db) { 17 String createtable = "create table user(id int, name varchar(20), password char(8))"; 18 db.execSQL(createtable); 19 System.out.println("MydbOpenHelper.onCreate()"); 20 21 } 22 23 @Override 24 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 25 Log.i("MydbOpenHelper","oldVersion" + oldVersion + "newVersion" + newVersion); 26 System.out.println("MydbOpenHelper.onUpgrade()"); 27 28 } 29 } MydbOpenHelper

 

 1 package com.example.sqliteopenhelper;
 2 
 3 import android.app.Activity;
 4 import android.content.ContentValues;
 5 import android.database.Cursor;
 6 import android.database.sqlite.SQLiteDatabase;
 7 import android.os.Bundle;
 8 import android.util.Log;
 9 import android.view.Menu;
10 import android.view.MenuItem;
11 import android.view.View;
12 
13 public class MainActivity extends Activity {
14     SQLiteDatabase db = null;
15     
16     @Override
17     protected void onCreate(Bundle savedInstanceState) {
18         super.onCreate(savedInstanceState);
19         setContentView(R.layout.activity_main);
20         
21         MydbOpenHelper dbhelper = new MydbOpenHelper(this, "userinfo.db", null, 1);
22         db = dbhelper.getWritableDatabase();
23 
24     }
25     
26     public void insert(View v){
27         ContentValues c = new ContentValues();
28         //c.put("id", 2);
29         //c.put("name", "user222");
30         //c.put("password", "222");
31         
32         c.put("id", 1);
33         c.put("name", "user1");
34         c.put("password", "222");
35         
36         db.insert("user", null, c);
37     }
38     public void delete(View v){
39         db.delete("user", "id=? and name=?", new String[]{"1","user1"});
40     }
41     public void update(View v){
42         ContentValues c = new ContentValues();
43         c.put("name", "user222");
44         c.put("password", "88888888");
45         db.update("user", c, "id=?", new String[]{"2"});
46     }
47     public void query(View v){
48         String[] colums = {"id", "name", "password"};
49         Cursor c = db.query("user", colums, null, null, null, null, null);
50         
51         while(c.moveToNext()){
52             int id = c.getInt(c.getColumnIndex("id"));
53             String username = c.getString(c.getColumnIndex("name"));
54             String password = c.getString(c.getColumnIndex("password"));
55             Log.i("sqliteopenhelper", id + "," +username+"," +password);
56         }
57     }
58 }

MainActivity.java

 

006_02SQLite_OpenHelper

标签：

本文系统来源：http://www.cnblogs.com/woodrow2015/p/4515829.html

内容总结

以上是互联网集市为您收集整理的006_02SQLite_OpenHelper全部内容，希望文章能够帮你解决006_02SQLite_OpenHelper所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---