way to take printout from mysql

[raj.mscking@gmail.com]

Thanks For Your help on my previous forum's sir!

i am going to complete my software sir,this is my 1st complete work,
But! in the final step i wants to take paper printout from database,

In DataBase is in the form of

EmployeeId	Saldate	Basic	Additionalpay	Spl	Other	Leavem	Gross	Netsal	Laveded	Loanamt	Festiveladv	
108	2012-05-26	120000	0	0	0	0	120000	112000	-4000	0		8000	12000

But i want to in the form of (Example only)




i need at least 3 pay slip per page when i pass the EmployeeId's


I need your idea, i am new for this all. But i have confidence. If you guide me i can do this Perfectly..,

Help Me Please Sir..,
I am waiting for your response..,

Thank You sir..,

[wsaryada]

How would you implement the payslip? Is a plain text? I don't think so from the screen shot you've post. Is it a PDF document or is it in HTML or even an excel document. Please give us some more information.

[raj.mscking@gmail.com]

Sorry For The Late Replay Sir!

Thank you for your response sir..,

Code for Action Listener is..,

private void jLabel113MouseClicked(java.awt.event.MouseEvent evt) {                                       
// TODO add your handling code here:
     PrinterJob job = PrinterJob.getPrinterJob();
         job.setPrintable(this);
         boolean ok = job.printDialog();
         if (ok) {
             try {
                  job.print();
             } catch (PrinterException ex) {
              /* The job did not successfully complete */
             }
         }
         jLabel113.setVisible(false);
         jLabel114.setVisible(false);
}

Code For print method is..,

public int print(Graphics g, PageFormat pf, int page) throws PrinterException {
 
        if (page > 0) { 
            return NO_SUCH_PAGE;
        }
        Graphics2D g2d = (Graphics2D)g;
        g2d.translate(pf.getImageableX(), pf.getImageableY());
 try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection connn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/payslip", "root", "root");
        PreparedStatement ps100 = connn.prepareStatement("select EmployeeID from newemp where EmployeeID =?");
        ps100.setString(1, gtempid.getText());
        ResultSet rs100 = ps100.executeQuery();
        if (rs100.next()) {
            String id = rs100.getString(1);
            if(true) {
               PreparedStatement ps1 = connn.prepareStatement("select s.EmployeeId,s.Saldate,"
                       + "s.Basic,s.Additionalpay,s.Spl,s.Other,s.Leavem,"
                       + "s.Gross,s.Netsal,s.Laveded,s.Loanamt,s.Festiveladv,"
                       + "s.Traveladv,s.Salaryadv,s.Othersded,s.Totded,s.Insurance,"
                       + "e.Designation,e.Name,e.Department,e.Branch from salarydet s,"
                       + "newemp e where s.EmployeeId=e.EmployeeID and s.EmployeeId=?");
                ps1.setString(1, id);
                ResultSet rs = ps1.executeQuery();
                if (rs.next()) {
                    String lv=(rs.getString(7));
            int ll=(Integer.valueOf(lv)-1);
            String mm=(String.valueOf(ll));
            String nn;
            
            if(ll==-1)
            {
                nn="Didn't Taken Any Leave";
            }
            else if(ll==-0)
            {
                nn="Taken 1 Day";
            }
            else
            {
                nn=(lv+" - 1 = "+ll);
            }
                    g.drawString("                             READ                ",200,20);  
                    g.drawString("===============================================================",100,30);
                                     
                   g.drawString("                            PAY SLIP                                   ",200,40);
                  
                   g.drawString("===============================================================",100,50);
                    
                    g.drawString("Employee Name  : "+rs.getString(19),100,60);g.drawString("Salary Date                 : "+df.format(rs.getDate(2)),350,60);
                    g.drawString("Employee ID        : "+rs.getString(1),100,70);g.drawString("Leave For This Month : "+nn,350,70);
                    g.drawString("Department          : "+rs.getString(20),100,80); g.drawString("Designation                 : "+rs.getString(18),350,80);
                    g.drawString("Branch                 : "+rs.getString(21),100,90);
                   // g.drawString();
                    g.drawString("===============================================================",100,100);
                    g.drawString("Gross Salary",100,110);     g.drawString("Amount",250,110); g.drawString("Deduction",330,110); g.drawString("Amount",480,110);
                    g.drawString("===============================================================",100,120);
                    //g.drawString();
                    g.drawString("Basic              ",100,130); g.drawString(rs.getString(3),250,130);g.drawString("Insurance",330,130);g.drawString(rs.getString(17),480,130);
                    g.drawString("Additional Pay",100,140);g.drawString(rs.getString(4),250,140);g.drawString("Leave Dedection",330,140);g.drawString(rs.getString(10),480,140);
                    g.drawString("Special",100,150);g.drawString(rs.getString(5),250,150);g.drawString("Loan Amount",330,150);g.drawString(rs.getString(11),480,150);   
                    g.drawString("Others",100,160);g.drawString(rs.getString(6),250,160);g.drawString("Festival Advance",330,160);g.drawString(rs.getString(12),480,160);
                    g.drawString("Traval Advance",330,170);g.drawString(rs.getString(13),480,170);
                    g.drawString("Salary Advance",330,180);g.drawString(rs.getString(14),480,180);
                    g.drawString("Gross Salary",100,200);g.drawString(rs.getString(8),250,200);g.drawString("Others",330,190);g.drawString(rs.getString(15),480,190);
                    g.drawString("Net Salary",100,210);g.drawString(rs.getString(9),250,210);g.drawString("Total Deduction",330,210);g.drawString(rs.getString(16),480,210);
                      }
                           }
        } else {
            JOptionPane.showMessageDialog(null, "Enter Valid ID Please");
        }
connn.close();
    } catch (Exception e) {
        
        JOptionPane.showMessageDialog(null,e);
    }
        
        return PAGE_EXISTS;
    }

Output Is (By Printer)




Sir!

in my MySQL queries i mention only one number sir,,

But if i wants to taken more then one number (for example: ("select EmployeeID from newemp where date = '"+2012/06/06"') )

how to i set the printing option to take number of different employees salary slip

and

where & how to use loop in it..,

Can you guide me please sir..,
I am alway's waiting for your response sir..,
Thank you..,

[raj.mscking@gmail.com]

Anyone can Guide me please..,
I am waiting for your response sir..,
Thank you..,

[Tolls]

I would do the database stuff prior to printing.
Turn the data into a List<SomeClass> where SomeClass models the data in a row.
Then call print on an object that contains this List.

Your print() method then can simply access the entry in the List based on the 'page' number.
This presumes each pay slip is a single page.

[raj.mscking@gmail.com]

Thank you sir!
Can you show me a simple example sir,
I try now self..,

[Tolls]

You really need to try it.

[raj.mscking@gmail.com]

Thank You Sir!
i will do myself ..,

[doWhile]

Just another route to get to, at least what I think, your requirements are: jasperreports : JasperForge

[raj.mscking@gmail.com]

thank you very much sir,
in youtube i watch the videos sample for use jasperreports in web application now..,
is it suitable for stand alone application sir?..,

[doWhile]

is it suitable for stand alone application sir?..,

I have never used it in that environment.