常用数据库JDBC连接写法

news/2024/5/18 21:49:17 标签: JDBC, Sybase, MySQL, Oracle, DB2
function StorePage() { d=document; t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():''); void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes')); keyit.focus(); }

1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );

2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );

3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );

4. Sybase(http://jtds.sourceforge.net)jconn2.jar
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
//(Default-Username/Password: "dba"/"sql")

5. Microsoft SQLServer(http://jtds.sourceforge.net)
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );

6. Microsoft SQLServer(http://www.microsoft.com)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );

7. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:" + sDsn, sUsr, sPwd );

8.DB2(新添加)
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
cn = DriverManager.getConnection( url, sUsr, sPwd );



http://www.niftyadmin.cn/n/605789.html

相关文章

php测试注入源码,SQL注入测试平台的搭建

SQLol是一个可配置得SQL注入测试平台,它包含了一系列的挑战任务,让你在挑战中测试和学习SQL注入语句,SQLol还是比较有创意的项目。一 SQLol的下载下载地址:http://github.com/SpiderLabs/MCIR二 安装步骤下载下来的时候一个.zi…

HTML与 Css样式

HTML---超文本标记语言&#xff08;Hypertext Markup Language&#xff09;描述网页文档的一种标记语言*后缀名是.htm或.html--只代表文件默认打开方式HTML元素是由单个或一对标签定义的包含范围 HTML标签&#xff1a;<>包围的关键词 成对出现开始结束标签/开发闭合标签C…

java 两个数组的差集,Java 数组差集实例代码

以下实例演示了如何使用 removeAll () 方法来计算两个数组的差集&#xff1a;Main.java 文件&#xff1a;import java.util.ArrayList;public class Main {public static void main(String[] args) {ArrayList objArray new ArrayList();ArrayList objArray2 new ArrayList()…

一个简单在jsp页面中连接sqlserver数据库的小实例

一个简单在jsp页面中连接sqlserver数据库的小实例。 <% page contentType"text/html; charsetGBK" %><html><head><title>connect the db</title></head> <% page import"java.sql.*"%>//不要忘了引入sql 包 &l…

Java开发人员的十大戒律

对Java开发者来说&#xff0c;有许多的标准和最佳实践。本文列举了每一个开发人员必须遵从的十大基本法则&#xff1b;如果有了可以遵从的规则而不遵从&#xff0c;那么将导致的是十分悲惨的结局。1&#xff0e; 在你的代码里加入注释每个人都知道这点&#xff0c;但不知何故…

关于UnicodeDecodeError: 'gbk' codec can't decode byte 0x88 in position 2: illegal multibyte sequence

当我运行python读取txt文件的时候&#xff0c;出现UnicodeDecodeError: ‘gbk’ codec can’t decode byte 0x88 in position 2: illegal multibyte sequence的错误&#xff1a; 退出代码是 1&#xff0c;所以文件有问题&#xff1b; 通过检查&#xff0c;确认代码没有问题 使…

JDBC-SQLSERVER2000

function StorePage() { ddocument; td.selection?(d.selection.type!None?d.selection.createRange().text:):(d.getSelection?d.getSelection():); void(keyitwindow.open(http://www.365key.com/storeit.aspx?tescape(d.title)&uescape(d.location.href)&cescap…