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); } }