Querybuilder (s5)

Employee.java

 public class Employee {
private String code;
public String  Name;
private String CellNum;
private String Address;

public void setEmpcode(String c)
{
    code=c;
}
public String GetEmpcode()
{
    return code;
}
public void setCellNum(String cell)
{
    CellNum=cell;
}
public String GetCellNum()
{
    return CellNum;
}
public void setAddress(String add)
{
    Address=add;
}
public String GetAddress()
{
    return Address;
}
}

EmployeeForm.java

 Employee p=new Employee();
         p.setEmpcode(txtCode.getText());
         p.Name=txtName.getText();
         p.setCellNum(txtCellNum.getText());
         p.setAddress(txtAddress.getText());
      
      
        QueryBuilder obj=new QueryBuilder();

 boolean r=obj.empinsertQuery(p);
 if(r==true)
     JOptionPane.showMessageDialog(null,"Inserted");
 else
      JOptionPane.showMessageDialog(null,"Not Inserted");
                   
    }                                       

    -----------btnDelete-----------                                      
        // TODO add your handling code here:
            Employee p=new Employee();
           p.setEmpcode(txtCode.getText());
 
      QueryBuilder obj=new QueryBuilder();

 boolean r=obj.empDeleteQuery(p);
 if(r==true)
     JOptionPane.showMessageDialog(null,"Delete");
 else
      JOptionPane.showMessageDialog(null,"Not Delete");
                   
    }                                       

    ------------- btnupdate------------------------------                                       
        // TODO add your handling code here:
         Employee p=new Employee();
         p.setEmpcode(txtCode.getText());
         p.Name=txtName.getText();
         p.setCellNum(txtCellNum.getText());
         p.setAddress(txtAddress.getText());
      
        QueryBuilder obj=new QueryBuilder();

 boolean r=obj.empUpdateQuery(p);
 if(r==true)
     JOptionPane.showMessageDialog(null,"update");
 else
      JOptionPane.showMessageDialog(null,"Not updated");
     
    }                                       

    -------------- btnSearch-----------------------                                    
        // TODO add your handling code here:
         Employee p=new Employee();
         p.setEmpcode(txtCode.getText());
         QueryBuilder obj=new QueryBuilder();
       
           boolean r=obj.empsearchQuery(p);
 if(r==true)
     JOptionPane.showMessageDialog(null,"found");
 else
      JOptionPane.showMessageDialog(null,"Not found");
       
     }           
                           
QueryBuilder.java

public class QueryBuilder {
 public QueryBuilder()
    {
    }
    public boolean empinsertQuery(Employee qp)
    {

String query = "INSERT INTO Employee VALUES('"+qp.GetEmpcode()+"','"+qp.Name+"','"+qp.GetCellNum()+"','"+qp.GetAddress()+"')";

DbConn db=new DbConn();
return db.UDI(query);
   
    }
     
  
    public boolean empDeleteQuery(Employee qp)
    {
    String query="Delete from Employee where Emp_code='"+qp.GetEmpcode()+"'";
    DbConn db=new DbConn();
return db.UDI(query);
    }
    public boolean empUpdateQuery(Employee qp)
    {
    String query="Update  Employee set emp_name='"+qp.Name+"',Cell_Num='"+qp.GetCellNum()+"',Addres='"+qp.GetAddress()+"' where emp_code='"+qp.GetEmpcode()+"'";
     
    DbConn db=new DbConn();
return db.UDI(query);
    }
    public boolean empsearchQuery(Employee qp)
    {
    String query="select * from Employee where Emp_code='" +qp.GetEmpcode()  + "'";
    DbConn db=new DbConn();
return db.UDI(query);
    }
DbConn.java

import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.*;
public class DbConn {
     public String path="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb, *.accdb)};DBQ=E:\\Advanced OOP\\Qbuilder\\QueryBuilder\\gulahmad.accdb";
public boolean UDI(String query)
    {
     try{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

     Connection conn = DriverManager.getConnection(path);

     Statement stmt = conn.createStatement();
     stmt.execute(query);
     conn.close();
     return true;
     } catch(java.lang.ClassNotFoundException ex){
     JOptionPane.showMessageDialog(null,"Exception Occured"+ex.getMessage());
     return false;}
     catch(Exception ex){
     JOptionPane.showMessageDialog(null,"Exception Occured"+ex.getMessage());
     return false;
    }
    }

}