online e Projects

EMS - In Java and MS-Access:

Database MS Access :

Table-1 : emp
Table-2 : users

Structure of table-1(emp) :
emp_id [text]{primary key}
name [text]
department [text]
address [text]
contact_no [text]

Structure of table-2(users) :
user_name [text]{primary key}
password [text]

Program in Java :
File1 : Login.java

/* Source From http://online-eprojects.blogspot.com/ */

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

public class Login extends JFrame implements ActionListener, KeyListener{
    Connection con;
    String db;
    Statement st;
    ResultSet rs;

private JButton btnCancel;
    private JButton btnOK;
    private JPasswordField txtPass;
    private JTextField txtName;
    private JLabel lblPass;
    private JLabel lblName;

Login(){
        super("EMS Login");
        db="emp.mdb";
       
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection ("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + db + ";DriverID=22}","","");

}catch(Exception e){
           System.out.println(e.getMessage() + " "+db +" DataBase Missing JDBC:ODBC");
        }

Container con = getContentPane();
        con.setLayout(null);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//Setting up JButton (btnCancel)..
        btnCancel = new JButton("Cancel");
        btnCancel.setBounds(154, 123, 84, 25);
        con.add(btnCancel);

//Setting up JButton (btnOK)..
        btnOK = new JButton("OK");
        btnOK.setBounds(63, 123, 84, 25);
        con.add(btnOK);

//Setting up JPasswordField (txtPass)..
        txtPass = new JPasswordField();
        txtPass.setBounds(95, 79, 144, 21);
        con.add(txtPass);

//Setting up JTextField (txtName)..
        txtName = new JTextField();
        txtName.setBounds(95, 44, 144, 21);
        con.add(txtName);

//Setting up JLabel (lblPass)..
        lblPass = new JLabel("Password:");
        lblPass.setBounds(24, 79, 64, 17);
        con.add(lblPass);

//Setting up JLabel (lblName)..
        lblName = new JLabel("Name:");
        lblName.setBounds(51, 44, 60, 17);
        con.add(lblName);

txtName.addKeyListener(this);
        txtPass.addKeyListener(this);
        btnOK.addActionListener(this);
        btnCancel.addActionListener(this);
        setSize(277, 210);
        setLocation(100, 100);
        //Center On Screen
        setLocationRelativeTo(null);
        setResizable(false);
        setVisible(true);
    }

public static void main(String args[])
    {
            try
            {
                Login obj =new Login();
                obj.showLogIn();
            }
            catch(Exception e)
            {
                    System.out.println(e);
            }
    }

public void  showLogIn()
    {
         setVisible(true);
    }

public boolean validUser(String u,String p){
        boolean iret=false;
         try{
            st=con.createStatement();
            String rr="SELECT * From users WHERE user_name='"+u+"' AND password='"+p+"'";
            rs=st.executeQuery(rr);
           
            if(rs.next()){
                rs.getString("password");
                iret=true;
                 st.close();
                 con.close();
            }else{
                JOptionPane.showMessageDialog(null, "Wrong username or password.", "Warning!", JOptionPane.WARNING_MESSAGE);
                txtName.requestFocusInWindow();

}
        }catch(Exception e){
            System.out.println(e.getMessage());
        }
        return iret;
   }

public void keyPressed(KeyEvent e)
    {
            if(e.getKeyCode()==KeyEvent.VK_ENTER)
            {
                    String u = txtName.getText();
                    String p = new String(txtPass.getPassword());

if(u.equals("") || p.equals(""))
                    {
                            JOptionPane.showMessageDialog(null, "Type username and password.", "Warning!", JOptionPane.WARNING_MESSAGE);
                            return;
                    }

if(validUser(u,p)==true){
                        try
                        {
                            Init st=new Init(db);
                            st.showWind();
                            setVisible(false);

}
                        catch(Exception ex)
                        {
                                System.out.println(ex);
                        }
                }
            }
    }

public void keyReleased(KeyEvent e) {}
    public void keyTyped(KeyEvent e) {}

public void actionPerformed(ActionEvent e)
    {
        if(e.getSource()==btnCancel)
            System.exit(0);
        if(e.getSource()==btnOK)
        {
            String u = txtName.getText();
            String p = new String(txtPass.getPassword());

if(u.equals("") || p.equals(""))
            {
                JOptionPane.showMessageDialog(null, "Type username and password.", "Warning!", JOptionPane.WARNING_MESSAGE);
                return;
            }

if(validUser(u,p)==true){
                            try
                            {
                                    Init st=new Init(db);
                                    st.showWind();
                                    setVisible(false);
                            }
                            catch(Exception ex)
                            {
                                   System.out.println(ex);
                            }
                    }
        }
    }
}

File2: Main.java

/* Source From http://online-eprojects.blogspot.com/ */

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

class Db{
        static Connection con;

Db(String dbName){
            try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                con = DriverManager.getConnection ("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" + dbName + ";DriverID=22}","","");

}catch(Exception e){
               System.out.println(e.getMessage() + "  "+dbName +" DataBase Missing JDBC:ODBC");
               System.out.println(e.getStackTrace());
               closeConn();
            }

}

static void closeConn(){
             try{
                    con.close();
                }catch(Exception e)
                {
                    System.out.println(e.getMessage() + " Conn Close() Error ");
                    System.out.println(e.getStackTrace());
                }
        }

}

class Init extends Db implements ActionListener{

JFrame wind;
    JPanel panelRow1,panelRow1_5,panelRow2,panelRow3,panelRow4,panelRow5,panelRow6,panelRow7;
    JTextField jtxtEmpId,jtxtName,jtxtDep,jtxtContactNo;
    JTextArea jtxtAddress;
    JButton jbtnNext,jbtnAdd,jbtnEdit,jbtnDelete,jbtnFind,jbtnPrevious,jbtnExit;

Statement stnext;
    ResultSet rsNext;

Init(String db){

//Db File Name Here
        super(db);

/*---------------------------Next Record------*/
       try{
       stnext=con.createStatement(rsNext.TYPE_SCROLL_SENSITIVE,rsNext.CONCUR_READ_ONLY);
           //SQL
            String rr="SELECT * From emp";
            rsNext=stnext.executeQuery(rr);
        }catch(Exception e){
            System.out.println(e);
        }
        /*---------------End-Next Record------*/

wind= new JFrame("EMS");
      
        wind.setSize(280, 420);

//Center Form
        wind.setLocationRelativeTo(null);
       
        wind.setResizable(false);//No resize

wind.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

FlowLayout flow = new FlowLayout(FlowLayout.LEFT);            // Create a layout manager
        Container content = wind.getContentPane();  // Get the content pane
        content.setLayout(flow);                       // Set the container layout mgr

panelRow1 = new JPanel();
        panelRow1.setLayout(new FlowLayout());

panelRow1_5= new JPanel();
        panelRow1_5.setLayout(new FlowLayout());

panelRow2 = new JPanel();
        panelRow2.setLayout(new FlowLayout());

panelRow3 = new JPanel();
        panelRow3.setLayout(new FlowLayout());

panelRow4 = new JPanel();
        panelRow4.setLayout(new FlowLayout());

panelRow5 = new JPanel();
        panelRow5.setLayout(new FlowLayout());

panelRow6 = new JPanel();
        panelRow6.setLayout(new FlowLayout());

panelRow7 = new JPanel();
        panelRow7.setLayout(new FlowLayout());

JLabel jlblEmpId=new JLabel("EMP ID" , JLabel.LEFT);
        JLabel jlblName=new JLabel("Name" , JLabel.LEFT);
        JLabel jlblDep=new JLabel("Department" , JLabel.LEFT);

JLabel jlblContactNo=new JLabel("Contact No." , JLabel.LEFT);

jtxtEmpId=new JTextField(10);
        jtxtName=new JTextField(10);
        jtxtDep=new JTextField(10);

jtxtAddress=new JTextArea(5,15);
        jtxtAddress.setBorder(BorderFactory.createTitledBorder("Address"));
        //Add TextArea To Scroll
        JScrollPane areaScrollPane = new JScrollPane(jtxtAddress);
        areaScrollPane.setVerticalScrollBarPolicy(
        JScrollPane.VERTICAL_SCROLLBAR_ALWAYS);
        areaScrollPane.setPreferredSize(new Dimension(200, 110));

jtxtContactNo=new JTextField(9);

jbtnNext=new JButton("Next");
        jbtnAdd=new JButton("Add");
        jbtnEdit=new JButton("Update");
        jbtnDelete=new JButton("Delete");
        jbtnFind=new JButton("Search");
        jbtnPrevious=new JButton("Previous");
        jbtnExit=new JButton("Exit");

panelRow1.add(jlblEmpId);
        panelRow1.add(jtxtEmpId);
        content.add(panelRow1);

panelRow1_5.add(jbtnFind);
        panelRow1_5.add(jbtnPrevious);
        panelRow1_5.add(jbtnNext);

content.add(panelRow1_5);

panelRow2.add(jlblName);
        panelRow2.add(jtxtName);
        content.add(panelRow2);

panelRow3.add(jlblDep);
        panelRow3.add(jtxtDep);
        content.add(panelRow3);

panelRow4.add(areaScrollPane);
        content.add(panelRow4);

panelRow5.add(jlblContactNo);
        panelRow5.add(jtxtContactNo);
        content.add(panelRow5);

panelRow6.add(jbtnAdd);
        panelRow6.add(jbtnEdit);
        panelRow6.add(jbtnDelete);
        content.add(panelRow6);

panelRow7.add(jbtnExit);
        content.add(panelRow7);

jbtnFind.addActionListener(this);
        jbtnNext.addActionListener(this);
        jbtnPrevious.addActionListener(this);
        jbtnAdd.addActionListener(this);
        jbtnEdit.addActionListener(this);
        jbtnDelete.addActionListener(this);
        jtxtEmpId.addActionListener(this);
        jbtnExit.addActionListener(this);

}

public void showWind(){
        // Display the window
          wind.setVisible(true);
    }

public void hideWind(){

wind.setVisible(false);
    }

public boolean isValid(){
        boolean iret=false;
          if(jtxtEmpId.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"Please Enter EMP ID.");
              jtxtEmpId.requestFocusInWindow();
              iret = false;

}else if(jtxtName.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"Please Enter empdent Name");
              jtxtName.requestFocusInWindow();
              iret = false;

}else if(jtxtDep.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"Please Enter Department Name");
              jtxtDep.requestFocusInWindow();
              iret = false;

}else if(jtxtAddress.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"Please Enter Address");
              jtxtAddress.requestFocusInWindow();
              iret = false;

}else if(jtxtContactNo.getText().trim().equals("")){
               JOptionPane.showMessageDialog(null,"Please Enter ContactNo");
              jtxtContactNo.requestFocusInWindow();
              iret = false;

}else{
                iret = true;

}

return iret;

}

public void setLast(){

try{
            rsNext.last();
        } catch(Exception ex){

}
    }

public void setFirst(){

try{
            rsNext.first();
        } catch(Exception ex){

}
    }

public void actionPerformed(ActionEvent e)
    {
        //Search Findbtn
        if(e.getSource()==jbtnFind){

try{

//For Search
                Statement stSarch;
                ResultSet rsSearch;

stSarch=con.createStatement();
                                //SQL
                String rr="SELECT * From emp WHERE emp_id='"+ jtxtEmpId.getText() +"'";
                System.out.println(rr);

rsSearch=stSarch.executeQuery(rr);
                if(rsSearch.next()){
                    jtxtEmpId.setText(rsSearch.getString("emp_id"));
                    jtxtName.setText(rsSearch.getString("name"));
                    jtxtDep.setText(rsSearch.getString("department"));
                    jtxtAddress.setText(rsSearch.getString("address"));
                    jtxtContactNo.setText(rsSearch.getString("contact_no"));
                }else{
                        JOptionPane.showMessageDialog(null,"Error -> Record Not Found" + jtxtEmpId.getText());
                }

//
            }
            catch(Exception ex){
                //System.out.println(ex.toString());
            }
        }
        //previous record
        if(e.getSource()==jbtnPrevious){

try{

if(rsNext.previous()){
                        jtxtEmpId.setText(rsNext.getString("emp_id"));
                        jtxtName.setText(rsNext.getString("name"));
                        jtxtDep.setText(rsNext.getString("department"));
                        jtxtAddress.setText(rsNext.getString("address"));
                        jtxtContactNo.setText(rsNext.getString("contact_no"));
                     }else{
                        JOptionPane.showMessageDialog(null,"U R at First Record");
                     }
                    }catch(Exception ex){
                        JOptionPane.showMessageDialog(null,"U R at First Record");
                        setFirst();
                        jtxtEmpId.requestFocusInWindow();
                        System.out.println(ex.getMessage());
                        System.out.println(ex.toString());
                  }
            }

//Next Record
        if(e.getSource()==jbtnNext){

try{

if(rsNext.next()){
                        jtxtEmpId.setText(rsNext.getString("emp_id"));
                        jtxtName.setText(rsNext.getString("name"));
                        jtxtDep.setText(rsNext.getString("department"));
                        jtxtAddress.setText(rsNext.getString("address"));
                        jtxtContactNo.setText(rsNext.getString("contact_no"));

}else{
                        JOptionPane.showMessageDialog(null,"Error." + "U r at` last record");
                        setLast();
                        return;
                     }

}catch(Exception ex){

setLast();
                        System.out.println(ex.getMessage());
                        System.out.println(ex.toString());
                  }
        }

//Add New
        if(e.getSource()==jbtnAdd){

//Check Validation
            if(isValid()){
                  Statement st1;
                  try{

//Insert New Record
                        st1=con.createStatement();
                        //SQL
                        String rr="insert into emp values('"+jtxtEmpId.getText()+
                                                      "','"+jtxtName.getText()+
                                                      "','"+jtxtDep.getText()+
                                                      "','"+jtxtAddress.getText()+
                                                       "','"+jtxtContactNo.getText()+"')";
                        st1.executeUpdate(rr);
                  
                        //Update Result set
                        String rr2="SELECT * From emp";
                        rsNext=stnext.executeQuery(rr2);
                        //rsNext.last();

st1.close();
                        JOptionPane.showMessageDialog(null,"ACCOUNT Created Successfully");

}catch(Exception ex){
                        JOptionPane.showMessageDialog(null,"Invalid Roll Number , already exist." + jtxtEmpId.getText());
                        jtxtEmpId.requestFocusInWindow();
                        System.out.println(ex.getMessage());
                        System.out.println(ex.toString());
                  }
           }

}
        //Update
        if(e.getSource()==jbtnEdit){
            if(isValid()){

Statement st1;
                  try{

//Insert New Record
                        st1=con.createStatement();
  
                        String rr="UPDATE emp SET name='"+jtxtName.getText()+"',department='"+jtxtDep.getText()+"',address='"+jtxtAddress.getText()+"',contact_no='"+jtxtContactNo.getText()+"' WHERE emp_id='"+jtxtEmpId.getText()+"'";
                        st1.executeUpdate(rr);
                        st1.close();
                        JOptionPane.showMessageDialog(null,"ACCOUNT Updated Successfully");

}catch(Exception ex){
                        JOptionPane.showMessageDialog(null,"Updatation Failed For -> " + jtxtEmpId.getText());
                        jtxtEmpId.requestFocusInWindow();
                        System.out.println(ex.getMessage());
                        System.out.println(ex.toString());
                  }
           }
        }
        if(e.getSource()==jbtnDelete){
            if(jtxtEmpId.getText().trim().equals("")){
                    JOptionPane.showMessageDialog(null,"Please Enter EMP ID.");
                    jtxtEmpId.requestFocusInWindow();
            }else{

Statement st1;
                  try{

//Insert New Record
                        st1=con.createStatement();

String rr="DELETE FROM emp WHERE emp_id='"+jtxtEmpId.getText()+"'";
                        st1.executeUpdate(rr);
                        st1.close();

JOptionPane.showMessageDialog(null,"ACCOUNT Deleted Successfully");
                        jtxtEmpId.setText(null);
                        jtxtName.setText(null);
                        jtxtDep.setText(null);
                        jtxtAddress.setText(null);
                        jtxtContactNo.setText(null);

try{
                            //Update Result set
                            String rr2="SELECT * From emp";
                            rsNext=stnext.executeQuery(rr2);
                            rsNext.last();
                        }catch(Exception ex){
                            System.out.println(ex);
                        }
                      
           }catch(Exception ex){
                        JOptionPane.showMessageDialog(null,"Delete Failed For -> " + jtxtEmpId.getText());
                        jtxtEmpId.requestFocusInWindow();
                        System.out.println(ex.getMessage());
                        System.out.println(ex.toString());
                  }
            }

}
         if(e.getSource()==jbtnExit){
            System.exit(0);
         }
    }
}

/* if you have any problem while running this project please comment */

online e Projects

Wednesday, 7 December 2011

Employee management system - Java eProject

SyntaxHighlighter