Java - DataBase Connections

For those who are working in selenium and related automation tools using Java API are in need of connecting back end databases to verify the values. Here is the high level info.
Required package:

1. import java.sql.*;

Code Sample:

1. //Initializing the driver for JDBC connection
2. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
4. //Creating properties to be passed for connection
5. Properties properties = new Properties();
6. properties.put("user", "shan");
7. properties.put("password", "pass");
8. properties.put("characterEncoding", "ISO-8859-1");
9. properties.put("useUnicode", "true");
11. //actual connection string
12. String url = "jdbc:mysql://ServerName:port/DataBaseName";
14. //Getting the connection object using properties and url
15. Connection conn = DriverManager.getConnection(url, properties);
17. //Creating a statement of type CreateStatement
18. Statement stmt = conn.createStatement(); //for Insert/Update, create of type conn.executeUpdate
19. String sql = "select * from [Sheet1$]";
20. RecordSet rs = stmt.executeQuery(sql);
21. while(rs.next()){
22.    username = rs.getString("username");
23.    password = rs.getString("Password");
24. }

Here are the driver and Connection String for different DBs.
MySQL:
Driver: Class.forName("com.mysql.jdbc.Driver").newInstance();
URL   : jdbc:mysql://serverName:port/DBName
Derby:
Driver: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
URL   : jdbc:derby:pathToDB:DBName;create=true;
SQL:
Driver: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
URL   : jdbc:microsoft:sqlserver://serverName:port/DBName


Refer http://www.linglom.com/2007/03/04/accessing-sql-server-on-netbeans-using-jdbc-part-i-create-a-connection/