Enterprise
Actually I prefer clean and lightweight IDE's without additional "magic" capabilities, but I like the Netbeans support for Java EE and especially EJB3. It comes without heavy wizzard - you can always write plain code - it is your decision.
Especially interesting is the JPA support. The main problem here: only "managed" environments are supported. The current netbeans support for Java SE environments is somehow limited. With some small changes in the persistence.xml (replacing the JTA datasource with database-properties) and libraries (the path to JPA-provider has to be set), netbeans can be also used for this purpose. I only wondering, why this feature is not supported out of the box (actually very little changes/extensions are needed). However, you have still to install an appserver first, to be able to create some entities from an existing database...