weishaoxiang
- 浏览: 93773 次
- 性别:
- 来自: 广西
-
文章分类
最新评论
-
李涤尘：
很好，很清晰的记录
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包。