- http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles
sqlite> create table test (id integer, datatype_id integer, level integer, meaning text);
sqlite> .separator ","
sqlite> .import no_yes.csv test - commands: http://www.sqlite.org/cli.html
SQlite
Posted on June 24th, 2014
[Import]
SQL
Posted on June 24th, 2014
[SELECT]
[DELETE]
[INSERT]
- insert into table_name select whatever...
http://stackoverflow.com/questions/7387338/sqlite-insert-select-query-results-into-existing-table - insert , values
http://stackoverflow.com/questions/3620828/sqlite-select-where-empty
Redmine
Posted on June 20th, 2014
[Home]
- http://www.redmine.org/
Redmine is open source and released under the terms of the GNU General Public License v2 (GPL). - Creating Unit Tests: http://developer.android.com/training/activity-testing/activity-unit-testing.html
Java
Posted on June 12th, 2014
[Reference]
- enum : http://pydoing.blogspot.tw/2010/12/java-enum.html
- enum to int : http://stackoverflow.com/questions/13792110/java-enum-return-int
- List of enum values in java : http://stackoverflow.com/questions/13109497/list-of-enum-values-in-java
new ArrayList(Arrays.asList(MyEnum.values()));
[Java Doc]
- Javadoc interview: http://blog.yam.com/csylvia/article/30584073
[File]
- How to open a txt file : http://stackoverflow.com/questions/3806062/how-to-open-a-txt-file-and-read-numbers-in-java
- Write a binray file : http://stackoverflow.com/questions/6981555/how-to-output-binary-data-to-a-file-in-java
- Append file : http://stackoverflow.com/questions/16927263/appending-byte-to-end-of-a-binary-file
- Read binary file : http://stackoverflow.com/questions/7250229/reading-a-binary-file-into-a-single-byte-array-in-java
- Write text file : http://www.abbeyworkshop.com/howto/java/writeText/
[jar]
- jar version: http://stackoverflow.com/questions/5834794/how-to-check-the-version-of-jar-file
Extrace the jar file by zip or rar, open the MANIFEST.MF
- Remove space : http://www.javaworld.com.tw/jute/post/view?bid=29&id=267298
- trim : http://pydoing.blogspot.tw/2011/01/java-trim.html
- hex bin convert: http://stackoverflow.com/questions/4785654/convert-a-string-of-hex-into-ascii-in-java
- Toint : http://cooking-java.blogspot.tw/2010/03/java-string-to-int.html
[Binary]
- byte array: http://openhome.cc/Gossip/Encoding/String.html
- initialize: http://stackoverflow.com/questions/11208479/how-do-i-initialize-a-byte-array-in-java
- Hex convert : http://stackoverflow.com/questions/4785654/convert-a-string-of-hex-into-ascii-in-java
- unsigned byte : https://sites.google.com/site/gencoreoperative/index/java-development/java-unsigned-bytes
http://www.javamex.com/java_equivalents/unsigned.shtml
[Queue]
- Queue : http://jhengjyun.blogspot.tw/2010/09/java-queue.html
- http://tutorials.jenkov.com/java-collections/queue.html
- Iterator : http://tutorials.jenkov.com/java-collections/queue.html
- Can you access elements in the middle of a queue - Java?: https://answers.yahoo.com/question/index?qid=20120205141233AAYfbW4
- http://stackoverflow.com/questions/18279302/how-do-i-perform-a-java-callback-between-classes
- http://ccckmit.wikidot.com/ja:listener
[byte]
- Reading, Writing, and Creating Files: http://docs.oracle.com/javase/tutorial/essential/io/file.html
- Fix array: http://docstore.mik.ua/orelly/java-ent/jnut/ch02_09.htm
- unsigned byte: http://www.rgagnon.com/javadetails/java-0026.html
- Runnable和Thread的區別 : http://blog.csdn.net/wwww1988600/article/details/7309070
- Simple Pointer Handling: http://web.mit.edu/svn/src/swig-1.3.25/Examples/java/pointer/index.html
[C'tor]
[protected]
[Syntex]
netfabb
Posted on June 11th, 2014
[Home]
- Home
- Download netfabb basic: http://www.netfabb.com/downloadcenter.php?basic=1
[Usage]
- How to use MeshLab and Netfabb for fixing your model: http://www.shapeways.com/tutorials/how_to_use_meshlab_and_netfabb
- Automatically Repair STL Files in 2 Minutes with netfabb: http://3daddfab.com/blog/index.php?/archives/10-Automatically-Repair-STL-Files-in-2-Minutes-with-netfabb.html
- Use netfabb to Manually Repair STL Holes, Edges and More: http://www.3daddfab.com/blog/index.php?/permalink/Use-netfabb-to-Manually-Repair-STL-Holes-Edges-and-More.html
- File Preview Browser : Menu | Project | File Preview Browser , the file explorer is at right lower right corner.
Android
Posted on June 10th, 2014
[Reference]
- Create a new project : http://developer.android.com/training/basics/firstapp/creating-project.html
- Log.i : http://stackoverflow.com/questions/2752472/android-how-can-i-print-a-variable-on-eclipse-console
- Java , __FUNC_ ... : http://dragonajax-126-com.iteye.com/blog/1123202
- Action bar : https://developer.android.com/training/basics/actionbar/styling.html
- 五種開源授權規範的比較 (BSD, APACHE, GPL, LGPL, MIT) : http://inspire.twgg.org/internet/trends/item/74-comparison-of-five-kinds-of-standard-open-source-license-bsd-apache-gpl-lgpl-mit.html
- How to use registerReceiver method?: http://stackoverflow.com/questions/4134203/how-to-use-registerreceiver-method
- Intent: http://stackoverflow.com/questions/4878159/android-whats-the-best-way-to-share-data-between-activities
- BroadcastReceiver : http://developer.android.com/reference/android/content/BroadcastReceiver.html
- http://stackoverflow.com/questions/3907713/how-to-send-and-receive-broadcast-message
[Broadcast Receiver]
- 第二十一講：Broadcast Receiver 使用入門 : http://android.yaohuiji.com/archives/727
- 如何使用BroadcastReceiver: http://givemepass.blogspot.tw/2011/12/broadcastreceiver.html
- Android Broadcast Receivers: http://www.tutorialspoint.com/android/android_broadcast_receivers.htm
- Android BroadcastReceiver within Activity : http://stackoverflow.com/questions/4555215/android-broadcastreceiver-within-activity
- How to send and receive broadcast message: http://stackoverflow.com/questions/3907713/how-to-send-and-receive-broadcast-message
- ANR(Application is Not Responding) : 如何使用Thread和Handler http://givemepass.blogspot.tw/2011/11/threadhandler.html
[Preference]
- Preference: http://developer.android.com/reference/android/preference/Preference.html
- Class : http://developer.android.com/reference/android/preference/package-summary.html
- notify: http://stackoverflow.com/questions/4997907/how-to-detect-if-changes-were-made-in-the-preferences
- Click: http://stackoverflow.com/questions/15536908/preference-activity-on-preference-click-listener
- Tutorial: http://rominirani.com/android-preferences-tutorial/
- list perference: http://stackoverflow.com/questions/9880841/using-list-preference-in-android
- ANDROIDMANIFEST.XML 詳解 : http://homeserver.com.tw/2013/09/25/androidmanifest-xml-%E8%A9%B3%E8%A7%A3/
- Preference.OnPreferenceClickListener : http://developer.android.com/reference/android/preference/Preference.OnPreferenceClickListener.html
- OnPreferenceClickListener : http://www.cnblogs.com/LutherTsai/archive/2011/12/25/2301014.html
- OnPreferenceClickListener : http://stackoverflow.com/questions/16449372/onpreferenceclick-and-onpreferenceclicklistener
- Tutorial : http://blog.csdn.net/ichliebephone/article/details/5916320
- background image: http://mobilemancer.com/2011/05/11/setting-a-background-image-on-a-preferenceactivity/
- Click event: http://stackoverflow.com/questions/15536908/preference-activity-on-preference-click-listener
- SwitchPreference: http://stackoverflow.com/questions/18414267/switchpreference-and-checkboxpreference-in-code
http://developer.android.com/reference/android/preference/SwitchPreference.html - implements: http://stackoverflow.com/questions/19776889/android-preferncefragment-implements-onpreferenceclicklistener-never-invoked-on
- for loop: http://stackoverflow.com/questions/15536908/preference-activity-on-preference-click-listener
- Start activity: http://givemepass.blogspot.tw/2011/11/startactivitystartactivityforresult.html
- Start another activity: http://developer.android.com/training/basics/firstapp/starting-activity.html
- Start activity: http://cookiesp.pixnet.net/blog/post/84190702-android-intent%26bundle-%E5%82%B3%E9%81%9E%E8%B3%87%E6%96%99(%E5%8C%85%E5%90%AB%E5%82%B3%E9%81%9E%E8%87%AA%E5%AE%9A%E7%BE%A9%E7%89%A9
- Use getBaseContext() to get the context, if you use an inner class. The class can't set to static class.
http://www.androidadb.com/class/on/OnPreferenceClickListener.html - New Event : http://www.javaworld.com/article/2077351/java-se/events-and-listeners.html
- http://developer.android.com/reference/android/app/Activity.html
[Resource]
- Load string : http://www.connorgarvey.com/blog/?p=9
- Get resource : http://stackoverflow.com/questions/7493287/android-how-do-i-get-string-from-resources-using-its-name
- System resource : http://stackoverflow.com/questions/2631278/useful-android-system-resources
Yes (android.R.string.yes), No (android.R.string.no), Cancel (android.R.string.cancel) and Ok (android.R.string.ok).
[Action Bar]
[Bluetooth]
- BT : http://developer.android.com/guide/topics/connectivity/bluetooth.html#SettingUp
- Connect/Disconnect : http://stackoverflow.com/questions/3525753/android-bluetooth-connect-disconnect
[Contact]
- Contact List: http://developer.android.com/training/contacts-provider/retrieve-details.html
- find the name by phone number : http://stackoverflow.com/questions/3079365/android-retrieve-contact-name-from-phone-number
and enable the "android.permission.READ_CONTACTS"
[sqlite]
- 在Android中使用SQLite資料庫: http://blog.tonycube.com/2011/11/androidsqlite.html
- ADT : http://developer.android.com/sdk/installing/installing-adt.html
https://dl-ssl.google.com/android/eclipse/
- Support Library Features: https://developer.android.com/tools/support-library/features.html
- Support Library Setup : https://developer.android.com/tools/support-library/setup.html#
- 關於新版ADT創建項目時出現appcompat_v7的問題: http://jingyan.baidu.com/article/3ea51489e04eb852e61bbaa4.html
- No resource found: http://stackoverflow.com/questions/21900853/no-resource-found-theme-appcompat-light-darkactionbar
- http://blog.csdn.net/crazykbc/article/details/21553699
- 小俊工作室: http://jpress.tw/android-project-error-appcompat_v7-other-problem
- 正確導入android-support-v4.jar的方法: http://www.cnblogs.com/ada-zheng/p/3231944.html
- 安裝 Android Support Library: http://oldgrayduck.blogspot.tw/2013/10/android-support-library.html
[ioStream]
- Android:利用FileOutputStream & FileInputStream儲存資料: http://chihweiwu.blogspot.tw/2012/07/androidfileoutputstream-fileinputstream.html
- inputstream: http://developer.android.com/reference/java/io/InputStream.html
size : in.avaliable() : http://stackoverflow.com/questions/1119332/i-need-to-know-the-size-of-an-inputstream-java - Fileinoutstream: http://developer.android.com/reference/java/io/FileInputStream.html
- input/output stream: http://blog.csdn.net/dww410/article/details/5399094
- write: http://stackoverflow.com/questions/1477269/write-a-binary-downloaded-file-to-disk-in-java
- Notification: http://www.oschina.net/question/234345_40111
[ListView]
- 如何使用ListView: http://givemepass.blogspot.tw/2011/11/listview.html
- http://blog.joomla.org.tw/android/178-ListView%E4%B9%8B%E4%B8%80%EF%BC%9AAdapter%E4%BB%8B%E7%B4%B9%E8%88%87%E4%BD%BF%E7%94%A8.html
- Developer: http://developer.android.com/guide/topics/ui/layout/listview.html
- 使用 ListView 和 ListActivity: http://blog.changyy.org/2012/05/android-listview-listactivity.html
- sample_list_item2 : http://stackoverflow.com/questions/11256563/how-to-set-both-lines-of-a-listview-using-simple-list-item-2
[Time]
- Current time: http://stackoverflow.com/questions/5369682/get-current-time-and-date-on-android
- Sleep : http://stackoverflow.com/questions/3342651/how-can-i-delay-a-java-program-for-a-few-seconds
- Sleep, wait : http://moodlove.blog.hexun.com.tw/84012935_d.html
- Delay - write a callback function for system call: http://tdyapp.blogspot.tw/2013/04/androiddelay.html
http://cooking-java.blogspot.tw/2010/04/android-timer.html - Thread.sleep, http://developer.android.com/reference/android/os/SystemClock.html
- sendMessageDelayed: http://stackoverflow.com/questions/5565826/android-thread-problem
- 如何寫一個倒數計時器(CountDownTimer) : http://givemepass.blogspot.tw/2011/12/blog-post_08.html
http://developer.android.com/reference/android/os/CountDownTimer.html - Format: http://developer.android.com/reference/java/text/SimpleDateFormat.html
- java日期格式大全 format SimpleDateFormat: http://eternal1025.iteye.com/blog/344360
- Enum DateTimeFormat: https://developers.google.com/apps-script/reference/ui/date-time-format
- Standard Date and Time Format Strings: http://msdn.microsoft.com/en-us/library/vstudio/az4se3k1(v=vs.100).aspx
- Scripts Language Codes: https://www.softaculous.com/docs/Scripts_Language_Codes
[Activity]
- 如何使用startActivity與startActivityForResult: http://givemepass.blogspot.tw/2011/11/startactivitystartactivityforresult.html
- Control camera: http://developer.android.com/training/camera/cameradirect.html
- Control the default music player of android or any other music player: http://stackoverflow.com/questions/18800198/control-the-default-music-player-of-android-or-any-other-music-player
[Mulit-language]
- Out of memory: http://www.trinea.cn/android/android-image-outofmemory-bitmap-size-exceeds-vm-budget/
- Working With Images In Android: http://www.higherpass.com/Android/Tutorials/Working-With-Images-In-Android/2/
[BLE]
- GKI_exception: https://code.google.com/p/android/issues/detail?id=65455
[ioStream]
- SequenceInputStream: http://developer.android.com/reference/java/io/SequenceInputStream.html
- ByteArrayInputStream: http://developer.android.com/reference/java/io/ByteArrayInputStream.html
- Action Bar and Tab Icon Generator: http://romannurik.github.io/AndroidAssetStudio/icons-actionbar.html#source.space.trim=1&source.space.pad=0&name=ic_action_example&theme=light&color=33b5e5%2C60
- Android Asset Studio: http://romannurik.github.io/AndroidAssetStudio/
- Iconography : http://developer.android.com/design/style/iconography.html
- Icon download : http://developer.android.com/design/downloads/index.html
- system icon : http://stackoverflow.com/questions/3201643/how-to-use-default-android-drawables
- http://www.darshancomputing.com/android/1.5-drawables.html
- sdk folder : http://www.mxtutorial.com/2012/12/pre-defined-android-drawables-icons.html
[ResolveInfo]
- ResolveInfo: http://developer.android.com/reference/android/content/pm/ResolveInfo.html
- 獲取手機中已安裝apk檔資訊: http://fecbob.pixnet.net/blog/post/38385109-%E3%80%90android%E3%80%91%E7%8D%B2%E5%8F%96%E6%89%8B%E6%A9%9F%E4%B8%AD%E5%B7%B2%E5%AE%89%E8%A3%9Dapk%E6%AA%94%E8%B3%87%E8%A8%8A(packageinf
- PackageManager: http://developer.android.com/reference/android/content/pm/PackageManager.html#getInstalledApplications%28int%29
- ComponentName : http://developer.android.com/reference/android/content/ComponentName.html
[publish]
- 透過臺灣網域註冊管理中心為您上架APP: http://www.webmobi.com.tw/push-android-app-google-play-market/
- [android]android 上架與發佈常見問題: http://www.dotblogs.com.tw/blackie1019/archive/2013/08/15/114521.aspx
- Google play的上架教學來了: http://wtwdesign.blogspot.tw/2013/08/google-play.html
- BMI: https://code.google.com/p/androidbmi/wiki/AndroidMarket
- http://gamecloud.lager.com.tw/doc_iab.php
- 第一支app上架後學到的經驗: http://www.inside.com.tw/2012/03/03/app-marketing
- Get Started with Publishing: http://developer.android.com/distribute/googleplay/start.html
- log : adb shell logcat -v time -s ACT STATUS FoxlinkService Check_service_uart > log_FB.txt
- Password can't do the autofill/autocompelete
setSavePassword(boolean save)
This method was deprecated in API level 18. Saving passwords in WebView will not be supported in future versions.
http://developer.android.com/reference/android/webkit/WebSettings.html - HTML autocomplete Attribute: http://www.w3schools.com/tags/att_input_autocomplete.asp
- class : http://developer.android.com/reference/android/webkit/WebView.html
- Disabling autosuggestion on WebView?: http://stackoverflow.com/questions/7404798/disabling-autosuggestion-on-webview
- Calling Web Services in Android using HttpClient: http://lukencode.com/2010/04/27/calling-web-services-in-android-using-httpclient/
[Random]
- Random : http://developer.android.com/reference/java/util/Random.html
- Android中利用Random生成隨機數: http://blog.csdn.net/lfdfhl/article/details/17786747
BT
Posted on June 10th, 2014
[Reference]
- how to open bluetooth settings in android?: http://stackoverflow.com/questions/13911468/how-to-open-bluetooth-settings-in-android
Intent intentOpenBluetoothSettings = new Intent();
intentOpenBluetoothSettings.setAction(android.provider.Settings.ACTION_BLUETOOTH_SETTINGS);
startActivity(intentOpenBluetoothSettings); - REQUEST_ENABLE_BT:
http://www.cool3c.com/article/27452
http://www.crifan.com/android_bluetooth_sample_code_can_not_found_request_enable_bt/ - BluetoothAdapter : http://developer.android.com/reference/android/bluetooth/BluetoothAdapter.html#ACTION_CONNECTION_STATE_CHANGED
- android BT: http://developer.android.com/guide/topics/connectivity/bluetooth.html#SettingUp
- Connected/Disconnected : http://stackoverflow.com/questions/19584423/how-to-check-if-bluetooth-connection-to-a-device-is-disconnected
[Connect]
[Profile]- AVRCP (Audio/Video Remote Control Profile): http://www.techbang.com/posts/3050--avrcp-bluetooth-cell-phone-headset-is-so-controlled
覺得用藍牙耳機控制音樂手機的上、下首、播放、停止和音量很有趣嗎？這是因為在藍牙技術協定中包含了AVRCP這個協定。它提供了搖控裝置一個標準的控制介面，讓你可以用一支遙控器或耳機等遙控裝置搖控你所有的電視、電腦或是手機的音訊和視訊介面 - webrtc : http://www.webrtc.org/reference/getting-started#TOC-Linux-Android-Specific-Steps
Action Bar
Posted on June 10th, 2014
[Resources]
- Styling the Action Bar: https://developer.android.com/training/basics/actionbar/styling.html
parent="@android:style/Theme.Holo.Light.DarkActionBar">
- @style/MyActionBar
parent="@android:style/Widget.Holo.Light.ActionBar.Solid.Inverse">
- @drawable/actionbar_background
When you crate a new action bar project, add the red portion to your new project.
(If you get error during compiling.)
Eclipse
Posted on June 6th, 2014
[Android SDK Samples]
[Others]
- Import the project from SDK : https://groups.google.com/forum/#!topic/android-beginners/Y1bTqc61tQU
Select "Create project form existing source" and then all the fields will
autopopulate when you select the ApiDemos folder. - Fix build error : http://stackoverflow.com/questions/4298155/compiling-and-running-apidemos
http://rickiedroid.blogspot.tw/2011/02/add-open-sdk-apidemos-work-with-your.html
I had the same problem and this is my solution.
Uncheck "Build automatically" in the menu "project"
Select "Clean" from menu "project".
Select "Clean projects selected below" and check "ApiDemos".
Check "Start a build immediatly", "Build only the selected projects"
- http://stackoverflow.com/questions/15684183/how-can-i-make-a-child-package-inside-a-package-in-eclipse-project-explorer
Add new package -> Add new class - use external jar : http://stackoverflow.com/questions/1334802/how-can-i-use-external-jars-in-an-android-project
- EGit: http://my.oschina.net/China2012/blog/174874
- Delete project fail :
- Delete the project first, but get failed.(.git/gen folder can't be deleted.)
- Close Eclipse , and delete the .git and folder. Do it again.
- Delete the project first, but get failed.(.git/gen folder can't be deleted.)
Clone project from git server
- Import | Git | Project from Git or Click the button from the toolbar.
- Select the repository from URL
- Use ssh to connect to git serverssh://username@IP_address/Repository_pathexample : ssh://username@10.8.70.13/data/git/SmartWatch_Android
- Enter the password
- Set the local directory
- Import as an existing projects
Create a new package
Create a new class
- The git clone project path is : C:\Users\Administrator\git\SmartWatch_Android , need to select the
- Set the user name : Menu | Windows | Preference
http://wiki.eclipse.org/EGit/User_Guidehttp://stackoverflow.com/questions/10663492/how-to-change-default-author-and-commiter-in-eclipse-git-plugin
- Workspace in use or cannot be created : http://stackoverflow.com/questions/8489322/eclipse-says-workspace-in-use-or-cannot-be-created-chose-a-different-one-ho
Just delete the .lock file in the .metadata directory in your eclipse workspace directory. - aapt error in Eclipse? : http://stackoverflow.com/questions/7198905/how-to-diagnose-error-executing-aapt-error-in-eclipse
http://stackoverflow.com/questions/22275836/eclipse-android-error-executing-aapt-return-code-138-nothing-i-do-seems-to-fi
[Upgrade]
- 如何無痛升級Eclipse版本(保留所有plugins設定): http://www.ewdna.com/2013/11/Eclipse-Upgrade-Version.html
C:\Program Files\eclipse - http://stackoverflow.com/questions/11514883/conflicting-dependencies-while-installing-adt-plugin-for-eclipse-helios
- 如何從 Eclipse 4.2 升級到 4.3: http://blog.nami.idv.tw/?p=471
- FAQ How do I upgrade Eclipse?: http://wiki.eclipse.org/FAQ_How_do_I_upgrade_Eclipse%3F
- Use "ctrl + 7 " to make the comment and un-comment the source code.
http://stackoverflow.com/questions/5534748/eclipse-comment-uncomment-shortcut - Toggle comment: http://reference.wolfram.com/workbench/index.jsp?topic=/com.wolfram.eclipse.help/html/tasks/comments.html
[Plugin]
