public static String insertUser(String fname, String lname, String addrs, String eml, String phone, String usernm, String passwd)throws ClassNotFoundException, SQLException {

    DriverManager.registerDriver(new com.mysql.jdbc.Driver ());
       //establish connection
    Connection conn = DriverManager.getConnection ("jdbc:mysql://webi.lab/theBusiness?user=webAccess&password=access");
    // create a prepared statement to add the user input to
    PreparedStatement pstmt = conn.prepareStatement("insert into customer (FirstName, LastName, Address, Email, PhoneNumber, username, password) values (?, ?, ?, ?, ?, ?, ?)");
      // enter the user input into the prepared statement
     pstmt.setString(1, fname);
     pstmt.setString(2, lname);
     pstmt.setString(3, addrs);
     pstmt.setString(4, eml);
     pstmt.setString(5, phone);
     pstmt.setString(6, usernm);
     pstmt.setString(7, passwd);
      //execute the sql
     pstmt.execute();
     conn.close();
     return "success";
  } //end insert data