Thursday 26 September 2013

How to create pdf file through database using iReport

Let's create pdf file through database using iReport tool. So proceed the following steps.

 

Requirements:

Tool:- JasperSoft iReport-4.7.0

Database:- Oracle 10g (Choose as your own database)

 

1)  Create table  in your database like below  

create table Emp(ID NUMBER(10),NAME VARCHAR2(20));
 

insert into emp values(10,'satyam');
insert into emp values(20,'pallavi');

 

 

 

2)  Here we are using Oracle database. So we need to import the "ojdbc14.jar" file to our iReport tool. For that we have to proceed the following steps 

         

     a) Select the Tools >> Options

 

         

 b)  In the next step select the classpath then click on  "Add JAR" button  for       selecting the ojdbc14.jar file.

 

 

            c) Select the ojdbc14.jar file from the list and then click OK button to load in to the iReport tool.

 

 

3)  For creating a database connection or setup proceed the following steps

         a) Click on the Report  Datasources.

 

 

       b)  Click on New button


          

      c)  Select Database JDBC connection and then click Next > button

 

        

     d)  Fill the following fields and then click on Test button for testing the database connection.

 

 

      e) Select your Datasource from the list


 

4)  For creating a new report click on icon to run the report wizard

 

       

    a) In the next step a window appears select report choose as your own page eg.(Blank A4). Then click on Open this Template button.

 


     b)  In the next step fill the fields then click on Next button

 

 

5)  Click on Report query button and write the query 

 



6)  Create Employee Report using drag and drop with field names

 

 

7)  After complete designing click on preview button then save with different file types like (.pdf, .xls, .html, .CSV and so on...). Here below file is saved in pdf format.


 

 8)  Three file formats will be generate in your given location 

 


Monday 16 September 2013

iPhone 5s features and specifications

iPhone 5S

Overview :

iPhone 5S is the first 64-bit smartphone in the world. It is available in silver, gold and 'space grey', iPhone 5s features an A7 chip, a Touch ID fingerprint identity sensor, ultra-fast wireless, an iSight camera with a larger 8MP sensor and iOS 7.


Capacity :

16GB, 32GB
and 64GB

Colour

silver, gold, space grey

Chips :

A7 chip with 64-bit architecture + M7 motion co-processor.
There’s fast. And then there’s A7 fast. The new A7 chip gives you CPU and graphics performance up to 2x faster than the A6 chip.


Connectivity :

GSM model: GSM/EDGE, UMTS/HSPA+, DC-HSDPA, CDMA model: CDMA EV-DO Rev. A and Rev. B, LTE, WiFi (802.11a/b/g/n; 802.11n on 2.4GHz and 5GHz), Bluetooth 4.0, GPS and GLONASS

Fingerprint Sensor :



 
 Yes

Display :

 4-inch (diagonal) Retina display, 1136x640 resolution, 326 ppi

iSight Camera :

8 megapixels with 1.5µ pixels, /2.2 aperture, Sapphire crystal lens cover, True Tone flash, Backside illumination sensor, Five-element lens, Hybrid IR filter, Autofocus, Tap to focus, Face detection, Panorama, Burst mode, Photo geotagging
  
Video recoding :

1080p HD video recording, 30 fps, True Tone flash, Slo-mo video, Improved video stabilisation, Take still photos while recording videos, Face detection, 3x zoom, Video geotagging, Tap to focus

FaceTime Camera :

1.2MP photos (1280x960), 720p HD video recording, New backside illumination sensor 

Video calling : 

FaceTime, iPhone 5s to any FaceTime-enabled device over Wi‑Fi or a mobile network, Initiate video calls over LTE, DC-HSDPA, HSPA+, 3G and 2G, HVGA-resolution (480x368) calls over WiFi

Siri intelligence Assistance :

YES   


Power and Battery :

Built-in rechargeable lithium-ion battery, Charging via USB to computer system or power adapter, Talk time: up to 10 hours on 3G, Standby time: up to 250 hours, Internet use: up to 8 hours on 3G, up to 10 hours on LTE, up to 10 hours on WiFi, Video playback: up to 10 hours, Audio playback: up to 40 hours

Head Phones :

 Apple EarPods with Remote and Mic, Storage and travel case 


Sensors :    

Three-axis gyro, Accelerometer, Proximity sensor, Ambient light sensor, Fingerprint identity sensor 

SIM Card :  

Nano-SIM

Connector :

Lightning

  
Price :

16GB-$199   

32GB-$299 

64GB$399