登录
首页 » Android » Android 中 SQLite的使用范例

Android 中 SQLite的使用范例

于 2023-03-03 发布 文件大小:16.65 kB
0 180
下载积分: 2 下载次数: 2

代码说明:

这是一个在Android 中 如何使用SQLite的简单范例,本例中演示的SqlLite功能不用contentProvider,直接用裸sql进行操作。主要演示了几种技巧:   1.介绍:DatabaseHelper.重新建立数据表、插入两条数据、   2.删除表的知道了,删除其中的一条数据,删除title为haiyang的一条记录,但是删除数据库的没有发现.   3.在屏幕的title区域显示当前数据表当中的数据的条数。

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • android网络post和get发送数据
    用于Android和服务器通信的工具类,可以使用post方式和get方式向服务器发送hashmap数据。在hashmap中放入命令等其他key和value就可以调用服务起的不同程序
    2022-07-16 23:29:50下载
    积分:1
  • android 录像 源码 小米测试版
    android 录像实例源码  可实现录像功能 实现Android camera Mediarecorder类实现录像,可以录音 小米三测试版
    2022-01-28 04:35:11下载
    积分:1
  • android电子点餐系统
    CREATE PROCEDURE `new_proc`(IN tableId1 INTEGER(11), IN tableId2 INTEGER(11))     NOT DETERMINISTIC     SQL SECURITY DEFINER     COMMENT "" BEGIN      declare perNum,oId1,oId2 integer;           select personNum  into perNum from OrderTbl as ot where      ot.tableId =tableId2      and ot.isPay = 0;           select id into oId1 from OrderTbl as ot where      ot.tableId = tableId1      and ot.isPay = 0;           select id into oId2 from OrderTbl as ot where      ot.tableId = tableId2      and ot.isPay = 0;      update Order
    2022-08-09 22:02:27下载
    积分:1
  • 上传文件
    项目实现了上传录制的小视频,包括前台代码和后台服务器代码,上传很流畅更好的提高用户的体验,打开开发工具加载项目即可运行我测试过了特别好使
    2022-04-11 06:34:36下载
    积分:1
  • Android tcp通讯学习用
    核心代码:package com.Test;import android.os.Bundle;import android.os.Handler;import android.os.Message;import android.util.Log;import android.app.Activity;import android.view.Menu;import android.widget.Button;import android.view.View;import android.view.View.OnClickListener;import java.io.BufferedInputStream;import java.io.InputStream;import java.io.OutputStream;import java.io.IOException;import java.io.UnsupportedEncodingException;import java.io.InputStreamReader;import java.io.BufferedReader;import java.io.PrintWriter;import java.io.Reader;import java.net.Socket;import java.net.ServerSocket;import java.net.UnknownHostException;import android.view.TextureView;import android.widget.EditText;import java.lang.String;import java.lang.Thread;public class MainActivity extends Activity implements OnClickListener{ private Button m_btn; private Button m_sendbtn; private ServerSocket mySerSocket; private Socket clientSocket; private EditText m_edit; private String line; boolean conn = true; private Socket accSocket; private static final String Host = "10.0.2.2"; private static final int Port = 12000; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); m_btn = (Button)findViewById(R.id.button1); m_sendbtn = (Button)findViewById(R.id.button2); m_edit = (EditText)findViewById(R.id.editText1); //m_btn.setOnClickListener(this); m_btn.setOnClickListener(new ReceiverListener()); m_sendbtn.setOnClickListener(this); //Socket clientSocket = new Socket(Host, Port); } class ReceiverListener implements OnClickListener { private ReceiveThread mReceiveThread = null; private boolean stop = true; private Handler mHandler = null; public void onClick(View v) { try { if(clientSocket == null) { clientSocket = new Socket(Host, Port); } // InputStream myInputStream = clientSocket.getInputStream();// // //BufferedReader in = new BufferedReader(new InputStreamReader(myInputStream));//// byte [] buffer = new byte[myInputStream.available()]; //int temp = 0; //String strMsg = in.readLine(); // myInputStream.read(buffer);// // // String strMsg = new String(buffer);// // m_edit.setText(strMsg);// while ((temp = myInputStream.read(buffer)) != -1)// {// m_edit.setText(new String(buffer, 0, temp));//// } mReceiveThread = new ReceiveThread(clientSocket); stop = false; mReceiveThread.start(); } catch (IOException e) { e.printStackTrace(); } //消息处理 mHandler = new Handler() { public void handleMessage(Message msg) { m_edit.setText((msg.obj).toString()); } }; } private class ReceiveThread extends Thread { private InputStream inStream = null; private byte[] buf; private String str = null; ReceiveThread(Socket s) { try { this.inStream = s.getInputStream(); } catch(IOException e) { e.printStackTrace(); } } public void run() { while(!stop) { this.buf = new byte[512]; try { this.inStream.read(this.buf); } catch(IOException e) { e.printStackTrace(); } try { this.str = new String(this.buf, "GB2312").trim(); } catch(UnsupportedEncodingException e) { e.printStackTrace(); } Message msg = new Message(); msg.obj = this.str; mHandler.sendMessage(msg); } } } } public void onClick(View v) {// if (v.getId() == R.id.button1)// {// new Thread()// {// public void run()// {// try // {// if(clientSocket == null)// {// clientSocket = new Socket(Host, Port);// } // InputStream myInputStream = clientSocket.getInputStream();// // BufferedReader in = new BufferedReader(new InputStreamReader(myInputStream));//// byte [] buffer = new byte[1024 * 4];//// int temp = 0;// // String strMsg = in.readLine();// // //myInputStream.read(buffer);// // //String strMsg = new String(buffer);// // m_edit.setText(strMsg);////// while ((temp = myInputStream.read(buffer)) != -1)//// {//// m_edit.setText(new String(buffer, 0, temp));//////// }// // }// catch (IOException e)// {// e.printStackTrace();// }// }// }.start();// // } if(v.getId() == R.id.button2) { new Thread() { public void run() { try { if(clientSocket == null) { clientSocket = new Socket(Host, Port); } //inputStream clientInputStream = clientSocket. String msg = "RESET-SHOW"; //InputStream clientInputStream = clientSocket.getInputStream(); //BufferedReader br = new BufferedReader(new InputStreamReader(clientSocket.getInputStream())); //BufferedReader br = new BufferedReader(); //line = br.readLine(); OutputStream clientOutputStream = clientSocket.getOutputStream(); byte buffer[]=msg.getBytes(); clientOutputStream.write(buffer); clientOutputStream.flush(); //int temp = 0; // PrintWriter out = new PrintWriter(clientOutputStream);// // out.println("Serer Message: " msg); } catch(IOException e) { e.printStackTrace(); } } }.start(); } }private Reader InputStreamReader() { // TODO Auto-generated method stub return null; }// private Handler handler = new Handler()// {// public void handleMessage(Message msg)// {// super.handleMessage(msg);// //处理UI// m_edit.setText("Finish");// Log.i("PDA", "Finish");// // }// }; @Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.main, menu); return true; }}
    2014-08-18下载
    积分:1
  • android 自定义单选、多选对话框及popwindow窗口实例源码
    android 自定义单选、多选对话框及popwindow窗口实例源码
    2014-08-21下载
    积分:1
  • android 百度地图应用实例源码下载
    android 百度地图应用实例源码下载
    2015-02-25下载
    积分:1
  • android WebView&&ViewFlipper
    This is a demo of page switching, to achieve the effect of switching pages when you read the article .
    2022-08-16 00:45:28下载
    积分:1
  • Android
    2022-04-09 20:10:06下载
    积分:1
  • android-change-with-cPP
    Android代码调用C++代码和C++代码调用Android代码 (Android code call C++ code and C++ code called Android code)
    2011-11-08 15:01:13下载
    积分:1
  • 696516资源总数
  • 106914会员总数
  • 0今日下载