Abhishek Gupta

The Sun won’t set at NIT Durgapur !

Database connections in Java using JDBC and Netbeans IDE

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.

9 Responses to “Database connections in Java using JDBC and Netbeans IDE”

  1. Rach said

    Thank you very much…it ws very helpful.

  2. Thanks for the simple tutorial, but if you use the Netbeans IDE’s GUI Builder then this post can be helpful- http://bit.ly/STSd27

  3. Versuvious said

    hahhahahaahha thanx buddy its not shortcut. i dont wana do hardwork i m doing smart work like inheriting your knowledge:p

  4. anonymous said

    Thanks a lot.. helped me a lot.. 🙂

  5. anupam pradhan said

    its gud but not best

  6. anshul said

    thanksss

  7. Vincent said

    I’m willing to go through the hard way. Please show me where to learn.

  8. ravi said

    where to write this code
    Statement stmt = null;
    ??
    in sql query ?
    stmt = con.createStatement();

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

    int rowsEffected = stmt.executeUpdate(SQL);

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

  9. Anonymous said

    Wanna ask to write any query we need to store in a string type and then to execute it we need to use resultSet object and while loop.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: