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

การใช้งาน 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