Package ModelLayer

Examples of ModelLayer.Supplier

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
       return(rc);
    }

  public int updateSupplier(Supplier sup)
  {
    Supplier supObj  = sup;
    int rc=-1;

    String query="UPDATE supliers SET "+
         "Name='"+ supObj.getName()+"', "+
         "Address ='"+ supObj.getAddress() + "', " +
                          "Country ='"+ supObj.getCountry() + "', " +
                          "PhoneNumber ='"+ supObj.getPhoneNumber()+ "', " +
                          "Email ='"+ supObj.getEmail()+ "' " +
              " WHERE Name= '"+ supObj.getName()+"'";
                System.out.println("Update query:" + query);
      try{ // update employee
       Statement stmt = con.createStatement();
       stmt.setQueryTimeout(5);
        rc = stmt.executeUpdate(query);
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
  
  //Singelwhere is used when we only select one employee  
  private Supplier singleWhere(String wClause, boolean retrieveAssociation)
  {
    ResultSet results = null;
    Supplier supObj = new Supplier();
               
          String query =  buildQuery(wClause);
                System.out.println(query);
    try{ // read the employee from the database
       Statement stmt = con.createStatement();
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
     
    return query;
  }

  private Supplier buildSupplier(ResultSet results)
      {   Supplier supObj = new Supplier();
          try{ // the columns from the table emplayee  are used
              supObj.setSupplierID(results.getInt("SuplierID"));
                supObj.setName(results.getString("Name"));
                supObj.setAddress(results.getString("Address"));
                supObj.setCountry(results.getString("Country"));
                supObj.setPhoneNumber(results.getString("phoneNumber"));
      supObj.setEmail(results.getString("Email"));
     
          }
         catch(Exception e)
         {
             System.out.println("error in building the supplier object");
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
    
   
      public int updateSupplier(String Name, String Address, String Country, String PhoneNumber , String Email)
      {
          IFDBSupplier dbSupplier = new DBSupplier();
          Supplier sup = new Supplier();
          String name1 = dbSupplier.searchSupplierName(Name, false).getName();
        
          sup.setName(name1);
          sup.setAddress(Address);
          sup.setCountry(Country);
          sup.setPhoneNumber(PhoneNumber);
          sup.setEmail(Email);
       
          return  dbSupplier.updateSupplier(sup);
         
         
      }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
  
      public void insertNew(String Name, String Address, String Country , String PhoneNumber, String Email)
      {   
        {   
          
              Supplier supObj = new Supplier();
              supObj.setName(Name);
                  
              supObj.setAddress(Address);
              supObj.setCountry(Country);
              supObj.setPhoneNumber(PhoneNumber);
              supObj.setEmail(Email);
      
              DBConnection.startTransaction();
              try{
               DBSupplier dbSupplier = new DBSupplier();
                 dbSupplier.insertSupplier(supObj);
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
       
     
      public static void main(String[] args)
      {
        ControlSupplier ctr= new ControlSupplier();
        Supplier sup = new Supplier();
        DBSupplier dbSupplier = new DBSupplier();
       
        ctr.deleteSupplier("Toshko");
       
        }
View Full Code Here
TOP

Related Classes of ModelLayer.Supplier

  • ControlLayer.ControlSupplier
  • DBLayer.DBSupplier
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.