SQL執行工具

程式:(sql.jsp) (2003/05/19初版, 2008/01/18修改)

JDBC 連結各家資料庫的設定 (2005/02/25)
資料庫種類               驅動程式名稱設定                              連結設定                                                     日期格式(Date)                                          Driver
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------
MySQL (JDBCDriver)       com.mysql.jdbc.Driver                         jdbc:mysql://[HOST]:[PORT]/[DSN]                             "2002/12/31 15:23:45"
MySQL (MYSQLDriver)      com.caucho.mysql.jdbc.mysql.Driver            jdbc:mysql_caucho://[HOST]:[PORT]/[DSN]                      "2002/12/31 15:23:45"
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------
MS-SQL(SQLServerDriver)  com.microsoft.jdbc.sqlserver.SQLServerDriver  jdbc:microsoft:sqlserver://[HOST]:[PORT];databasename=[DSN]  "2002/12/31 15:23:45"
MS-SQL(JdbcOdbcDriver)   sun.jdbc.odbc.JdbcOdbcDriver                  jdbc:odbc:[DSN]                                              "2002/12/31 15:23:45"
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------
Access                   sun.jdbc.odbc.JdbcOdbcDriver                  jdbc:odbc:[DSN]                                              #2002/12/31 15:23:45#
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------
DB2 (APP)                COM.ibm.db2.jdbc.app.DB2Driver                jdbc:db2:[DSN]                                               "2002-12-31-15.23.45"
DB2 (NET)                COM.ibm.db2.jdbc.net.DB2Driver                jdbc:db2://[HOST]:[PORT]:/[DSN]                              "2002-12-31-15.23.45"
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------
Oracle9i                 oracle.jdbc.driver.OracleDriver               jdbc:oracle:thin:@[HOST]:[PORT]:[ORACLE-SID]                 TO_DATE("2002/12/31 15:23:45", "YYYY/MM/DD HH24:MI:SS")  classes12.jar
PostgreSQL               org.postgres.Driver                           jdbc:postgresql://[HOST]/[DSN]?[PARAM]=[VALUE]               "2002/12/31 15:23:45"
SyBase                   com.sybase.jdbc2.jdbc.SybDriver               jdbc:sybase:Tds:[HOST]:[PORT]                                "2002-12-31 15:23:45"
------------------------ --------------------------------------------- ------------------------------------------------------------ ------------------------------------------------------- ----------------

作者:Dana(Dana), cowwu@ms15.hinet.net, 2003/05/19
本文章公開於個人網站 http://www.dana.idv.tw
Home Copyright © Shu-Chen Wu