SQL Concept

SQL Joins

Table Join

SQL Equivalent Syntax

Inner , Outer , Cross

Outer Join , Left Outer , Right Outer

 Left Join and Left Outer Join Tip !!!

Right Join and Right Outer Join Tip !!!

References : 

1.difference between inner and outer joins

http://stackoverflow.com/questions/38549/difference-between-inner-and-outer-joins

2.sql join and different types of joins

http://stackoverflow.com/questions/17946221/sql-join-and-different-types-of-joins

3.left join and left outer join in sql server

http://stackoverflow.com/questions/406294/left-join-and-left-outer-join-in-sql-server

Android Sensors

Location provider Requires 

android.permission.ACCESS_COARSE_LOCATION android.permission.ACCESS_FINE_LOCATION

LocationManager

GetSystemService(Context.LOCATION_SERVICE)

หลังจากที่ลงทะเบียน จะได้รับตำแหน่งของผู้ใช้ที่ทราบล่าสุด, การอัพเดตสถานที่ หรือได้รับ intents เมื่อเกิดการแบ่ง หรือย้ายออกจากพื้นที่ทางภูมิศาสตร์

LocationListener

อินเตอร์เฟซที่กำหนด วิธีการ callback methods เมื่อมีการเปลี่ยนแปลงสถานที่ หรือการเปลี่ยนแปลงสถานะของ location Provider

Void onLocationChanged(Location location) 

Void onLocationChanged(Location location) 

Void onProviderDisabled(Stringprovider) 

Void on ProviderEnabled(Stringprovider) 

Getting location

Reference systems

•X axis: อยู่ในแนวนอนและชี้ไปทางขวา

•Y axis: อยู่ในแนวตั้งและชี้ขึ้น

•Z axis: ชี้ไปทางด้านนอกของด้านหน้าของหน้าจอ

Sensor Type

Software architecture

Reading magnetic field

 Reading acceleration

Reading the position

Android libraries

•android.app
–Provides access to the application model and is the cornerstone of all Android applications.

•android.content
–Facilitates content access, publishing and messaging between applications and application components.

•android.database
–Used to access data published by content providers and includes SQLite database management classes.

•android.graphics
–A low-level 2D graphics drawing API including colors, points, filters, rectangles and canvases.

•android.hardware
–Presents an API providing access to hardware such as the accelerometer and light sensor.

•android.opengl
–A Java interface to the OpenGL ES 3D graphics rendering API.

•android.opengl
–A Java interface to the OpenGL ES 3D graphics rendering API.

•android.os
–Provides applications with access to standard operating system services including messages, system services and inter-process communication.

•android.media
–Provides classes to enable playback of audio and video.

•android.net 
–A set of APIs providing access to the network stack. Includes android.net.wifi, which provides access to the device’s wireless stack.

•android.provider
–A set of convenience classes that provide access to standard Android content provider databases such as those maintained by the calendar and contact applications.

•android.text
–Used to render and manipulate text on a device display.

•android.util
–A set of utility classes for performing tasks such as string and number conversion, XML handling and date and time manipulation.

•android.view
–The fundamental building blocks of application user interfaces.

•android.widget
-A rich collection of pre-built user interface components such as buttons, labels, list views, layout managers, radio buttons etc.

•android.webkit
–A set of classes intended to allow web-browsing capabilities to be built into applications

Key Point : User Interface for Mobile App

ปัจจัยความหลากหลายของขนาดจอ
1.) Brand ของผู้ผลิด
2.) Density Screen
3.) อัตราส่วนของจอ

หน่วยที่ใช้ในการวัด 
1.) Pixel (px)
2.) Inches (in)
3.) Millimeter (mm)
4.) Point (pt)
5.) Scale Independent Pixels (sp)
6.) Density Independent Pixels (dp)

Screen Size
1.) small (426dp x 320dp)
2.) normal (470dp x 320dp)
3.) large (640dp x 480dp)
4.) xlarge (960dp x 720dp

Density Screen
1.) ldpi   <= 140dpi
2.) mdpi  140dpi --- 186.5dpi
3.) tvdpi  186.5dpi  ---  227dpi
4.) hdpi  227dpi  ---  280dpi
5.) xhdpi  280dpi  ---  400dpi
6.) xxhdpi  >= 400dp

Orientation

1.) Portrait 

2.) Landscape

3.) Square

Alternative Drawable

1.) hdpi : 6/4 

2.) ldpi : 3/4 

3.) mdpi : 1 

4.) xhdpi : 8/4

Density Independent (dp)

dp = px * 160/dpi 

px = dp *dpi/160

ไม่ Fix ขนาด Widget

• wrap content 

• fill parent 

• match parent

Resource Directory

• layout 

• values

การใช้งาน iReport Designer for JasperReports

How to Connect to a Database Or a Data Source using iReport

การเชื่อมต่อ iReport เพื่อออกรายงานจาก MySQL หรือ Oracle ในขั้นตอนแรก เราจะต้องมี Driver ซึ่ง iReport ก็จะมีรายชื่อ Driver เพื่อเตรียมพร้อมให้เราเลือกใช้งานแล้วแหละ...

Connecting to MySQL

Set your server path and data base name in the JDBC URL Wizard. Then Click Wizard and it will automatically set your JDBC URL. Make Sure you have selected the com.mysql.jdbc.Driver and Type the User name and password to the database and click Test.

Your Data base connection should be working properly. If not check your MySQL database URL is correct or/and the database server is running properly. If the test is Successful click Save.

Connecting to Oracle Database.

As I mentioned above iReport does not have a Oracle JDBC driver included. To Connect to Oracle you need to have a Oracle JDBC Driver compliant with your Oracle Version. They can be found here. I’ve used ojdbc14.jar with Oracle 9i and 10i.

Place the Oracle JDBC Driver in your lib directory. If you have installed using the default settings this would be in the c:/Programfiles/jaspersoft/ireport2.0.5 directory

Set your Server Path and the database name in the JDBC URL wizard. Then click “Wizard” button and the Database URL would be set WITH THE PORT 1521. If you are not using that simply modify it to the port u are using in the JDBC URL Field. Type the User name and password to the database.

Set the JDBC Driver Field to “oracle.jdbc.driver.OracleDriver” and click test. If not successful check your username/password and Database URL and Try again. After the test is successful click Save.

Now you are ready to start designing a report.

Steps to set the Classpath for iReport:

1) go to "Tools / Options" menu and select iReport

2) verify that database JDBC driver is present:

- Choose "Classpath" tab

- Click "Add JAR" and then locate the mysql.jdbc.Driver

- Click "OK"

3) click "Connections / Datasources" icon in toolbar

4) click "New" and set up a "Database JDBC Connection" using driver from step 2

5) click "Test" to verify the data source works correctly

6) click "Save" to save the data source

Step 1 : How to use iReport Designer for JasperReports (Step by Step)
http://www.thaicreate.com/java/java-gui-ireport.html

วิธีเชื่อมต่อ Database
Step 2 : Create iReport JasperReports and Database Connection
http://www.thaicreate.com/java/java-gui-ireport-database-connection.html

วิธีทดสอบและออกแบบ Report
Step 3 : iReport Create Design Report Wizard and Preview Report (Step by Step)
http://www.thaicreate.com/java/java-gui-ireport-create-report.html

วิธีสร้าง Applet เพื่อทดสอบส่งค่าพารามิเตอร์ไปหา Report
Step 4 : Java GUI : Connect and Viewer/Preview iReport (JasperReport)
http://www.thaicreate.com/java/java-gui-ireport-viewer-preview.html

วิธีสร้าง JFrame/JPanel แล้วส่งพารามิเตอร์จาก Java มาที่ Report
Step 5 : Java GUI : Viewer/Preview iReport on JFrame/JPanel
http://www.thaicreate.com/java/java-gui-ireport-viewer-preview-jframe-panel.html

วิธีส่งค่าพารามิเตอร์ไปหา Report
Step 6 : Java GUI : iReport Create Parameters and Pass Variable
http://www.thaicreate.com/java/java-gui-ireport-parameters.html

jaspersoft mongodb query language
http://community.jaspersoft.com/wiki/jaspersoft-mongodb-query-language
http://www.slideshare.net/marianolu/using-jaspersoft-with-mongodb

how do i perform the sql join equivalent in mongodb
http://stackoverflow.com/questions/2350495/how-do-i-perform-the-sql-join-equivalent-in-mongodb

jaspersoft mongodb query language
http://community.jaspersoft.com/wiki/jaspersoft-mongodb-query-language
http://www.slideshare.net/marianolu/using-jaspersoft-with-mongodb

how do i perform the sql join equivalent in mongodb
http://stackoverflow.com/questions/2350495/how-do-i-perform-the-sql-join-equivalent-in-mongodb

Fix Access denied for user 'root'@'localhost' for phpMyAdmin
http://stackoverflow.com/questions/19482371/fix-access-denied-for-user-rootlocalhost-for-phpmyadmin

Bootstrap ที่น่าสนใจ สำหรับใช้งาน Mobile Application

Start Bootstrap
http://startbootstrap.com/

Bootswatch
http://bootswatch.com/

Black Tie
http://www.blacktie.co/

Bootstrap Zero
http://bootstrapzero.com/

Bootplus
http://aozora.github.io/bootplus/

Fbootstrapp
http://ckrack.github.io/fbootstrapp/

Bootmetro
http://aozora.github.io/bootmetro/

GetTemplate
http://www.gettemplate.com/

Cardeostrap
http://cardeostrap.cardeo.ca/

VegiThemes
http://vegibit.com/vegithemes-twitter-bootstrap-themes/

Bootstrap Taste
http://bootstraptaste.com/