1.oracle
Thin driver Connection string: Jdbc:oracle:thin: User name/password @localhost:1521:cake
Driver class: Oracle.jdbc.driver.OracleDriver
2.mysql
Connection string: jdbc:mysql://localhost:3306/database name? useunicode=true&characterencoding=utf-8
Driver class: Com.mysql.jdbc.Driver
3.SQl Server
Connection string: Jdbc:microsoft:sqlserver://localhost:1433;user=sa;password=sa;databasename= database name
Driver class: Com.microsoft.jdbc.sqlserver.SQLServerDriver
MicroSoft SQL Server 2005
String classstr= "Com.microsoft.sqlserver.jdbc.SQLServerDriver";
String constr= "jdbc:sqlserver://127.0.0.1:1433;databasename=mydatabase";//Note Port number
MicroSoft SQL Server 2000
String classstr= "Com.microsoft.jdbc.sqlserver.SQLServerDriver";
String constr= "Jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs", "sa", "password"
Mysql
"Com.mysql.jdbc.Driver"
"Jdbc:mysql://localhost:3306/login?useunicode=true&characterencoding=utf-8", "root", "7415"
Oracle
"Oracle.jdbc.driver.OracleDriver"
"Jdbc:oracle:thin:@10.0.0.248:1521:ora9", "username", "password"
ODBC Bridge Connections
Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=drivermanager.getconnection ("jdbc:odbc:jsp");
Ways to connect a variety of data in Java