各种数据库驱动和URL地址信息

 

---

     名称               驱动名称            URL                                 类库名称

 

 

 

 

---

 

 

ODBC数据源       

sun.jdbc.odbc.JdbcOdbcDriver       

jdbc:odbc:数据源名                                  

无

 

 

 

---

 

 sqlServer2000              

 com.microsoft.jdbc.sqlserver.SQLServerDriver    jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名;characterEncoding=utf-8...

msbase/mssqlserver/msutil .jar

 

 

---

 

 mysql     

 com.mysql.jdbc.Driver    

jdbc:mysql://localhost:3306/数据库名称    

mysql-connector-java-3.0.16-ga-bin.jar

 

 

---

 

Oracle     

oracle.jdbc.driver.OracleDriver   

jdbc:oracle:thin:@localhost:1521:数据库名称      

classes12.jar

 

 

---

 

informix      

com.informix .jdbc.IfxDriver     

jdbc:Iformix-sqli://12.45.67.89:1533/数据库名称  

 informix.jar

---

 

 

 

---

 

PostgreSQL   

org.postgresql.Driver               

jdbc:postgresql://localhost/数据库名称              

pgjdbc2.jar

Sybase       

com.Sybase.jdbc.SybDriver     

jdbc:Sybase:Tds:localhost:5007/数据库名称         

jconn.jar

---

 

sqlserver 2005

driver :com.microsoft.sqlserver.jdbc.SQLServerDriver

url:  jdbc:sqlserver://localhost:1433;DatabaseName=CHIS;characterEncoding=UTF-8