// Signup for the customer >>>>>>>>>>>---------
public String addCustomer(
String username,
String password,
String firstname,
String lastname,
String address,
String state,
String city,
int zip,
String type) {
String res = " ";
try {
CustomerDBConnection c = new CustomerDBConnection();
String membershipno = "";
String balance = "";
String role = "User";
if (type.equalsIgnoreCase("SimpleCustomer")) {
balance = "2";
membershipno = c.generateMembershipno("SimpleCustomer");
} else if (type.equalsIgnoreCase("Premium")) {
balance = "10";
membershipno = c.generateMembershipno("Premium");
}
System.out.println("inside insert method");
// con = getConnection();
// stmt=con.createStatement();
String query1 = "Select * from customer WHERE username=?";
System.out.println("inside 1st query");
ps = con.prepareStatement(query1);
ps.setString(1, username);
rs = ps.executeQuery();
if (rs.next()) {
res = "false";
} else {
System.out.println("starting insert query");
String query =
"Insert into customer(membershipno,username,password,firstname,lastname,address,state,city,zipcode,accounttype,balance) values(?,?,?,?,?,?,?,?,?,?,?)";
CustomerDBConnection db = new CustomerDBConnection();
db.login(username, password);
System.out.println("before query");
ps = con.prepareStatement(query);
System.out.println("after query");
ps.setString(1, membershipno);
ps.setString(2, username);
ps.setString(3, password);
ps.setString(4, firstname);
ps.setString(5, lastname);
ps.setString(6, address);
ps.setString(7, state);
ps.setString(8, city);
ps.setFloat(9, zip);
ps.setString(10, type);
ps.setString(11, balance);
ps.executeUpdate();
System.out.println("Inserted Successfully");
c.insertIntoLogin(username, password);
res = "true";
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
// rs.close();
ps.close();
// con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
