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