JSP Jasper Report Configuration on Eclipse IDE

Hi!

      Today i am going to explain about the Jasper report and how to configure it on eclipse IDE,  Most common application are need to export the table data

About Jasper:

JasperReports is an open source Java reporting tool that can write to a variety of targets, such as: screen, a printer, into PDF, HTML, Microsoft Excel, RTF, ODT, Comma-separated values or XML files.

It can be used in Java-enabled applications, including Java EE or web applications, to generate dynamic content. It reads its instructions from an XML or .jasper file.

How to Install Jasper Plugin on Eclipse IDE :

Open Eclipse -> Help -> Eclipse Marketplace ->

Type & Search "Jasper"  and install the "Jaspersoft Studio"

Notes: The current version is Jasper6.3.1

now restart your IDE.

Steps to Configure Jasper :

1. Goto your project -> WebContent -> WEB-INF ->
2.  (Right Click) -> New -> Others ->
3. Type and search "Report" -> select "Jasper Report" -> choose Blank template -> enter report name ->
4. Create Adapter (Have to create a Data Adapter for 1st time) -> New -> Data base JDBC connection -> enter JDBC Driver name, URL, Username & Password -> Test Connection -> finish
5. Choose cerated Adapter - > Next - > Enter Your Query -> Move the required fields from Left-to-Right -> next -> Next -> Finish
6. By open the Outline Prespective to set the Fields & Values
7. You may custom the design by your creativity.
8. To check the report open your report and preview it.
9. To convert from .jrxml into .jasper. you should compile the report by select the compiler icon.

Now you have successfully configure the Jasper..,

Notes: On my next post will show how to export as Excel and PDF with samples.

Thanks..,

By -  A.SelvaRaj..,

Custom Date Picker in java

Hi!

                 Like php,android,etc.., their is no UI for Date Picker in Java we have to build manually by calling java.util.Calendar class,

now i place my own date picker as a .jar file. Now you can download and add this jar into your project..,

You can Download Here..,


How to use it!

• Assign variable for ui,
• Create an object,
• Call the datepicker class directly.

JLabel register_date = new JLabel();

register_date.setText(new DatePicker(NewJFrame).setPickedDate());


Thank You..,

How to Configure Eclips-Weblogic Server

Hi!


I show how the simple way to configure Eclipse - weblogic Server..,

watch it & fallow it..,

Thank You..,

Upload Data from .CSV Formate into Data Base

Hi!


In previous blog i show how to download data from database into Excel / .csv formate.
Now in this blog i show you how to Upload the data from .csv formate into database.

.CSV formate is one of the secured formate to save data.

here i give an example code how to convert it.

i am using apache poi external jar for this process.

You can download from apache site.

simply i am calling the record from the MySQL Server, while if it is true then i pass those result-set through the poi


have to pass the header of your .csv column and align your column and the row

Statement stmt;

    String query;    try {        Class.forName("com.mysql.jdbc.Driver");        Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/readmain", "root", "root");        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);        String dds = JOptionPane.showInputDialog(null, "Enter FileName To Load", "");        if (!dds.equals("")) {            String fn = "C:/" + dds + ".csv";            query = "LOAD DATA INFILE '" + fn + "' INTO TABLE salarydet FIELDS TERMINATED BY ',' (EmployeeId,Saldate,Basic,Additionalpay,Spl,Other,Leavem,Gross,Netsal,Laveded,Loanamt,Festiveladv,Traveladv,Salaryadv,Othersded,Totded,Insurance)";            stmt.executeUpdate(query);            JOptionPane.showMessageDialog(null, "Uploaded Sceeceefully");        } else {

            JOptionPane.showMessageDialog(null, "Check Your File Please");

        }

    } catch (Exception r) {

        JOptionPane.showMessageDialog(null, "Check Your File Please");

    }

Thank You!

Have A Happy Day..,

Convert / Download Data from Data Base into .CSV Formate

Hi!


In this blog i show you how to convert the data from database into .csv formate.

.CSV formate is one of the secured formate to save data.

here i give an example code how to convert it.

i am using apache poi external jar for this process.

You can download from apache site.

simply i am calling the record from the MySQL Server, while if it is true then i pass those result-set through the poi


have to pass the header of your .csv column and align your column and the row


try {
        DateFormat format = new SimpleDateFormat("dd/MM/yyyy");        java.util.Date date = format.parse(new DatePicker(NewJFrame).setPickedDate());        java.sql.Date sqlD = new java.sql.Date(date.getTime());        Class.forName("com.mysql.jdbc.Driver");        Connection connn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/readmain", "root", "root");        PreparedStatement ps100 = connn.prepareStatement("select Saldate from salarydet where Saldate ='" + sqlD + "'");        ResultSet rs100 = ps100.executeQuery();        if (rs100.next()) {            try {                Class.forName("com.mysql.jdbc.Driver");                Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/readmain", "root", "root");                String mn = JOptionPane.showInputDialog(null, "Enter File Name", "");
                if (!mn.equals("")) {
                    String mnd = "C:/" + mn + ".CSV";
                    Object dd = gtempid.getSelectedItem();
                    PreparedStatement ps = conn.prepareStatement("SELECT * INTO OUTFILE '" + mnd + "' FIELDS TERMINATED BY ',' FROM salarydet where Saldate ='" + sqlD + "';");
                    ps.executeQuery();
                    conn.close();
                    JOptionPane.showMessageDialog(null, " CSV File Saved On c:/");
                } else {
                    JOptionPane.showMessageDialog(null, "Enter Valid File Name");
                }
            } catch (Exception r) {
                JOptionPane.showMessageDialog(null, "Process Is Canceled & Check Your File Name");
            }
        } else {
            JOptionPane.showMessageDialog(null, "Select Correct Date Please");
        }
    } catch (Exception e) {
    }

Thank You!..,

Convert / Download Data from Data Base into Excel Formate

Hi!


Commonly facing an issue to convert the data from database into Excel formate.


here i give an example code how to convert it.

i am using apache poi external jar for this process.

You can download from apache site.

simply i am calling the record from the MySQL Server, while if it is true then i pass those result-set through the poi


have to pass the header of your excel column and align your column and the row



try 
   { 
HSSFWorkbook xlsWorkbook = new HSSFWorkbook();                      HSSFSheet xlsSheet = xlsWorkbook.createSheet();                short rowIndex = 0;                Class.forName("com.mysql.jdbc.Driver"); 
Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/readmain", "root", "root");
PreparedStatement stmt = conn.prepareStatement("select EmployeeId,Name,Department,Designation,Branch,DATE_FORMAT(Saldate, '%d/%m/%Y') as Saldate,LeaveTaken,Basic,Additionalpay,Spl,Other,Gross,Netsal,Insurance,Laveded,Loanamt,Festiveladv,Traveladv,Salaryadv,Othersded,Totded from newsal where EmployeeId ='" + ide + "' ORDER BY Saldate desc");// ORDER BY Saldate desc");
                ResultSet rs = stmt.executeQuery();
                ResultSetMetaData colInfo = rs.getMetaData();
                List<String> colNames = new ArrayList<String>();
                HSSFRow titleRow = xlsSheet.createRow(rowIndex++);
                for (int i = 1; i <= colInfo.getColumnCount(); i++) {
                    colNames.add(colInfo.getColumnName(i));
                    titleRow.createCell((short) (i - 1)).setCellValue(
                            new HSSFRichTextString(colInfo.getColumnName(i)));
                    xlsSheet.setColumnWidth((short) (i - 1), (short) 4000);
                }
                while (rs.next()) {
                    HSSFRow dataRow = xlsSheet.createRow(rowIndex++);
                    short colIndex = 0;
                    for (String colName : colNames) {
                        dataRow.createCell(colIndex++).setCellValue(
                                new HSSFRichTextString(rs.getString(colName)));
                    }
                }
                String mn = JOptionPane.showInputDialog("Enter File Name To Save On C:/Excell/", "");
                if (!mn.equals("")) {
                    xlsWorkbook.write(new FileOutputStream(new File("C:/Excell/" + mn + ".xls")));
                    JOptionPane.showMessageDialog(null, mn + " Is Save On C:/Excell/");
                    conn.close();
                } else {
                    JOptionPane.showMessageDialog(null, "Enter File Name");
                }
            } catch (Exception r) {
                JOptionPane.showMessageDialog(null, "You Cancell The Process");
            }


        } else {
            JOptionPane.showMessageDialog(null, "Enter Valid ID Please");
        }
    } 

now you can easily download your record's into excel formate.

Thank You!

Have A happy Day..,