Java Database Connectivity (JDBC) with MySQL

A simple code that finally brought cheer on our face..

Arif and me tried to connect to our mysql database using java.

We have done it and were able to connect using odbc driver with ms access. The experiment with mySql was preety difficult without an instructor but finally we made it.

 

We had to download this file (mysql-connector-odbc-5.1.6-win32) from mysql website for our machine.

Once the installation was complete, we went to control panel>administrative tools>odbc driver and picked it up.

 

Next task it to perform queries on our database

 

Hope everything goes fine

 

If you want to connect your mysql with a java program and have any issue, I can certainly help you now as am familiar with it now. J

 

Happy coding J

 

Filename db.java

import java.sql.*;

class db

{

 public static void main(String args[])

 {

 

                try

                {

         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

         Connection con=DriverManager.getConnection("jdbc:odbc:data","root", "*****");

        

             if(!con.isClosed())

              System.out.println("Successfully connected");

 

 

                                               

                }

 

                catch(Exception e)

                {

                System.out.println("Exception"+e);

                }

 }

}

___

Love Marshall



 

Comments

Post a Comment

Popular posts from this blog

I feel shame for Facebook Groups like "Growing INDIA, Growing Ourselves & making INDIA a better place to live in". They are capitalizing the Delhi Rape Case. Read how dirty is the Indian Politics where They ignore a Rape in Gujrat under Modi rule and Blame ladies like Sheila Dixing and Sonia for rapes. Stay Alert my Friends

Image
I feel shame for Facebook Groups like "Growing INDIA, Growing Ourselves & making INDIA a better place to live in". They are capitalizing the Delhi Rape Case and Spreading Bad News against Congress while at the same time a 2 Years old Girl is Raped and Killed and thrown in bushes but they did not speak anything on their Facebook page of 6 lack members. The motto is clear, to defame congress. But My question is why to deceive the youth of my country? Why to do politics on the dignity of a sister who is strugling for life. The world must understand that it's not sheila, modi or sonia, its the bad people who do this thing. We should not target a party for this, we should not capitalize the dignity of an Indian girl. What a shame to see when BJP send out its online agents to spread the hate and try to capitalize issues like this. If you visit the page on facebook after searching by it’s name, and scroll to the Dec 2012 month posts (last 10 days), you will se...
Read more

Unwanted spam calls from +91-731-xxx-xxx

Image
There have been a large number of unwanted calls being received from numbers tarting +91-731 This is a pain and there is no way I can find to stop it. This is happening on a mobile number registered in DND registry of India and have selected to not receive any kind of promotional calls etc.
Read more