Connect to Any Database

The IDE comes bundled with drivers for the MySQL and PostgreSQL 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.

Integrate MySQL Easily

NetBeans IDE makes it easy to work with MySQL because it auto-detects existing MySQL databases. Register a MySQL Server and start/stop local servers directly from the IDE. Use the Database Explorer to connect to, browse, create, or 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 lets you insert schema, table and column names more quickly. It also lets you 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 values of returned results and insert or 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 gives you quick view over your tables and columns. Create, modify, and delete tables, columns, indices, etc. 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.

Drag and Drop Tables Into Web Applications

Using the Visual JSF web framework, you can drag database tables from the Database Explorer directly onto components in the design view of your web page, and the component is automatically bound to the table. This significantly improves productivity for building database-oriented web applications.

Get Started Quickly With Database-Oriented Swing Applications

When creating a Java Swing project, you can jump-start your work by using the database application wizard, which lets you select tables from a connection in the Database Explorer and then automatically generate a basic CRUD (Create-Read-Update-Delete) application for those tables.

Get Started Quickly With Database-Oriented JSF Web Applications

You can also quickly create a basic JSF-based CRUD web application using the new JSF CRUD generator (Create-Read-Update-Delete). This allows you to 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 CRUD pages for those entities.

Take Control with Java Persistence API (JPA)

With NetBeans IDE you quickly generate JPA entity classes from existing databases. You can then use the entity class to generate JSF pages, RESTful web services, and other useful code artifacts that integrate data into your applications.

 Integration with External Tools and Services