Detective Q: กุมภาพันธ์ 2013

วันพฤหัสบดีที่ 28 กุมภาพันธ์ พ.ศ. 2556

Web วาดรูปด้วย canvas จาก HTML5

ใน HTML5 นั้นจะมี Element ที่ชื่อว่า canvas ที่เราสามารถใช้ jQuery หรือ JavaScript ควบคุมการทำงานของมันได้ ไม่ว่าจะวาดภาพ วาดวงกลม ใส่รูป เราก็สามารถใส่เข้าไปใน canvas ได้

ถ้าเพื่อนๆที่เคยใช้พวก Java applet คงจะพอนึกภาพออกนะครับว่า Canvas นั้นมันก็เป็นพื้นที่สี่เหลี่ยมที่เอาไว้ใช้แสดงผลกราฟฟิก ที่เราสามารถจะควบคุมได้ สามารถควบคุมในระดับ pixel ได้เลยทีเดียว

Canvas นั้นก็เหมือนๆกับ Element อื่นๆครับ สามารถกำหนด Style ให้ได้ไม่ว่าจะเป็นสี ขนาดความกว้าง ความสูง กำหนดทำแหน่งได้ด้วย

ผมก็เลยเอาตัวอย่างเว็บที่ผมเขียนขึ้นมาให้ดูว่ามันเป็นอย่างไร

ผมไม่ได้เขียนขึ้นเองมาทั้งหมด นำมาจากหลายที่ แก้ไขและเพิ่มเติม

ก็เลยจะนำมาแบ่งให้เพื่อนๆศึกษากันดู ^^

>>> Source Code Project

------------------------------------------------------------------------------------------------------------

canvas.html

<html>

<head>

</head>

<body>

<button id="pencil" onclick="Default()"> Default </button>

<button id="Submit" onclick="Submit()"> Submit </button>

</br>

<button id="clears" onclick="Pencil()"> Pencil </button>

<button id="Circle" onclick="Circle()"> Circle </button>

<button id="Rectangle" onclick="Rectangle()"> Rectangle </button>

<button id="Ellipse" onclick="Ellipse()"> Ellipse </button>

<button id="export" onclick="exportImage()"> Export </button>

<button id="eraser" onclick="eraser()"> Eraser </button>

<button id="clears" onclick="Clear_image()"> Clear </button></br>

var mouse = {x: 0, y: 0};

var start_mouse = {x: 0, y: 0};

var radius = 5;

var canvas = document.getElementById('canvas'),

coord = document.getElementById('coord'),

context = canvas.getContext('2d'), // get 2D context

rect = {},

drag = false;

imgCat = new Image();

/*********** draw image *************/

imgCat.src = 'Untitled.jpg';

imgCat.onload = function() { // wait for image load

context.drawImage(imgCat, 0, 0); // draw imgCat on (0, 0)

context.lineWidth = radius;

context.strokeStyle = '#000000';

context.lineWidth = 5;

};

function getPath(){

var str = document.getElementById('blaat').value;

// lastIndexOf('\\') you need to use two \\'s because you use \ to escape

str = str.substring(0, str.lastIndexOf('\\'));

//if you want a closing \ just add a \ to the str (str += '\')

document.getElementById('verborgenBlaat').value = str;

// alert to proof it sets the directory

alert(document.getElementById('verborgenBlaat').value)

}

function preview(test){

var source=test.value;

alert(source);

}

function fileSelected(){

alert( document.forms[0].files.value);

}

function Submit(){

alert(document.forms[0].getElementById('files').value);

}

/*********** handle mouse events on canvas **************/

function Pencil(){

context.strokeStyle = document.getElementById("favcolor").value;

var mousedown = false;

canvas.onmousedown = function(e) {

var pos = fixPosition(e, canvas);

mousedown = true;

context.beginPath();

context.moveTo(pos.x, pos.y);

return false;

};

canvas.onmousemove = function(e) {

var pos = fixPosition(e, canvas);

coord.innerHTML = '(' + pos.x + ',' + pos.y + ')';

if (mousedown) {

context.lineTo(pos.x, pos.y);

context.stroke();

}

};

canvas.onmouseup = function(e) {

mousedown = false;

};

}

/********** utils ******************/

// Thanks to http://stackoverflow.com/questions/55677/how-do-i-get-the-coordinates-of-a-mouse-click-on-a-canvas-element/4430498#4430498

function fixPosition(e, gCanvasElement) {

var x;

var y;

if (e.pageX || e.pageY) {

x = e.pageX;

y = e.pageY;

}

else {

x = e.clientX + document.body.scrollLeft +

document.documentElement.scrollLeft;

y = e.clientY + document.body.scrollTop +

document.documentElement.scrollTop;

}

x -= gCanvasElement.offsetLeft;

y -= gCanvasElement.offsetTop;

return {x: x, y:y};

}

function exportImage() {

window.open(canvas.toDataURL(),'_blank','width=800,height=600');

//window.open("http://www.w3schools.com")

}

function Default(){

context.strokeStyle = document.getElementById("favcolor").value;

context.lineWidth = 5;

}

function Clear_image() {

context.clearRect(0, 0, canvas.width, canvas.height);

}

function sizeP() {

radius++;

context.lineWidth = radius;

}

function sizeD() {

if(radius==1){}

else{

radius--;

context.lineWidth = radius;

}

function eraser(){

Pencil();

context.strokeStyle = "#FFFFFF";

}

function showR(){

document.write(radius);

}

//////////////////////////////////////////////////////

function Rectangle(){

context.strokeStyle = document.getElementById("favcolor").value;

var mousedown = false;

canvas.onmousedown = function(e) {

var pos = fixPosition(e, canvas);

mousedown = true;

context.drawImage(canvas, 0, 0);

context.beginPath();

rect.startX = e.pageX - this.offsetLeft;

rect.startY = e.pageY - this.offsetTop;

return false;

};

canvas.onmousemove = function(e) {

var pos = fixPosition(e, canvas);

coord.innerHTML = '(' + pos.x + ',' + pos.y + ')';

/* if (mousedown) {

rect.w = (e.pageX - this.offsetLeft) - rect.startX;

rect.h = (e.pageY - this.offsetTop) - rect.startY ;

context.clearRect(0,0,canvas.width,canvas.height);

context.strokeRect(rect.startX, rect.startY, rect.w, rect.h);

}

};

canvas.onmouseup = function(e) {

if (mousedown) {

rect.w = (e.pageX - this.offsetLeft) - rect.startX;

rect.h = (e.pageY - this.offsetTop) - rect.startY ;

context.strokeRect(rect.startX, rect.startY, rect.w, rect.h);

}

mousedown = false;

};

}

function Circle(){

context.strokeStyle = document.getElementById("favcolor").value;

var mousedown = false;

canvas.onmousedown = function(e) {

var pos = fixPosition(e, canvas);

mousedown = true;

context.drawImage(canvas, 0, 0);

context.beginPath();

rect.startX = e.pageX - this.offsetLeft;

rect.startY = e.pageY - this.offsetTop;

return false;

};

canvas.onmousemove = function(e) {

var pos = fixPosition(e, canvas);

coord.innerHTML = '(' + pos.x + ',' + pos.y + ')';

/* if (mousedown) {

rect.w = (e.pageX - this.offsetLeft) - rect.startX;

rect.h = (e.pageY - this.offsetTop) - rect.startY ;

context.clearRect(0,0,canvas.width,canvas.height);

context.strokeRect(rect.startX, rect.startY, rect.w, rect.h);

}

};

canvas.onmouseup = function(e) {

if (mousedown) {

rect.w = (e.pageX - this.offsetLeft) - rect.startX;

rect.h = (e.pageY - this.offsetTop) - rect.startY ;

var radius = Math.max(

Math.abs(rect.w),

Math.abs(rect.h)

) / 2;

context.arc(rect.startX, rect.startY, radius, 0, Math.PI*2, false);

context.stroke();

context.closePath();

}

mousedown = false;

};

}

</script>

</body>

</html>

------------------------------------------------------------------------------------------------------------

canvas2image.js

var Canvas2Image = (function() {

// check if we have canvas support

var bHasCanvas = false;

var oCanvas = document.createElement("canvas");

if (oCanvas.getContext("2d")) {

bHasCanvas = true;

}

// no canvas, bail out.

if (!bHasCanvas) {

return {

saveAsBMP : function(){},

saveAsPNG : function(){},

saveAsJPEG : function(){}

}

var bHasImageData = !!(oCanvas.getContext("2d").getImageData);

var bHasDataURL = !!(oCanvas.toDataURL);

var bHasBase64 = !!(window.btoa);

var strDownloadMime = "image/octet-stream";

// ok, we're good

var readCanvasData = function(oCanvas) {

var iWidth = parseInt(oCanvas.width);

var iHeight = parseInt(oCanvas.height);

return oCanvas.getContext("2d").getImageData(0,0,iWidth,iHeight);

}

// base64 encodes either a string or an array of charcodes

var encodeData = function(data) {

var strData = "";

if (typeof data == "string") {

strData = data;

} else {

var aData = data;

for (var i=0;i<aData.length;i++) {

strData += String.fromCharCode(aData[i]);

}

return btoa(strData);

}

// creates a base64 encoded string containing BMP data

// takes an imagedata object as argument

var createBMP = function(oData) {

var aHeader = [];

var iWidth = oData.width;

var iHeight = oData.height;

aHeader.push(0x42); // magic 1

aHeader.push(0x4D);

var iFileSize = iWidth*iHeight*3 + 54; // total header size = 54 bytes

aHeader.push(iFileSize % 256); iFileSize = Math.floor(iFileSize / 256);

aHeader.push(iFileSize % 256);

aHeader.push(0); // reserved

aHeader.push(0);

aHeader.push(0); // reserved

aHeader.push(0);

aHeader.push(54); // dataoffset

aHeader.push(0);

var aInfoHeader = [];

aInfoHeader.push(40); // info header size

aInfoHeader.push(0);

var iImageWidth = iWidth;

aInfoHeader.push(iImageWidth % 256); iImageWidth = Math.floor(iImageWidth / 256);

aInfoHeader.push(iImageWidth % 256);

var iImageHeight = iHeight;

aInfoHeader.push(iImageHeight % 256); iImageHeight = Math.floor(iImageHeight / 256);

aInfoHeader.push(iImageHeight % 256);

aInfoHeader.push(1); // num of planes

aInfoHeader.push(0);

aInfoHeader.push(24); // num of bits per pixel

aInfoHeader.push(0);

aInfoHeader.push(0); // compression = none

aInfoHeader.push(0);

var iDataSize = iWidth*iHeight*3;

aInfoHeader.push(iDataSize % 256); iDataSize = Math.floor(iDataSize / 256);

aInfoHeader.push(iDataSize % 256);

for (var i=0;i<16;i++) {

aInfoHeader.push(0); // these bytes not used

}

var iPadding = (4 - ((iWidth * 3) % 4)) % 4;

var aImgData = oData.data;

var strPixelData = "";

var y = iHeight;

do {

var iOffsetY = iWidth*(y-1)*4;

var strPixelRow = "";

for (var x=0;x<iWidth;x++) {

var iOffsetX = 4*x;

strPixelRow += String.fromCharCode(aImgData[iOffsetY+iOffsetX+2]);

strPixelRow += String.fromCharCode(aImgData[iOffsetY+iOffsetX+1]);

strPixelRow += String.fromCharCode(aImgData[iOffsetY+iOffsetX]);

}

for (var c=0;c<iPadding;c++) {

strPixelRow += String.fromCharCode(0);

}

strPixelData += strPixelRow;

} while (--y);

var strEncoded = encodeData(aHeader.concat(aInfoHeader)) + encodeData(strPixelData);

return strEncoded;

}

// sends the generated file to the client

var saveFile = function(strData) {

document.location.href = strData;

}

var makeDataURI = function(strData, strMime) {

return "data:" + strMime + ";base64," + strData;

}

// generates a <img> object containing the imagedata

var makeImageObject = function(strSource) {

var oImgElement = document.createElement("img");

oImgElement.src = strSource;

return oImgElement;

}

var scaleCanvas = function(oCanvas, iWidth, iHeight) {

if (iWidth && iHeight) {

var oSaveCanvas = document.createElement("canvas");

oSaveCanvas.width = iWidth;

oSaveCanvas.height = iHeight;

oSaveCanvas.style.width = iWidth+"px";

oSaveCanvas.style.height = iHeight+"px";

var oSaveCtx = oSaveCanvas.getContext("2d");

oSaveCtx.drawImage(oCanvas, 0, 0, oCanvas.width, oCanvas.height, 0, 0, iWidth, iHeight);

return oSaveCanvas;

}

return oCanvas;

}

return {

saveAsPNG : function(oCanvas, bReturnImg, iWidth, iHeight) {

if (!bHasDataURL) {

return false;

}

var oScaledCanvas = scaleCanvas(oCanvas, iWidth, iHeight);

var strData = oScaledCanvas.toDataURL("image/png");

if (bReturnImg) {

return makeImageObject(strData);

} else {

saveFile(strData.replace("image/png", strDownloadMime));

}

return true;

saveAsJPEG : function(oCanvas, bReturnImg, iWidth, iHeight) {

if (!bHasDataURL) {

return false;

}

var oScaledCanvas = scaleCanvas(oCanvas, iWidth, iHeight);

var strMime = "image/jpeg";

var strData = oScaledCanvas.toDataURL(strMime);

// check if browser actually supports jpeg by looking for the mime type in the data uri.

// if not, return false

if (strData.indexOf(strMime) != 5) {

return false;

}

if (bReturnImg) {

return makeImageObject(strData);

} else {

saveFile(strData.replace(strMime, strDownloadMime));

}

return true;

saveAsBMP : function(oCanvas, bReturnImg, iWidth, iHeight) {

if (!(bHasImageData && bHasBase64)) {

return false;

}

var oScaledCanvas = scaleCanvas(oCanvas, iWidth, iHeight);

var oData = readCanvasData(oScaledCanvas);

var strImgData = createBMP(oData);

if (bReturnImg) {

return makeImageObject(makeDataURI(strImgData, "image/bmp"));

} else {

saveFile(makeDataURI(strImgData, strDownloadMime));

}

return true;

}

};

})();

------------------------------------------------------------------------------------------------------------

วันพุธที่ 27 กุมภาพันธ์ พ.ศ. 2556

โปรแกรม Scan Barcode and QR Code (Android)

ในส่วนของโปรแกรมนี้ ผมได้อยากทำจริงๆ แต่บังเอิญ มีเพื่อนผมคนหนึ่งวานให้เขียนให้หน่อย

ผมก็เลย Solo จัดการให้ด้วยความเป็นคนดี 555+ ทั้งที่ไม่มีความรู้ด้าน Android เท่าไหร่

ในบทความนี้ผมจะเอาตัวอย่างโค้ดมาให้ดูว่ามันเป็นแบบไหน เผื่อเพื่อนคนไหนสนใจ จะนำไปศึกษาได้ เพราะผมก็นำจากคนอื่นมาต่อยอดอีกที เดี่ยวถ้ามีโอกาสผมจะมาอธิบายแต่ละส่วนให้ฟังนะครับ ^^

โดยตัวโปรแกรมนี้ ผมได้นำ Library ของ zbar.jar มาใช้ด้วย เพราะถ้าจะให้เขียนมาทั้งหมด มันก็จะเยอะไป ก็ค่อยๆศึกษากันไปนะครับ ^^

>>> Source Code Project

----------------------------------------------------------------------------------------------------------

CameraPreview.java

public class CameraPreview extends SurfaceView implements SurfaceHolder.Callback {

private SurfaceHolder mHolder;

private Camera mCamera;

private PreviewCallback previewCallback;

private AutoFocusCallback autoFocusCallback;

public CameraPreview(Context context, Camera camera,

PreviewCallback previewCb,

AutoFocusCallback autoFocusCb) {

super(context);

mCamera = camera;

previewCallback = previewCb;

autoFocusCallback = autoFocusCb;

* Set camera to continuous focus if supported, otherwise use

* software auto-focus. Only works for API level >=9.

Camera.Parameters parameters = camera.getParameters();

for (String f : parameters.getSupportedFocusModes()) {

if (f == Parameters.FOCUS_MODE_CONTINUOUS_PICTURE) {

mCamera.setFocusMode(Parameters.FOCUS_MODE_CONTINUOUS_PICTURE);

autoFocusCallback = null;

break;

}

// Install a SurfaceHolder.Callback so we get notified when the

// underlying surface is created and destroyed.

mHolder = getHolder();

mHolder.addCallback(this);

// deprecated setting, but required on Android versions prior to 3.0

mHolder.setType(SurfaceHolder.SURFACE_TYPE_PUSH_BUFFERS);

}

public void surfaceCreated(SurfaceHolder holder) {

// The Surface has been created, now tell the camera where to draw the preview.

try {

mCamera.setPreviewDisplay(holder);

} catch (IOException e) {

Log.d("DBG", "Error setting camera preview: " + e.getMessage());

}

public void surfaceDestroyed(SurfaceHolder holder) {

// Camera preview released in activity

}

public void surfaceChanged(SurfaceHolder holder, int format, int width, int height) {

* If your preview can change or rotate, take care of those events here.

* Make sure to stop the preview before resizing or reformatting it.

if (mHolder.getSurface() == null){

// preview surface does not exist

return;

}

// stop preview before making changes

try {

mCamera.stopPreview();

} catch (Exception e){

// ignore: tried to stop a non-existent preview

}

try {

// Hard code camera surface rotation 90 degs to match Activity view in portrait

mCamera.setDisplayOrientation(90);

mCamera.setPreviewDisplay(mHolder);

mCamera.setPreviewCallback(previewCallback);

mCamera.startPreview();

mCamera.autoFocus(autoFocusCallback);

} catch (Exception e){

Log.d("DBG", "Error starting camera preview: " + e.getMessage());

}

------------------------------------------------------------------------------------------------------------

CameraTestActivity.java

public class CameraTestActivity extends Activity

{

private Camera mCamera;

private CameraPreview mPreview;

private Handler autoFocusHandler;

private EditText et;

public static SQLiteDatabase db;

TextView output;

EditText res ;

TextView scanText;

Button scanButton;

Button view;

Button del;

Button back;

Button exit;

ImageScanner scanner;

private boolean barcodeScanned = false;

private boolean previewing = true;

static {

System.loadLibrary("iconv");

}

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_PORTRAIT);

autoFocusHandler = new Handler();

mCamera = getCameraInstance();

res = (EditText)findViewById(R.id.editText1);

/* Instance barcode scanner */

scanner = new ImageScanner();

scanner.setConfig(0, Config.X_DENSITY, 3);

scanner.setConfig(0, Config.Y_DENSITY, 3);

mPreview = new CameraPreview(this, mCamera, previewCb, autoFocusCB);

FrameLayout preview = (FrameLayout)findViewById(R.id.cameraPreview);

et = (EditText)findViewById(R.id.editText1);

Button save = (Button)findViewById(R.id.button2);

view = (Button)findViewById(R.id.button1);

exit = (Button)findViewById(R.id.exit);

save.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

String name = et.getText().toString(); // รับค่าจาก txt_name

if(name.equals("")){

return;

}

String sql ="insert into person values(null,'"+name+"')";

try{

db.execSQL(sql);

Toast.makeText(getBaseContext(), "Inset to Database is success.",Toast.LENGTH_SHORT).show();

}catch(Exception e){

Toast.makeText(getBaseContext(), "Error,"+e.getMessage(),Toast.LENGTH_SHORT).show();

}finally{

et.setText("");

}

});

view.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

Intent intent = new Intent(CameraTestActivity.this,ShowData.class);

startActivity(intent);

}

});

exit.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

System.exit(0);

}

});

preview.addView(mPreview);

scanText = (TextView)findViewById(R.id.scanText);

scanButton = (Button)findViewById(R.id.ScanButton);

scanButton.setOnClickListener(new OnClickListener() {

public void onClick(View v) {

if (barcodeScanned) {

barcodeScanned = false;

scanText.setText("Scanning...");

mCamera.setPreviewCallback(previewCb);

mCamera.startPreview();

previewing = true;

mCamera.autoFocus(autoFocusCB);

}

});

db = openOrCreateDatabase( "test1.db", SQLiteDatabase.CREATE_IF_NECESSARY, null); // สร้าง Database ชื่อ test1.db

db.setVersion(1);

db.setLocale(Locale.getDefault());

db.setLockingEnabled(true);

try {

final String CREATE_TABLE_CONTAIN = "CREATE TABLE IF NOT EXISTS person (" // ถ้าไม่มี table person ให้ทำการสร้าง

+ "_id INTEGER primary key AUTOINCREMENT," // ฟิลด์ _id ให้เป็น PK

+ "name TEXT);"; // ฟิลด์ name ชนิด Text

db.execSQL(CREATE_TABLE_CONTAIN);

// Toast.makeText(getBaseContext(), "Table person is created.",Toast.LENGTH_SHORT).show();

}

catch (Exception e) {

Toast.makeText(getBaseContext(), "Error,"+e.getMessage(),Toast.LENGTH_SHORT).show();

}

@Override

protected void onDestroy(){

super.onDestroy();

db.close(); // Close Database Connection

}

public void onPause() {

super.onPause();

releaseCamera();

}

/** A safe way to get an instance of the Camera object. */

public static Camera getCameraInstance(){

Camera c = null;

try {

c = Camera.open();

} catch (Exception e){

}

return c;

}

private void releaseCamera() {

if (mCamera != null) {

previewing = false;

mCamera.setPreviewCallback(null);

mCamera.release();

mCamera = null;

}

private Runnable doAutoFocus = new Runnable() {

public void run() {

if (previewing)

mCamera.autoFocus(autoFocusCB);

}

};

PreviewCallback previewCb = new PreviewCallback() {

public void onPreviewFrame(byte[] data, Camera camera) {

Camera.Parameters parameters = camera.getParameters();

Size size = parameters.getPreviewSize();

Image barcode = new Image(size.width, size.height, "Y800");

barcode.setData(data);

int result = scanner.scanImage(barcode);

if (result != 0) {

previewing = false;

mCamera.setPreviewCallback(null);

mCamera.stopPreview();

SymbolSet syms = scanner.getResults();

for (Symbol sym : syms) {

scanText.setText("barcode result " + sym.getData());

res.setText(sym.getData().toString());

barcodeScanned = true;

}

};

// Mimic continuous auto-focusing

AutoFocusCallback autoFocusCB = new AutoFocusCallback() {

public void onAutoFocus(boolean success, Camera camera) {

autoFocusHandler.postDelayed(doAutoFocus, 1000);

}

};

}

-----------------------------------------------------------------------------------------------------------

ShowData.java

public class ShowData extends Activity{

private TextView output;
private Button del;

private Button back;

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.showdata);

output = (TextView)findViewById(R.id.textView1);

del = (Button)findViewById(R.id.delete);

back = (Button)findViewById(R.id.back);

CameraTestActivity.db = openOrCreateDatabase( "test1.db", SQLiteDatabase.CREATE_IF_NECESSARY, null); // สร้าง Database ชื่อ test1.db

CameraTestActivity.db.setVersion(1);

CameraTestActivity.db.setLocale(Locale.getDefault());

CameraTestActivity.db.setLockingEnabled(true);

try {

final String CREATE_TABLE_CONTAIN = "CREATE TABLE IF NOT EXISTS person (" // ถ้าไม่มี table person ให้ทำการสร้าง

+ "_id INTEGER primary key AUTOINCREMENT," // ฟิลด์ _id ให้เป็น PK

+ "name TEXT);"; // ฟิลด์ name ชนิด Text

CameraTestActivity.db.execSQL(CREATE_TABLE_CONTAIN);

// Toast.makeText(getBaseContext(), "Table person is created.",Toast.LENGTH_SHORT).show();

}

catch (Exception e) {

Toast.makeText(getBaseContext(), "Error,"+e.getMessage(),Toast.LENGTH_SHORT).show();

}

showdata();

del.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

delete_clicked();

}

});

back.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

Intent intent = new Intent(ShowData.this,CameraTestActivity.class);

startActivity(intent);

}

});

}

public void delete_clicked(){

String sql = "delete from person ";

CameraTestActivity.db.execSQL(sql);

showdata();

}

private void showdata() {

output.setText("");

SQLiteCursor cur = (SQLiteCursor)CameraTestActivity.db.rawQuery("select * from person",null);

cur.moveToFirst();

while (cur.isAfterLast() == false) {

output.append(" Data : "+cur.getString(1)+"\n");

cur.moveToNext();

}

cur.close();

}

------------------------------------------------------------------------------------------------------------

ที่มาที่ไป

เรื่องมันก็มีอยู่ว่า อยากจะเก็บเนื้อหา ความรู้ และสิ่งที่ได้ทำไว้ที่ไหนสักแห่ง

ก็ได้พบเจอกับ blogger โดยบังเอิญ ก็เลยปิ้งไอเดีย เอาทุกอย่างที่สะสมมา มาเก็บไว้ในนี้ และเผยแพร่ให้เพื่อนๆที่สนใจมาดู นี้ก็คือที่มานั้นเอง อิอิ