Connect to Any Database

The IDE comes bundled with drivers for the MySQL, PostgreSQL and Oracle DB database servers. The Java DB database comes bundled with the GlassFish Server and JDK 6, so you have everything you need to build data-aware web and enterprise applications right out of the box. You can also register any other JDBC driver with the IDE, so you can hook up to just about any database that provides a JDBC driver.

Oracle Database

Integrate MySQL Easily

NetBeans IDE makes it easy to work with MySQL because it auto-detects existing MySQL databases. You can register a MySQL Server and start and stop local servers directly from the IDE. You can use the Database Explorer to connect to, browse, create and delete databases. You can also register external administration tools like phpMyAdmin and invoke them directly from the IDE.

SQL Editor

The SQL editor's code completion enables you to insert schema, table and column names quickly. You can also browse the history of all SQL statements, filter by search terms and/or by connection URLs, and then insert the selected statement. You can sort query results in the SQL Editor and load large returned data sets page by page. You can directly change the values of returned results and insert and delete rows.

Sakila Sample Database

Sakila is the "official" MySQL sample database used in tutorials and examples. To load the Sakila database into your MySQL server, simply install the the Sakila plugin from the update center (Tools > Plugins).

Explore and Maintain Databases

The Database Explorer enables you to quickly view your tables and columns and to create, modify, and delete tables, columns and indices. You can open, edit, and run any SQL script in the SQL Editor. The editor provides syntax highlighting to make writing scripts easier. When you run a script that returns data, the data is also displayed in the SQL Editor.

Get Started Quickly With Database-Oriented JSF Web Applications

You can quickly create basic JSF-based CRUD web applications (Create-Read-Update-Delete) using wizards in the IDE. You can build a fully-working CRUD application from database tables in two steps: First generate the JPA entity objects from database tables and then generate the JSF CRUD pages for those entities.

Take Control with Java Persistence API (JPA)

With NetBeans IDE you can quickly generate JPA entity classes from existing databases. From the entity classes the IDE can generate JSF pages, RESTful web services, and other useful code artifacts that integrate data into your applications. You can use the code completion in the editor to help you specify the names of tables, columns and persistence units.

 Integration with External Tools and Services