Using the Java DB Database in the NetBeans IDE __c#

Source: Internet
Author: User
Tags netbeans java se

This document describes how to quickly establish a connection to Sun's Java DB (the database is based on the Apache Derby database) in the NetBeans IDE. Once connected, you can easily use the database in the IDE to create tables, populate tables with data, run SQL queries, and so on.

The Java DB database is a distribution version of Sun-supported Apache Derby. Java DB is a fully transactional, secure, standards-based database server that is written in Java and fully supports the SQL, JDBC API, and Java EE Technologies. The Java DB database is bundled with the Sun Java System application Server 9.0, Platform Edition,

Expected Duration: - minutes

The following topics are covered in this tutorial:

L Get Software

L Configuration Database

L REGISTER the database in the NetBeans IDE

L START the server and create the database

L Connect to a database

L Create a table

L Add Table Data

L Use SQL Scripts

L recreate the table from another database

L Next

Get software

Before starting this tutorial, you must make sure that the following software is installed on your computer:

1. NetBeans IDE 5.5 (download)

2. Java SE Development Kit (jdk™) version 5.0 or later (download)

3. Java DB (download)

Note: If you are downloading JDK 6, the installation will include the Java DB database. You can also download the Sun Java System application Server, which contains Java DB. When you register the application server in the NetBeans IDE, Java DB is automatically registered. In addition, you can download the Java EE 5 Tools Bundle, which includes both the NetBeans IDE and the Sun Java System Application Server.

Configuration Database

If the Sun Java System Application Server is registered in the NetBeans IDE, then Java DB will be automatically registered. You can jump directly to the start server and create a database section. If you downloaded the application server, but you need help registering the server in the NetBeans IDE, search IDE Help (F1) to find an instance of registering the Sun Java System Application Server. If you downloaded only Java DB, do the following:

1. Run this self-extracting file. Create a folder named "Javadb" in the same location as the file. If you downloaded only Java DB and wanted to place the database server in a different location from where it was extracted, you should reposition it immediately.

2. In the Java DB root (javadb), create a name named "Database

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.