Blog: CS506 Assignment 2 Solution

NetBeans IDE Java Quick Start Tutorial

Welcome to NetBeans IDE!
This tutorial provides a very simple and quick introduction to the NetBeans IDE workflow by walking you through the creation of a simple "Hello World" Java console application. Once you are done with this tutorial, you will have a general knowledge of how to create and run applications in the IDE.
This tutorial takes less than 10 minutes to complete.
After you finish this tutorial, you can move on to the learning trails, which are linked from the Documentation, Training & Support page. The learning trails provide comprehensive tutorials that highlight a wider range of IDE features and programming techniques for a variety of application types. If you do not want to do a "Hello World" application, you can skip this tutorial and jump straight to the learning trails.
Contents

• Setting Up the Project
• Adding Code to the Generated Source File
• Compiling and Running the Application
• Building and Deploying the Application
• Next Steps

To complete this tutorial, you need the following software and resources.

Software or Resource	Version Required
NetBeans IDE	version 7.2
Java Development Kit (JDK)	version 6 or version 7

Setting Up the Project

To create an IDE project:

1. Start NetBeans IDE.
2. In the IDE, choose File > New Project (Ctrl-Shift-N), as shown in the figure below.
   
3. In the New Project wizard, expand the Java category and select Java Application as shown in the figure below. Then click Next.
   
4. In the Name and Location page of the wizard, do the following (as shown in the figure below):
   
   • In the Project Name field, type HelloWorldApp.
   • Leave the Use Dedicated Folder for Storing Libraries checkbox unselected.
   • In the Create Main Class field, type helloworldapp.HelloWorldApp.
   
   
   
5. Click Finish.

The project is created and opened in the IDE. You should see the following components:

• The Projects window, which contains a tree view of the components of the project, including source files, libraries that your code depends on, and so on.
• The Source Editor window with a file called HelloWorldApp open.
• The Navigator window, which you can use to quickly navigate between elements within the selected class.

Adding Code to the Generated Source File

Because you have left the Create Main Class checkbox selected in the New Project wizard, the IDE has created a skeleton main class for you. You can add the "Hello World!" message to the skeleton code by replacing the line:

// TODO code application logic here with the line:

System.out.println("Hello World!"); Save the change by choosing File > Save.
The file should look something like the following code sample.

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package helloworldapp; /** * * @author <your name> */ public class HelloWorldApp { /** * @param args the command line arguments */ public static void main(String[] args) { System.out.println("Hello World!"); } } Compiling and Running the Program

Because of the IDE's Compile on Save feature, you do not have to manually compile your project in order to run it in the IDE. When you save a Java source file, the IDE automatically compiles it.
The Compile on Save feature can be turned off in the Project Properties window. Right-click your project, select Properties. In the Properties window, choose the Compiling tab. The Compile on Save checkbox is right at the top. Note that in the Project Properties window you can configure numerous settings for your project: project libraries, packaging, building, running, etc.
To run the program:

• Choose Run > Run Project (F6).

The next figure shows what you should now see.

Congratulations! Your program works!
If there are compilation errors, they are marked with red glyphs in the left and right margins of the Source Editor. The glyphs in the left margin indicate errors for the corresponding lines. The glyphs in the right margin show all of the areas of the file that have errors, including errors in lines that are not visible. You can mouse over an error mark to get a description of the error. You can click a glyph in the right margin to jump to the line with the error.
Building and Deploying the Application

Once you have written and test run your application, you can use the Clean and Build command to build your application for deployment. When you use the Clean and Build command, the IDE runs a build script that performs the following tasks:

• Deletes any previously compiled files and other build outputs.
• Recompiles the application and builds a JAR file containing the compiled files.

To build your application:

• Choose Run > Clean and Build Project (Shift-F11)

You can view the build outputs by opening the Files window and expanding the HelloWorldApp node. The compiled bytecode file HelloWorldApp.classis within the build/classes/helloworldapp subnode. A deployable JAR file that contains the HelloWorldApp.class is within the dist node.

For information on how to run the application from the command line, see the Starting Your Java Application chapter of the Packaging and Distributing Java Applications tutorial.

I have completed my assignment and uploaded to lms
The only trick is to create the checkboxes array and use for(JCheckBox box: array) to get the checked values. then use sql query "Select * from Students where Grades IN('a','b');
I am giving the idea but not the whole assignment because i have been suffered by giving my assignment to some one and he upload to a website.
//check box array
private ArrayList<JCheckBox> sgrade = new ArrayList<JCheckBox>();
How to get the selected checkbox value and make a query:
string = ""; // create this variable in the class scope
for(JCheckBox jbox: sgrade){
if(box.isSelected()){
string += "'" + box.getText() + "'" + ",";
}
//this will get if a and b selected like this "'a','b'". Now we will put this string in our query
Note: that do not use PrepraedStatement. use only simple Statement
//sql query will be
String sql = "SELECT * FROM Students WHERE Grades IN("+string+")ORDER BY ID DESC ";

Now use some functions to simplify this assignment
BR
Farimarwat

do this... it will save/help ur 75% efforts
as netbean allows for this project.

1. download NETBEAN IDE (this tool help u to create GUI interface easily)
2. check the download section of CS506 there is a tutorial how to use NETBEAN also how to create db link using DNS method.
3. check out this link Designing a Swing GUI in NetBeans IDE - Tutorial (show how to use netbean as well as create GUI interface)
4) here is the JTABLE example. http://docs.oracle.com/javase/tutorial/u...tml#simple
5) now u need to write simple code to data access thru SQL and JTABLE (if i have time i will try to post the code otherwise u can write it)