Database connections using JDBC – MySQL and Netbeans

I am fed up of people asking me how to make Database connections in Java . No one wants to go through the painfull part of studying themselves . All they want is the short-cut . So let me dedicate this particular posts to the topic of database connections in Java .

I have MySQL 5.0 installed on my Windows. In order to make a JDBC connection to MySQL database one needs to downlad the MySQL/J connector driver from here . I will also expect that you have Netbeans 6+ installed on your machine.

Extract the zip file to a folder, you’ll see file ‘mysql-connector-java-5.0.6-bin.jar’ which is the library file that we want. Just copy the file to the library folder, for example to “C:\Program Files\Java\jdk1.6.0_02\lib” also to the “C:\Program Files\Java\jdk1.6.0_02\jre\lib directory.

Next, create a new Java project on NetBeans named ‘TestMySQL’.

Now I’m going to write some code to connect to MySQL database. I have configured MySQL service on localhost.
I’m going to use Connection and DriverMapper Classes so I need to import libraries.
import java.sql.*;

Inorder to test my connections I build my project.

So everything seems to be fine till now.

To get some data, I need to execute query on the SQL Server and get the result back to me. First, I create stmt (Statement object) and execute query in SQL language. Then I store the result on ResultSet object and iterative show the result on the output window.

Insert some data to the created table using the code

Statement stmt = null;

stmt = con.createStatement();

String SQL = “INSERT INTO ZanduBaam (Name,Roll) VALUES (‘Abhishek’,40)”;

int rowsEffected = stmt.executeUpdate(SQL);

System.out.println(rowsEffected + ” rows effected”);

Inorder to retrieve data from database , I need to execute query on the SQL Server and get the result back to me. First, I created stmt (Statement object) and execute query in SQL language. Then I store the result on ResultSet object and iterative show the result on the output window.

ResultSet rs = null; // SQL query command String SQL = “SELECT * FROM ZanduBaam”; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); while (rs.next()) {
System.out.println(rs.getString(“Name”) + ” : ” + rs.getString(“Roll”));
}

Similarly you can do the required for updation and deletion .

Lots of time and sweat devoted to this post considering the fact that I have a test on Monday I should stop here.

Bbye.

My First Session On Netbeans IDE and J2SE

This was the debut session conducted by me as a CA . In the first part of my Demo I covered many topics related to Netbeans Intelligent Text Editor and showed them techniques like Code-Insertion , Code-Refactoring ,Using Javadoc , Live Code Parser and error checker , Local History , Code completion , Instant renaming , Compile on Save,and lots of other cool stuffs. I explained them how to use the Profiler and the Debugger. I explained them the use of Version Control and automated testing (Unit Testing) .

This was followed by a basic demonstration on the Swing Gui Builder and with functionalities like Automatic feedback , Quick Component Insertion , Anchoring , Alignment . After this I expained the basic features of event handling and demonstrated it with a small application built using the Swing Builder .

As people asked for more meat so I continued out of my plan to demonstrate them easy Data Binding using MySQL database , JTable and Java Persistence API showing them how to createa CRUD application in 5 mins! On audience demand I also showed them how to import an existing PHP-MySQL project in Netbeans and showed them advantage of using WEB 2.0 frameworks like JMaki and Dojo directly into the existing PHP project. I gave them an introduction to Visual Web Java Server Faces by demonstrating them how to populated a Woodstock Table from a MYSQL database using simple drag-drop.

Many obvious questions like why Netbeans over Eclipse which I think I answered satisfactorily. Many people came to me afterwards asking more details about multibooting Solaris and more about Web 2.0 and AJAX. I was on the top of the world when people actually clapped at the end of the talk. All in all a nice experience.

Here are some of the pictures from the Session