Java Database codes-for beginners

Steps for connecting and accessing Databases using Java-For Beginners

1> Establishing Connection

1> Load drivers
class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

2> Make Connection
Connection con=DriverManager.getConnection("dataSourceName","userName","password");

3> Creating JDBC statement
Statement stmt=con.createStatement();

4> For creation, Updation, Insertion, Deletion
stmt.executeUpdate(string query);

5> For Retieving values from the database
ResultSet rs=stmt.executeQuery(String query);
while(rs.next())
{
String str=rs.getString(fieldName);
Float fl=rs.getFloat(fieldName);
}
6> Closing the Connection
stmt.close();
con.close();



Note:-
1> before this database needs to be created.
2> data source name also needs to be created
http://support.microsoft.com/kb/305599
(for creating data source name.)