Android SQLite简单操作示例

短命女 2022-03-29 08:50 243阅读 0赞

### 环境 ###

Eclipse Indigo + Android 2.2 + SQLite 2.6.22

### 问题 ###

Android SQLite数据库简单示例

### 解决 ###

SqLiteActivity.java

package com.cuit.edu.cn;
    
    import com.cuit.edu.cn.db.DateBaseHelper;
    
    import android.app.Activity;
    import android.content.ContentValues;
    import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    import android.os.Bundle;
    import android.view.View;
    import android.view.View.OnClickListener;
    import android.widget.Button;
    
    public class SqLiteActivity extends Activity {
        /** Called when the activity is first created. */
    	
    	private Button createButton = null;
    	private Button updatebaseButton = null;
    	private Button insertButton = null;
    	private Button updateButton = null;
    	private Button queryButton = null;
        @Override
        public void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.main);
            
            createButton = (Button)findViewById(R.id.createdatebase);
            updatebaseButton = (Button)findViewById(R.id.updateDatebase);
            insertButton = (Button)findViewById(R.id.insterButton);
            updateButton = (Button)findViewById(R.id.updateButton);
            queryButton = (Button)findViewById(R.id.queryButton);
            
            
            createButton.setText(R.string.create);
            updatebaseButton.setText(R.string.updatebase);
            insertButton.setText(R.string.insert);
            updateButton.setText(R.string.update);
            queryButton.setText(R.string.query);
            
            createButton.setOnClickListener(new createButtonListener());
            updatebaseButton.setOnClickListener(new updatebaseButtonListener());
            insertButton.setOnClickListener(new insertButtonListener());
            updateButton.setOnClickListener(new updateButtonListener());
            queryButton.setOnClickListener(new queryButtonListener());
            
            
            
        }
        
        class createButtonListener implements OnClickListener
        {
    
    		@Override
    		public void onClick(View v) {
    			// TODO Auto-generated method stub
    			DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");
    			SQLiteDatabase db = dbHelper.getReadableDatabase();
    		}
        	
        }
        
        class updatebaseButtonListener implements OnClickListener
        {
    
    		@Override
    		public void onClick(View v) {
    			// TODO Auto-generated method stub
    		 System.out.println("b================");
    			DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base",90);
    			
    			SQLiteDatabase db = dbHelper.getReadableDatabase();
    			
    			dbHelper.onUpgrade(db, 90, 91);
    			
    		}
        	
        }
        
        class insertButtonListener implements OnClickListener
        {
    
    		@Override
    		public void onClick(View v) {
    			// TODO Auto-generated method stub
    			ContentValues values = new ContentValues();
    			values.put("id", 1);
    			values.put("name", "rock");
    			DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this,"user_Base");
    			SQLiteDatabase db = dbHelper.getWritableDatabase();
    			db.insert("user", null, values);
    		}
        	
        }
        
        class updateButtonListener implements OnClickListener
        {
    
    		@Override
    		public void onClick(View arg0) {
    			// TODO Auto-generated method stub
    			DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");
    			SQLiteDatabase db = dbHelper.getWritableDatabase();
    			ContentValues values = new ContentValues();
    			values.put("name", "cara");
    			db.update("user", values, "id=?", new String[]{"1"});
    		}
        	
        }
        class queryButtonListener implements OnClickListener{
    
    		@Override
    		public void onClick(View v) {
    			// TODO Auto-generated method stub
    			DateBaseHelper dbHelper = new DateBaseHelper(SqLiteActivity.this, "user_Base");
    			SQLiteDatabase db = dbHelper.getReadableDatabase();
    			Cursor cursor = db.query("user", new String[]{"id","name"}, "id=?", new String[]{"1"}, null, null, null);
    			while(cursor.moveToNext())
    			{
    				String name = cursor.getString(cursor.getColumnIndex("name"));
    				System.out.println("------"+name);
    			}
    				
    		}
        	
        }
    }

![1361628445_6006.jpg][]

DateBaseHelper.java

package com.cuit.edu.cn.db;
    
    import android.content.Context;
    import android.database.sqlite.SQLiteDatabase;
    import android.database.sqlite.SQLiteDatabase.CursorFactory;
    import android.database.sqlite.SQLiteOpenHelper;
    
    public class DateBaseHelper extends SQLiteOpenHelper {
    
    	private static final int VERSION = 1;
    	public DateBaseHelper(Context context, String name, CursorFactory factory,
    			int version) {
    		super(context, name, factory, version);
    		// TODO Auto-generated constructor stub
    	}
    	
    	public DateBaseHelper(Context context,String name)
    	{
    		this(context,name,VERSION);
    	}
    	
    	public DateBaseHelper(Context context,String name,int version)
    	{
    		this(context,name,null,VERSION);
    	}
    
    	@Override
    	public void onCreate(SQLiteDatabase db) {
    		// TODO Auto-generated method stub
    		System.out.println("createdataBase");
    		
    		db.execSQL("create table user(id int, name varchar(20))");
    	}
    
    	@Override
    	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    		// TODO Auto-generated method stub
    		System.out.println("updataBase");
    	}
    
    }

main.xml

<?xml version="1.0" encoding="utf-8"?>
    <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent"
        android:orientation="vertical" >
    
        <TextView
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:text="@string/hello" />
        <Button
            android:id="@+id/createdatebase" 
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            
            />
    
            <Button
            android:id="@+id/updateDatebase" 
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            />
    
            <Button
            android:id="@+id/insterButton" 
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            />
            <Button
            android:id="@+id/updateButton" 
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            
            />
            <Button
            android:id="@+id/queryButton" 
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            
            />
            
    
    </LinearLayout>

strings.xml

<?xml version="1.0" encoding="utf-8"?>
    <resources>
    
        <string name="hello">Hello World, SqLiteActivity!</string>
        <string name="app_name">SqLite</string>
        <string name="query">query</string>
        <string name="updatebase">updatebase</string>
        <string name="update">update</string>
        <string name="create">create</string>
        <string name="insert">insert</string>
        
    
    </resources>

### 注意事项 ###

1.       使用sqlite3命令需要在命令行界面使用；

2.       可以使用adb shell命令进入命令行界面，前提是模拟器需要开启，且成功配置Android环境变量（H:\\Program files\\android-sdk-windows\\platform-tools）；

![1361628502_1742.jpg][]

3.       数据文件保存在此路径下：/data/data/com.cuit.edu.cn/databases

4.       使用数据库，使用sqlite3数据库名命令。

![1361628468_8430.jpg][]

### 参考资料 ###

Android数据保存之SQLite方法

[http://www.cnitblog.com/liaoqingshan/archive/2013/02/20/86986.html][http_www.cnitblog.com_liaoqingshan_archive_2013_02_20_86986.html]

Android sqlite3命令行操作方法

[http://blog.csdn.net/ccwwff/article/details/5834482][http_blog.csdn.net_ccwwff_article_details_5834482]

Command Line Shell For SQLite

[http://www.sqlite.org/sqlite.html][http_www.sqlite.org_sqlite.html]

SQlite命令行工具的使用

[http://www.cnblogs.com/hnrainll/archive/2011/04/22/2024627.html][http_www.cnblogs.com_hnrainll_archive_2011_04_22_2024627.html]

SQLite命令行程序说明

[http://blog.pfan.cn/lounger/26540.html][http_blog.pfan.cn_lounger_26540.html]

<table style="border-bottom:#48c5db 5px double; border-left:#48c5db 5px double; padding-bottom:5px; background-color:black; padding-left:5px; border-spacing:0; width:100%; padding-right:30px; height:90px; border-top:#48c5db 5px double; border-right:#48c5db 5px double; padding-top:5px"> 
 <tbody> 
  <tr> 
   <td><img alt="katoon" src="https://img-my.csdn.net/uploads/201301/06/1357456262_5409.jpg" style="height:80px"></td> 
   <td style="text-align:right"><a title="新浪微博求粉 ^_^" href="http://weibo.com/wentasy" rel="nofollow"><img title="新浪微博求粉 ^_^" alt="Sina" src="https://img-my.csdn.net/uploads/201210/26/1351182273_5476.png.thumb.jpg" style="height:40px"></a> &nbsp;<a title="我的CSDN博客——HelloWorld" href="http://blog.csdn.net/Wentasy" rel="nofollow"><img title="我的CSDN博客——HelloWorld" alt="CSDN" src="https://img-my.csdn.net/uploads/201210/26/1351182268_8254.png.thumb.jpg" style="height:40px"></a></td> 
  </tr> 
  <tr> 
   <td style="text-align:right; font-family:microsoft yahei; color:white; font-size:12px"> <a title="我的CSDN博客——HelloWorld" href="http://blog.csdn.net/Wentasy" rel="nofollow">@Wentasy</a> 博文仅供参考，欢迎大家来访。如有错误之处，希望批评指正。原创博文如需转载请注明出处，谢谢 :) [CSDN博客]</td> 
  </tr> 
 </tbody> 
</table>

[1361628445_6006.jpg]: https://img-my.csdn.net/uploads/201302/23/1361628445_6006.jpg
[1361628502_1742.jpg]: https://img-my.csdn.net/uploads/201302/23/1361628502_1742.jpg
[1361628468_8430.jpg]: https://img-my.csdn.net/uploads/201302/23/1361628468_8430.jpg
[http_www.cnitblog.com_liaoqingshan_archive_2013_02_20_86986.html]: http://www.cnitblog.com/liaoqingshan/archive/2013/02/20/86986.html
[http_blog.csdn.net_ccwwff_article_details_5834482]: http://blog.csdn.net/ccwwff/article/details/5834482
[http_www.sqlite.org_sqlite.html]: http://www.sqlite.org/sqlite.html
[http_www.cnblogs.com_hnrainll_archive_2011_04_22_2024627.html]: http://www.cnblogs.com/hnrainll/archive/2011/04/22/2024627.html
[http_blog.pfan.cn_lounger_26540.html]: http://blog.pfan.cn/lounger/26540.html