Essentially, yes. They're installed over the USB cable rather than over the airwaves. No websites involved, no need for an Internet connection.
You have to conver them to .cod files and use the CMD window (DOS style commands) with the javaloader command. It's more involved than using BlackBerry Desktop.