FunFuni

COMPLETE DATABASE CONNECTIVITY IN JAVA (MySQL-JDBC DRIVER-JAVA)

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Tue, 25 Jan 2011 06:01:00 +0000

Hello Friend,
Today I am writing about COMPLETE DATABASE CONNECTIVITY IN JAVA. The reason behind writing on this topic is it's very difficult to find help on this topic and if we found it's in pieces, because there is no help for complete database connectivity. Even in books JDBC topic is quite hazy.
So here I am throwing some light on this topic :-).
For convenience post is divided into three parts :-

Installing and configuring MySql.
Installing and configuring JDBC Driver (Connector/J in this example)
Java Program to handle and manipulating data

Installing and configuring MySql.

Download MySql Community Server zip file(without installer) compatible to your windows.
Create new folder name it "mysql"(without quotes) Extract the zip file on that folder.
Now open your command prompt and go to the mysql directory that you created and then go inside the extracted directory something like(mysql-5.5.8-winx64) then bin.

C:\>cd C:\mysql\mysql-5.5.8-winx64\bin
Now type command "mysqld"(without quotes) Hit Enter
Allow access if firewall is blocking mysqld.exe hence your MySql server starts.
Remain this command prompt open and open new Command Prompt and repeat Step 3. again
Type mysql -u root
C:\mysql\mysql-5.5.8-winx64\bin>mysql - u root
Notice you will get the mysql> prompt.
Now select database mysql using following command:
mysql> use mysql
Now change the password of root user for security purpose use following command
mysql> UPDATE user SET password = PASSWORD('urpassword') WHERE user = 'root';
Now to delete ghost account use following command:
mysql> DELETE FROM user WHERE user = '';
Now just quit from mysql using following command:
mysql>quit
Your Topic number I is completed let's move to next step(Driver Installation)

Installing JDBC driver

For JDBC connectivity to MySql we are using Type-4 driver Connector/J
Again download the zip file for windows user.
Create new folder named as "jdbc"(without quotes) in C:\ and extract the zip file in that folder
Now we have to set Classpath to install JDBC Driver
Right click on my computer and select properties and Advanced Settings then click to environment variables
Now in System variables edit Classpath variable and at the end of it's value there should be semicolon to end the previous path than past your jdbc directory address ends with .jar file driver name and then semicolon in the end.
Now save it and your driver is also installed. :)

Java Program to handle and manipulating data

import java.sql.*;<br />
public class SimpleConnection {<br />
    public static void main(String args[]) {<br />
        Connection con = null;<br />
        try {<br />
            Class.forName("com.mysql.jdbc.Driver").newInstance();<br />
            con = DriverManager.getConnection("jdbc:mysql:///mysql", "root", "urpassword");<br />
            if (!con.isClosed()) {<br />
                System.out.println("Successfully connected to MySQL server...");<br />
                Statement stmt = con.createStatement();<br />
                ResultSet rs = stmt.executeQuery("SELECT user,host FROM user WHERE user = 'root'");<br />
                while (rs.next()) {<br />
                    System.out.println(rs.getString("user") + " " + rs.getString("host"));<br />
                }<br />
            }<br />
        } catch (Exception e) {<br />
            System.err.println("Exception: " + e.getMessage());<br />
        } finally {<br />
            try {<br />
                if (con != null) con.close();<br />
            } catch (SQLException e) {}<br />
        }<br />
    }<br />
}

Facebook Status-size changer

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Sun, 16 Jan 2011 07:57:00 +0000

Hi Friends,
As we all know that Facebook new update is quite annoyed as they changed the Facebook status size.
Facebook designers thinks that this awesome but none of the user is comfortable with the update.
As I am also one of you I'm also annoyed with this and started thinking some tweak for this and I got an Idea SirJII....
So an idea rings why not to create a small simple JavaScript for this and that works. But another problem came into is how to use this javaScript for Facebook every time user loads it?
Then I got some interesting thing that I can create Extensions for Google Chrome Browser and whola it's awesome now.

But this solution only work in Google Chrome and might work in Opera too as opera has it's userjs API however I didn't tested this on Opera.

Old Facebook Status settings just a Click Away!!

Install

Facebook Status before installation:

Facebook Status After installation:

Is your phone ringing ? :D (Toot Tone)

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Wed, 18 Aug 2010 03:39:00 +0000

7x13=?

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Sun, 08 Aug 2010 04:29:00 +0000

MEN'S BRAIN VS WOMEN'S BRAIN

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Sun, 08 Aug 2010 04:26:00 +0000

Ways To Be HappY

mahendru.saurabh@gmail.com (Saurabh Mahendru) — Mon, 02 Aug 2010 06:52:00 +0000

Hi My name is Saurabh Mahendru.

I created this blog to put forward a step to feel happiness. Throughout this blog I will try to low down some stress from your shoulder and make you feel happy with some humorous and funny things or with some good thoughts.

So I am starting with some ways to be happy. I read somewhere that we should do atleast 12 things if we want to be happy so I m sharing that first.

12 Necessities to feel happiness:-

Make up your mind to be happy.
Do some things that help others.
Appreciate your friends' smiles by giving nice comment on it(Hey, dis looks good on you.)
Live in the moment.
Find happiness in others
See yourself in mirror smile at glance and appreciate yourself as we know everyone looks beautiful while smiling
Do small and bunch of things that makes your sole happy that you did so much things ;-)
Remember your great moments with your special one.
There is always two sides one is positive and the other is negative. Keep positive side in your heart and negative for mind so that mind can find solution and negative will not exist.
Do things in which you find pleasure in a long run.
Always know that we all are the creators of our present. So if right now it's not seems to be good enough, in future we have to do much better so that our future seems to be the way we want.
The last I want to be filled by you via comment because that's more precious what you think. :-) ....................................