How To Establish Java MySql Connection

Connect your java program to MySQL database in 5 simple steps

Accessing a database is one of the basic and essential function that a java program has to perform. So let me help you to connect your java program to a MySQL Database.

Follow these procedures carefully to establish MySQL database connectivity in your java program.


STEP 1 :Download and install MySQL. If you don't have  MySQL installed on your system then download it. 

                                                You can download MySQL from here.

STEP 2: Configure MySQL using "Server Instance Configuration Wizard" (It automatically runs after installation,if not you can start it from MySQL installation folder). It will prompt you to set a password for the database.This password will be required to access the database.

STEP 3: Download JConnector From here. Jconnector is a .jar file which makes the Java-MySQL connection Possible.

STEP 4: Copy the downloaded "mysql-connector-java-5.0.8-bin.jar"(version number may vary)  file from the downloaded package to the location specified below.
          
             Java Installation Folder->jre->lib->ext
        
            Example:  E:\Java7\jdk1.6.0_21\jre\lib\ext

STEP 5: Now is the coding part.We have to include java codes for accessing the database in the program. We have to import java.sql package to the program for that purpose A sample code for establishing Connection is given below.(The code is partial and ephasise only database access)



import java.sql.*;

try
{

/*For Loading Driver*/

Class.forName("com.mysql.jdbc.Driver").newInstance();    

/*For creating a connection with Mysql database*/

Connection c=DriverManager.getConnection("jdbc:mysql://localhost:3306/Database_name","root","password");



/*For creating a Statement*/

Statement d=c.createStatement();


/*For retrieving result and for executing query*/

ResultSet rst=d.executeQuery("select item from login");
while(rst.next())
{
item=rst.getInt(1);
}


/*closing the statement*/

d.close();


/*closing the connection*/

c.close();


/*For catching and  displaying exceptions if any*/
}catch(Exception e)
{
System.out.println(e.getMessage());
}


You can learn more about JDBC and java sql codes in Oracle Tutorials.

Earn Money Blogging

A Blog is much similar to a mini-website.The name blog evolved from the word 'web log'. Before you enter the world of blogs, it will be better that you read my article about content writing.

Selecting a Niche For Your Blog

This is the most important step which can be a deciding factor of your success as blogger.You should select a topic as per your area of interest, not based on the commercial interests. It is important that the topic should be of your interest, if you want to provide good quality content for your readers.To know more about topic selection and tips, read my article  Earn Money Online Through Content Writing.

Registering a Domain

You will need a top level domain in order to get fast approval of the ad programs and affiliate programs. Ads and affiliate programs are major income sources of a blog.Top level domains gives higher search engine visibility and ranking. You can make use of a free domain registrar like co.cc or .tk. But now a days search engines are demoting these free domains so you better register a commercial domain like .com or .co or any other related to your region.

                                           

                                     REGISTER A FREE TOP LEVEL DOMAIN HERE

OR

REGISTER A COMMERCIAL DOMAIN 

Custom domains are very much required to retain your readers and subscribers when you change your host or platform. My advice is go for a commercial domain. It will only cost you about $7 a year.

Find a Host For Your Blog

The next step is to find a host for your blog who allows advertising.For that you can depend blogger. Blogger is free blog hosting service of google. Blogger allows its users to create blogs and publish it on custom domains. That is you can use the custom domain registered in above step with a blog in blogger. Blogger is one of the worlds popular blogging platforms. It is very easy to start blogging with Blogger.You don't need any knowledge in html or other technical expertise to use blogger.

• Go to blogger.com
• Sign up for an account if you don't have one
• Hit "create a blog" button to create a new blog after signing in.
• You will learn more as you go along. Take a tour through blogger features.
• You can watch blogger video tutorial if you want to learn blogger quick and easy.

                                           

 CREATE A BLOGGER ACCOUNT HERE

OR 

You can use other platforms like wordpress. But if you don't wanna pay for hosting then blogger will be the best choice. 

If you are ready to purchase hosting then I would recommend setting up your blog with a free host first and then moving towards a paid host or upgrade your account to paid hosting account. Because it will take some time to put up hosts. A free account will be sufficient to handle your traffic at the initial stage of your blog. You can get free hosting in the link below.

REGISTER A FREE HOSTING ACCOUNT

Preparing Your Blog

 

•  Setting up the blog to use custom domain

While creation of your blog you will be given a blogspot subdomain like yourblog.blogspot.com if you are using blogger.Now you have to configure your blogger blog to use the custom domain. This procedure is explained in this video.

• Posting on your blog

Write posts as frequent as possible.Try to write at least one post per week because posting frequency is a very important factor in generating traffic and in keeping your current readers satisfied.

• Designing your blog

Design your blog template is also important. Select a template which is attractive and is suitable for your niche. Enable Feed subscription and Email feed subscription by signing up on feedburner. Twitter is also a good tool for keeping your regular readers updated about new posts.

 Monetization Of Your Blog

In-order to earn money from blogging you have to convert your visitors into money. For that you have to do any of the following.

• Sign up for an Ad Publisher Program

You have to sign up for one of the ad publisher programs as a primary means of earning money from your blog. Adsense is the best one around.Blogger Provides in built support for Adsense.But dont expect to get approved by Adsense easily. Your blog must be atleast 6 months old and should have good traffic inorder to get adsense approval.So it will be wise to apply for an adsense account only after 6 months.

You can sign up for publishers like Infolinks, Bidvertiser etc as an alternative option.

• Sign up for affiliate programs

You can sign up for affiliate programs like amazon affiliates if you plan to sell  or promote their goods like books DVDs etc. They will pay you commission for each sales through your blog.A whole lot of affiliate programs are there in the web. Just google them out.

Driving Traffic To Your Blog

Traffic is the factor that decides how much you earn from your blog. Earnings of your blog is directly linked to the traffic. So in-order to Earn money from Blogging you must ensure good traffic to your blog.For that

• Advertise your blog well among your family and friends.
• Use social networking tools such as Twitter and Facebook for exposing your blog.
• Read other blogs with same niche and make relevant comments on them. This will increase your traffic considerably.
• You can make use of google adwords to purchase traffic to your site if you have money to spend on it.

GOOD LUCK !!

 source:- Originally taken from my knol article (google knol)

Earn Money Online Through Content Writing

About Content Writing

Good quality content is the back bone of any successful website. So those who can provide good quality content have wide opportunity on Internet.

• Are you good at writing ?                          

• Can you find pleasure in writing about your favorite subjects ?

    
Then you are perfect to start a carrier as a content writer(say Author) on Internet. You don't have to be a Shakespeare for this. What you need is, Interest and Expertise in some subject of your choice and the ability to express it in words. Information is provided here considering you as a beginner in this field. Which subject you are interested in  doesn't really matter. Every subject have its own scope and its own class of readers.You will never run out of readers if you provide good quality content.

Warning and Facts:

• Never select the topic keeping earnings in mind because that will result in lack of interest and laziness to write.In this way you will eventually stop writing and fail like the majority who makes the same mistake.

• Select the subject of your interest and make it a hobby writing about it on the net. You will love to learn new things about your favorite subject. You will never fail that way.

• This is not for those who want to be rich overnight through Internet.

• You have to put time and effort in this, in order to succeed (If its about your area of interest you will never know the roughness of the path).There is no quick and easy way to earn money.

•  Reward is guaranteed in money & respect , if you follow the right path to become a successful author.

• You can write about what ever you want, but always remember the fact that "Content Is King".

 

List Of Sites Where You Can Earn Online By Content Writing
 

Here is some information which i think, will be useful to you to start a carrier as a content writer. Listed below is a list of some sites through which you can make money online through content writing.

 

Ehow
Ehow is a good option for making money online by writing simple articles. Ehow is a Know-how website which contains articles about "how to do things". If you know "how to do something" ,then you can write an article on ehow. Ehow pays to its authors depending on the popularity and viewing statistics of  articles. They call it the Writers Compensation Programme.You can also write good content rich articles for ehow and get rewarded for it. What you have to do is, to give a step by step description of "how to do something". Simpler the article the better the ratings will be.But you shouldn't compromise on the content quality inorder to make your article simpler.

Hubpages
Hubpages is an online space where you can share your knowledge. You can write useful tips,advices,reviews etc on your hubpages.Hubpages is free to join. You can earn income online from hubpages through Adsense,Ebay and Amazon assosiates.

Squidoo
Squidoo is similar to hubpages.Its free to use and you can write about anything in it you are passionate about.Articles written in squidoo are called lens.You can earn money based on the perfomance of your lens.You will be paid through paypal. Another advandage of squidoo is that you can custom set your minimum payout. You can even donate the amount you earnned to charity if you like.

         

Bukisa

Bukisa is also a online space where you can share your knowledge.You can earn from bukisa by posting articles, images, videos etc. You will get a baseline payment per 1000 unique visitors.The baseline payment or as they called it 'Bukisa Index' depends on the popularity of your articles and you as an author. Minimum payout is $10 and you will be paid through your paypal account.

Xomba
In Xomba you can earn money by sharing information and writing articles.Xomba is a free community that allows users to earn money through writing and sharing information. You can earn money through adsense on 50-50 revenue share basis.

Helium

Get paid for writing good quality content.

ReviewStream

Review stream is a site where you can write online reviews and get paid for it.You will be paid for every published review. Payment is via PayPal.

 Flixya

 Make money here by sharing photos,videos,Blogs etc.

epinions

Earn money online by sharing your opinion and reviews.

Reviewparty

Write online reviews and get paid through Adsense and Amazon assosiate programs. 

AssociatedContent

AssociatedContent is a space where you can publish text articles as well as media of all kind like pictures, videos and audio files. Here articles are inspected by AssosiatedContent staffs before publishing. Payment varies according to the popularity and number of views of your article. As you become more and more popular as a author your payment rates will also increase.

softwarejudge

Write reviews about softwares and get paid. Payment is via PayPal.

 

Some Other Options To Consider

 

Pickydomains is another website you might be interested if you have a little creative thinking. Here you must suggest domain names for websites with specific needs. If your suggestion is picked you will earn 25$ and you will get paid through PayPal.

Rupeemail is an email ad service for residents of India.Rupeemail pays you for reading their emails. Rupeemail have a mail frequency of about 5 mails per week.When you reads rupee mails your account gets credited with money.Payment is through cheque.

source: Originally taken from my knol (google knol)