Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 4 of 4

Thread: NEED HELP.. PAYROLL SYSTEM CONNECT TO MS ACESS

  1. #1
    Junior Member
    Join Date
    Oct 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default NEED HELP.. PAYROLL SYSTEM CONNECT TO MS ACESS

    import javax.swing.*;
    import javax.swing.event.*;
    import java.awt.*;
    import java.awt.event.*;
    import java.sql.*;
    import java.io.*;

    class Frame1 extends JFrame implements ActionListener {

    // initializa the lbl with caption name is employee information.
    JLabel lbl=new JLabel("Payroll System");

    Font f=new Font("Times",Font.BOLD,30);
    Font f1=new Font("Times",Font.BOLD,16);
    Font f2=new Font("Times",Font.BOLD,12);

    JLabel lblid,lblname,lbldepartment,lbldays,lblrate,lblsub mit,lblstat;
    JLabel lblsalary;
    JTextField txtid,txtname,txtdepartment,txtdays;
    JTextField txtrate,txtsalary;
    JRadioButton rbmarried,rbsingle;
    JButton btnadd,btnsave,btnupdate,btndelete,btnexit;
    JButton btnnext,btnprev,btnlast,btnfirst;
    JButton btncompute;
    String gen;
    ResultSet rs=null;
    Connection con=null;
    Statement stmt=null;

    float days,rate,salary;

    Frame1()
    {
    // this is display in a Frame titlebar.
    super("Employees Information ");
    addWindowListener(new WindowAdapter(){
    public void windowClosing(WindowEvent we)
    {
    System.exit(0);
    }
    });
    // set layout to null
    setLayout(null);



    // add lbl label on form.
    add(lbl);

    // set the particular position on a screen
    lbl.setBounds(200,50,500,100);
    lbl.setHorizontalAlignment(lbl.CENTER );
    // set the font of lbl label
    lbl.setFont(f);


    // initializa all the label which are declared in the example above with its caption name
    lblid=new JLabel("ID");
    lblname=new JLabel("NAME");
    lbldepartment=new JLabel("DEPARTMENT");
    lbldays=new JLabel("N0. OF DAYS ");
    lblrate=new JLabel("RATE PER DAY");
    lblsalary=new JLabel("SALARY");
    lblstat=new JLabel("CIVIL STATUS");

    lblid.setBounds(300,140,100,20);
    lblname.setBounds(300,180,100,20);
    lbldepartment.setBounds(300,220,100,20);
    lbldays.setBounds(300,250,100,20);
    lblrate.setBounds(300,280,100,20);
    lblsalary.setBounds(300,320,100,20);
    lblstat.setBounds(300,300,100,20);

    // add all the label on the frame
    add(lblid);
    add(lblname);
    add(lbldepartment);
    add(lbldays);
    add(lblrate);
    add(lblsalary);
    add(lblstat);

    // set font
    lblid.setFont(f2);
    lblname.setFont(f2);
    lbldepartment.setFont(f2);
    lbldays.setFont(f2);
    lblrate.setFont(f2);
    lblsalary.setFont(f2);
    lblstat.setFont(f2);

    // initialize the textfield with size
    txtid=new JTextField(15);
    txtname=new JTextField(15);
    txtdepartment=new JTextField(15);
    txtdays=new JTextField(15);
    txtrate=new JTextField(15);
    txtsalary=new JTextField(15);
    rbmarried=new JRadioButton("Married");
    rbsingle=new JRadioButton("Single");


    // set a particlar position on a screen with setbounds constructor
    txtid.setBounds(400,140,100,20);
    txtname.setBounds(400,180,100,20);
    txtdepartment.setBounds(400,220,100,20);
    txtdays.setBounds(400,250,100,20);
    txtrate.setBounds(400,280,100,20);
    txtsalary.setBounds(400,320,100,20);
    rbmarried.setBounds(400,300,70,20);
    rbsingle.setBounds(470,300,70,20);


    // add textfield on a Frame
    add(txtid);
    add(txtname);
    add(txtdepartment);
    add(txtdays);
    add(txtrate);
    add(txtsalary);
    add(rbmarried);
    add(rbsingle);

    // create a button group for radio button
    ButtonGroup bg=new ButtonGroup();

    // add button to group
    bg.add(rbmarried);
    bg.add(rbsingle);


    // register radio button
    rbmarried.addActionListener(this);
    rbsingle.addActionListener(this);




    // initializa button with its caption
    btnadd=new JButton("Add");
    btnsave=new JButton("Save");
    btnupdate=new JButton("Update");
    btndelete=new JButton("Delete");

    // To add tooltip in the buttons
    btnadd.setToolTipText("Click this button to Add record in the Database.");
    btnsave.setToolTipText("Click this button to Save record in the Database.");
    btnupdate.setToolTipText("Click this button to Update record in the Database.");
    btndelete.setToolTipText("Click this button to Delete record in the Database.");

    // set a particular position on a Frame
    btnadd.setBounds(200,400,100,30);
    btnsave.setBounds(310,400,100,30);
    btnupdate.setBounds(420,400,100,30);
    btndelete.setBounds(530,400,100,30);

    // add button on a frame
    add(btnadd);
    add(btnsave);
    add(btndelete);
    add(btnupdate);

    // register all the button
    btnadd.addActionListener(this);
    btnsave.addActionListener(this);
    btnupdate.addActionListener(this);
    btndelete.addActionListener(this);


    // initializa nevigation button with its caption
    btnfirst=new JButton("First");
    btnnext=new JButton("Next");
    btnprev=new JButton("Previous");
    btnlast=new JButton("Last");

    // To add tooltip in the buttons
    btnfirst.setToolTipText("Click this button to move to the First Record.");
    btnnext.setToolTipText("Click this button to move to the Next Record.");
    btnprev.setToolTipText("Click this button to move to the Previous Record.");
    btnlast.setToolTipText("Click this button to move to the Last Record.");


    // set a particular position on a screen with setbounds constructor
    btnfirst.setBounds(200,440,100,30);
    btnnext.setBounds(310,440,100,30);
    btnprev.setBounds(420,440,100,30);
    btnlast.setBounds(530,440,100,30);

    // add all the button on frame
    add(btnfirst);
    add(btnnext);
    add(btnprev);
    add(btnlast);

    // register all the button
    btnfirst.addActionListener(this);
    btnnext.addActionListener(this);
    btnprev.addActionListener(this);
    btnlast.addActionListener(this);

    btnexit=new JButton("Exit");
    btnexit.setToolTipText("Click this button to Quit Program.");
    btnexit.setBounds(360,480,100,30);
    add(btnexit);
    btnexit.addActionListener(this);

    btncompute=new JButton("Compute");
    btncompute.setToolTipText("Click this button to compute the salary of the employee.");
    btncompute.setBounds(360,350,100,30);
    add(btncompute);
    btncompute.addActionListener(this);

    // open database connection
    // here we call a dbopen() method
    dbOpen();
    }


    public void actionPerformed(ActionEvent ae)
    {
    try
    {

    if(ae.getActionCommand()=="Add")
    {
    txtid.setText("");
    txtname.setText("");
    txtdepartment.setText("");
    txtdays.setText("");
    txtrate.setText("");
    txtsalary.setText("");
    }
    if(ae.getActionCommand()=="Update")
    {


    stmt.executeUpdate("UPDATE pay1 SET name='" + txtname.getText() + "',department='" + txtdepartment.getText() + "',days='" + txtdays.getText() + "',rate='" + txtrate.getText()+ "',salary='" + txtsalary.getText() + "' WHERE id=" + txtid.getText() + "");

    dbClose();
    dbOpen();
    }
    if(ae.getActionCommand()=="Delete")
    {
    stmt.executeUpdate("DELETE FROM pay1 WHERE id=" + txtid.getText() + "");
    dbClose();
    dbOpen();
    }
    if(ae.getActionCommand()=="Save")
    {

    stmt.executeUpdate("INSERT INTO pay1 VALUES('" +txtid.getText()+ "','"+ txtname.getText() + "','" + txtdepartment.getText() + "','" + txtdays.getText() + "','"+txtrate.getText() + "','" +txtsalary.getText() +"')");



    dbClose();
    dbOpen();
    }
    if(ae.getActionCommand()=="Next")
    {
    if(rs.next())
    {
    setText(); setText();
    }
    else
    {
    JOptionPane.showMessageDialog(null, "You are At Already Last Record", "Message", JOptionPane.ERROR_MESSAGE);
    }
    }
    if(ae.getActionCommand()=="Previous")
    {
    if(rs.previous())
    {
    setText();
    }
    else
    {
    JOptionPane.showMessageDialog(null, "You Are At Already First Record", "Message", JOptionPane.ERROR_MESSAGE);
    }
    }
    if (ae.getActionCommand()=="First")
    {
    if(rs.first())
    {
    setText();
    }
    }
    if (ae.getActionCommand()=="Last")
    {
    if(rs.last())
    {
    setText();
    }
    }

    if(ae.getActionCommand()=="Compute")
    {

    days=Float.parseFloat(txtdays.getText());
    rate=Float.parseFloat(txtrate.getText());
    salary=(days*rate);
    float round = Round(salary,2);
    txtsalary.setText(Float.toString(round));
    txtsalary.setEditable(false);
    }
    if(ae.getActionCommand()=="Exit")
    {
    System.exit(0);
    }

    if(ae.getActionCommand()=="Single")
    {
    gen="Single";
    }
    else
    {
    gen="Married";
    }

    }




    catch(Exception e)
    {
    e.printStackTrace();
    }
    }



    // Method to round off decimal values

    public static float Round(float Rval, int Rpl) {
    float p = (float)Math.pow(10,Rpl);
    Rval = Rval * p;
    float tmp = Math.round(Rval);
    return (float)tmp/p;
    }

    public void dbOpen()
    {
    try
    {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    // here in this statement mydata is a DSN name which u have to create before run this program
    // step to create dsn
    // open control panel-> open administrativr tools-> open data source(ODBC)-> press add
    //->select microsoft access driver(*.mdb) then finish->give data source name-> select database and press ok
    // again press ok.
    con=DriverManager.getConnection("jdbcdbc:pay");
    stmt=con.createStatement(ResultSet.TYPE_SCROLL_SEN SITIVE,ResultSet.CONCUR_UPDATABLE);
    rs = stmt.executeQuery("Select * from pay1");
    if(rs.next())
    setText();
    }catch(Exception e){}
    }
    public void dbClose()
    {
    try{stmt.close();
    rs.close();
    con.close();
    }catch(Exception e){}
    }
    public void setText(){
    try{
    txtid.setText(rs.getString(1));
    txtname.setText(rs.getString(2));
    txtdepartment.setText(rs.getString(3));
    txtdays.setText(rs.getString(4));
    txtrate.setText(rs.getString(5));
    txtsalary.setText(rs.getString(6));
    if(rs.getString(7).equals("Married"))
    {
    rbmarried.setSelected(true);
    }
    else
    {
    rbsingle.setSelected(true);
    }
    }catch(Exception ex){}
    }





    public class pay
    {
    public static void main(String[] args)throws Exception
    {

    // create a object of Frame1 class in main method
    Frame1 f1=new Frame1();

    // set frame size
    f1.setSize(800,600);

    // set frame visible true
    f1.setVisible(true);
    //set look and feel for frame
    UIManager.setLookAndFeel("javax.swing.plaf.metal.M etalLookAndFeel");
    }
    }
    }


  2. #2
    Super Moderator
    Join Date
    Jun 2013
    Location
    So. Maryland, USA
    Posts
    4,467
    My Mood
    Mellow
    Thanks
    150
    Thanked 607 Times in 594 Posts

    Default Re: NEED HELP.. PAYROLL SYSTEM CONNECT TO MS ACESS

    Too much code. Provide an explanation of the problem, ask a question.

  3. #3
    Junior Member
    Join Date
    Oct 2013
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: NEED HELP.. PAYROLL SYSTEM CONNECT TO MS ACESS

    Quote Originally Posted by GregBrannon View Post
    Too much code. Provide an explanation of the problem, ask a question.
    Sir.. I run this code in 32 bit .. It works.. My database updates.. My problem is I can't run on 64 bit.. It is compiling but it doesn't update my database.

    --- Update ---

    What should I do? Same code.. It works on 32 bit and it updates my database.. When it comes toy desktop which is 64 it does not run at all.. And doesn't update my database

  4. #4
    Super Moderator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,234
    Thanks
    176
    Thanked 817 Times in 760 Posts
    Blog Entries
    5

    Default Re: NEED HELP.. PAYROLL SYSTEM CONNECT TO MS ACESS

    Wrap all code in code tags, and

    catch(Exception e){}

    always - I repeat always - deal with exceptions in an appropriate manner - at the very least print out the stack trace.

    Further...
    ae.getActionCommand()=="Exit"
    ...unless you know what you are doing, always compare Strings using the equals method (not ==, but .equals())

Similar Threads

  1. ms-acess with jdbc
    By muzammil786 in forum JDBC & Databases
    Replies: 11
    Last Post: February 10th, 2013, 12:22 PM
  2. ms-acess with jdbc
    By muzammil786 in forum What's Wrong With My Code?
    Replies: 11
    Last Post: February 10th, 2013, 12:22 PM
  3. Acess methods
    By Truck35 in forum Object Oriented Programming
    Replies: 3
    Last Post: January 29th, 2013, 11:05 AM
  4. heeeeeyyyy .. HELP ! :) -- PAYROLL SYSTEM --
    By princess in forum Java Theory & Questions
    Replies: 5
    Last Post: February 27th, 2011, 02:11 PM
  5. Payroll
    By Kesh486 in forum What's Wrong With My Code?
    Replies: 1
    Last Post: September 6th, 2010, 06:48 PM

Tags for this Thread