- 浏览: 93774 次
- 性别:
- 来自: 广西
文章分类
最新评论
-
李涤尘:
很好,很清晰的记录
Oracle 多表查询 -
yanxiaojia521:
项目部署成功后,使用localhost可以访问,在局域网内容访 ...
Linux系统下的项目部署 -
txlong_onz:
学好正则这些都不用记了。有的时候要灵活的。
文本框的输入限制
<!-- 各种SQL驱动的配置方式 --> <Beans> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-33</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Microsoft SQL Server (jTDS driver)</name> <url>jdbc:jtds:sqlserver://<hostname>[:<port>]/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.microsoft.jdbc.sqlserver.SQLServerDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-11</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Microsoft SQL Server</name> <url>jdbc:microsoft:sqlserver://<server_name>:<1433></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-29</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Derby</name> <url>jdbc:derby://<server_name>:<port>/<databaseName>[;create=true]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.hsqldb.jdbcDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-18</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>HSQLDB Server</name> <url>jdbc:hsqldb:hsql://<server>[:<1476>]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.enhydra.instantdb.jdbc.idbDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-5</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>InstantDB</name> <url>jdbc:idb:<pathname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.mimer.jdbc.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-12</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Mimer SQL</name> <url>jdbc:mimer:[//[<user>[:<password>]@]<server>[:<1360>]][/<dbname>][property-list]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>net.sourceforge.jtds.jdbc.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-34</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Sybase (jTDS driver)</name> <url>jdbc:jtds:sybase://<hostname>[:<port>]/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.pointbase.net.netJDBCDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-23</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Pointbase Embedded</name> <url>jdbc:pointbase:embedded:<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-2</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Oracle (OCI driver)</name> <url>jdbc:oracle:oci8:@<database_name></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.hsqldb.jdbcDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-17</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>HSQLDB Web Server</name> <url>jdbc:hsqldb:http://<server>[:<1476>]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.ibm.db2.jcc.DB2Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-30</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Derby (IBM Universal driver)</name> <url>jdbc:db2://<server_name>:<port>/<databaseName></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.sybase.jdbc2.jdbc.SybDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-8</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Sybase Adaptive Server Anywhere</name> <url>jdbc:sybase:Tds:<host>:<port>?ServiceName=<DBNAME></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.internetcds.jdbc.tds.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-16</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>jTDS (FreeTDS)</name> <url>jdbc:freetds:sqlserver://<hostname>[:<4100>]/<dbname>[;<property>=<value>[;...]]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>uk.co.thinksql.ThinkSQLDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-14</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>ThinkSQL</name> <url>jdbc:thinksql://<server>:<9075></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.postgresql.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-7</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>PostgreSQL</name> <url>jdbc:postgresql:[<//host>[:<5432>/]]<database></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.ibm.db2.jdbc.net.DB2Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-31</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>IBM DB2 (Universal driver)</name> <url>jdbc:db2://<host_name>:<port>/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.hsqldb.jdbcDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-20</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>HSQLDB In-Memory</name> <url>jdbc:hsqldb:.</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.sap.dbtech.jdbc.DriverSapDB</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-21</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>SAPDB</name> <url>jdbc:sapdb:[//host/]dbname[?name=value[&name=value]*]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.hsqldb.jdbcDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-19</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>HSQLDB Standalone</name> <url>jdbc:hsqldb:<databaseName></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.pointbase.net.netJDBCDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-22</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Pointbase Server</name> <url>jdbc:pointbase:server://<server_name>/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>sun.jdbc.odbc.JdbcOdbcDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-1</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>JDBC ODBC Bridge</name> <url>jdbc:odbc:<alias></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.sybase.jdbc2.jdbc.SybDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-9</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Sybase Adaptive Server Enterprise</name> <url>jdbc:sybase:Tds:<host>:<port>/<DBNAME></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.apache.derby.jdbc.ClientDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>77079d8e:11e6801bd64:-7fdf</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"> <Bean Class="net.sourceforge.squirrel_sql.fw.util.beanwrapper.StringWrapper"> <string>C:\Program Files\MyEclipse-6.0M1\myeclipse\eclipse\plugins\com.genuitec.eclipse.derby_5.9.100\lib\derbyclient.jar</string> </Bean> </jarFileNames> <name>MyEclipse Derby</name> <url>jdbc:derby://<host>:<port>/<db>;create=true</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-28</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Microsoft SQL Server 2005</name> <url>jdbc:sqlserver://<server_name>:<port>[;databaseName=<dbname>]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>COM.ibm.db2.jdbc.net.DB2Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-24</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>IBM DB2 (App driver)</name> <url>jdbc:db2://<host_name>:6789/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.axiondb.jdbc.AxionDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-13</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Axion</name> <url>jdbc:axiondb:<database-name>[:<database-directory>]</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>interbase.interclient.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-3</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>InterClient</name> <url>jdbc:interbase://<server>/<full_db_path></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.ncr.teradata.TeraDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-27</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Teradata</name> <url>jdbc:teradata:[//host[:1025]/]<database></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-4</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Oracle (Thin driver)</name> <url>jdbc:oracle:thin:@<server>[:<1521>]:<database_name></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.mckoi.JDBCDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-15</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Mckoi</name> <url>jdbc:mckoi://<host>[:9157][/<schema>]/</url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.mysql.jdbc.Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-26</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>MySQL Connector/J</name> <url>jdbc:mysql://<hostname>[<:3306>]/<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>org.firebirdsql.jdbc.FBDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-25</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Firebird (JayBird JCA/JDBC driver)</name> <url>jdbc:firebirdsql:[//host[:port]/]<database></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.ibm.db2.jdbc.net.DB2Driver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-32</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>IBM DB2 (Universal Type 2 driver)</name> <url>jdbc:db2:<dbname></url> </Bean> <Bean Class="net.sourceforge.squirrel_sql.fw.sql.SQLDriver"> <driverClassName>com.sunopsis.jdbc.driver.xml.SnpsXmlDriver</driverClassName> <identifier Class="net.sourceforge.squirrel_sql.fw.id.UidIdentifier"> <string>-10</string> </identifier> <jarFileName/> <jarFileNames Indexed="true"/> <name>Sunopsis XML</name> <url>jdbc:snps:xml?f=<file-name>&ro=true</url> </Bean> </Beans>
发表评论
-
Java字符编码(第一篇)
2012-05-17 15:12 0Java字符编码 1. 第一篇:字符编码概念基 ... -
java程序调用bat文件,执行oracel数据库备份
2011-11-07 13:06 1494import java.io.BufferedReader; ... -
获取任意java类实例的方法和属性,包括父类的方法和属性
2011-04-14 16:53 2770import java.lang.reflect.Field; ... -
java反编译
2011-04-04 12:08 772java反编译工具jad 1.5.8g ... -
CHM帮助文档制作
2011-04-04 12:06 2134CHM帮助文档制作 下载软件:jd2chm.exe ht ... -
MyEclipse下远程调试liunx下的代码
2011-03-23 10:58 2116MyEclipse下远程调试liunx下的代码 在编译好的c ... -
Linux系统下的项目部署
2011-03-17 20:42 2109Linux系统下的项目部署 第1章 系统配置 ... -
Excel正常显示全部由数字组成的长字符串
2011-03-09 10:19 2573Excel正常显示全部由数 ... -
for 循环的使用技巧
2011-01-29 18:28 1787for 循环的使用技巧 在程序设计中,经常要进行程序流程 ... -
java网络编程 多线程服务器与客户端系统架构 socket应用
2011-01-14 17:31 2246java网络编程 多线 ... -
struts-config.xml 文件的配置
2011-01-14 14:42 600<?xml version="1.0" ... -
web.xml 文件的完整配置
2011-01-14 14:41 1080<?xml version="1.0" ... -
jsp+javabean实现分页
2011-01-14 14:38 1818此分页程序只用到三个文件test.jsp(用于显示分页结果的J ... -
AjaxAnywhere的配置
2011-01-14 14:21 1479AjaxAnywhere的配置 ajaxany ... -
在JAVA中使用JDBC连接数据库
2011-01-14 14:15 814package net.xiaoxiang.sql; i ... -
在JAVA中使用ODBC连接数据库
2011-01-14 14:14 2519package net.xiaoxiang.sql; i ... -
Log4J配置
2011-01-14 14:09 820------------------------------- ...
相关推荐
DBeaver连接sqlserver驱动,用于解决DBeaver不能下载驱动问题。请参见压缩包中的说明方法放置。
用于配置hive驱动,详细配置过程可参考https://blog.csdn.net/qq_32284189中SQuirrel SQL Client数据库连接工具的配置与使用
在安装ODBC驱动后,能通过ODBC访问SQL Server 数据库。
mssqlserver驱动 mssqlserver驱动 sqlserver2000-驱动
因为SQLexpress服务器默认是禁用的并且端口号没有配置,所以要进行重新设置 2.如果你以前用java连接sql server 2000的话就要注意了: 在sql server 2000 中加载驱动和URL路径的语句是 String driverName = ...
php7.4版本适配SQL-server数据库的驱动,详细配置方式查看相应文档
Eclipse 配置用到的SQl驱动
JAVA的MySQL驱动,SQLServer驱动,Oracle驱动
php5.3以后不在支持mssql需要使用php_sqlsvr.dll来连接sqlServer,微软不支持64为驱动,资源中32位、64为的dll和驱动都有
spring框架下使用德鲁伊连接池配置连接sqlServer2012,需要此包sqljdbc.jar下的com.microsoft..sqlserver.jdbc.Driver
SQl2005 驱动 jdbc链接配置
本人通过学习经验所总结的sql server 2008 r2 安装 + JDBC配置,如有不足望大家指出。
里面包含了tomcat容器配置连接池时,需要用到的数据库驱动
Java数据库驱动Jar和访问配置,包括DB2数据库,MySQL数据库,Oracle数据库,SQLServer数据库和达梦7数据库
数据库驱动包,(sybase驱动,sqlserver驱动,oracle驱动,mysql驱动,含sqlserver2005和2000的java纯连接数据库的方法,含mysql驱动配置)
JDK 1.8, SQLServer2014,都是最新版本。从SQL安装过程中的注意事项到中间配置、驱动,到eclipse的配置,一站式解决案例
SSM如何连接sqlserver数据库?目前网上的几乎都是连接mysql的。替换src目录下的configuration.properties,以及WEB-INF目录下的context.xml文件就可以连接上了。lib目录下加入sqljdbc42.jar用于连接Sqlserver。再把...
java连接数据库时所需要的驱动环境包,依赖于java环境1.7,1.8请下载,另关于jdbc驱动的配置请自行百度,帖子较多,就不在赘述。
将SQL Server 2000的光盘插入CD-ROM驱动器之后,SQL Server的安装程序会自动启动。如果该光盘不自动运行,请双击该
用于解决SQLSERVER连接问题驱动程序无法通过使用安全套接字层(SSL)加密与 SQL Server 建立安全连接问题JAR包。