public void saveCustomer(Customer customer) {
String query = "";
query =
"insert into customer(first_name,last_name,address,tel_no,mobile_no,date_of_birth,date_of_joining) "
+ "values('&firstname','&lastname','&address','&tel_no','&mobile_no','&dob','&doj');";
query = query.replace("&firstname", customer.getFirst_name());
query = query.replace("&lastname", customer.getLast_name());
query = query.replace("&address", customer.getAddress());
query = query.replace("&tel_no", customer.getTel());
query = query.replace("&mobile_no", customer.getMobile());
query = query.replace("&dob", customer.getDob() + "");
query = query.replace("&doj", customer.getDoj() + "");
try {
statement.execute(query);
} catch (SQLException ex) {
Logger.getLogger(CustomerDBHelper.class.getName()).log(Level.SEVERE, null, ex);
}
}
