Package DBLayer

Examples of DBLayer.DBCustomer

15
16
17
18
19
20
21
22
//Search for customer

  public Customer findCustomer(String cpr)
  {
    IFDBCustomer dbcustomerObj = new DBCustomer();
      return dbcustomerObj.searchCustomer(cpr, true);
  }
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
//update customer

  public int updateCustomer(String CPR,String firstName, String lastName, String address,int zipcode, String phoneNumber)
  {

    IFDBCustomer dbcustomerObj = new DBCustomer();
    Customer customer = new Customer(CPR);
    IFDBCity dbcityObj=new DBCity();
    City city=new City();
   
    //customer.setCPR(CPR);
    customer.setFirtName(firstName);
    customer.setLastName(lastName);
    customer.setAddress(address);
    city=dbcityObj.findCity(zipcode,false);
    customer.setCity(city);
    customer.setPhoneNumber(phoneNumber);
    return  dbcustomerObj.updateCustomer(customer,CPR);
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
67
         customerObj.setPhoneNumber(phoneNumber);
      

         DBConnection.startTransaction();
         try{
           DBCustomer dbCustomerObj = new DBCustomer();
         dbCustomerObj.insertCustomer(customerObj);
         }
         catch(SQLException ex){
           DBConnection.rollbackTransaction();
               }
         DBConnection.commitTransaction();
View Full Code Here
78
79
80
81
82
83
84
85
  //}
 
  //delete customer
 
  public void deleteCustomer(String cpr){
    IFDBCustomer dbcustomerObj = new DBCustomer();
      dbcustomerObj.delete(cpr);
  }
View Full Code Here
TOP

Related Classes of DBLayer.DBCustomer

  • ControlLayer.ControlCustomer
  • java.sql.ResultSet
  • java.sql.SQLException
  • java.sql.Statement
    • 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.