1:mysql
mysql驱动名称:com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/sshdemo?useUnicode\=true&characterEncoding\=utf8&zeroDateTimeBehavior\=convertToNull
2:Oracle
Oracle驱动名称:oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@192.168.0.1:1521:orcl
3:sqlserver
Sqlserver驱动名称:com.microsoft.jdbc.sqlserver.SQLServerDriver
URL:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbname
public Connection getConnection()
{
try
{
Class.forName(classforname);
if (conn == null || conn.isClosed())
conn = DriverManager.getConnection( url, uid, pwd);
}
catch (ClassNotFoundException ex)
catch (SQLException ex)
return conn;
}