JDBC driver connection url
来源:互联网 发布:哈尔滨拼车软件 编辑:程序博客网 时间:2024/06/07 00:01
JDBC connection url JDBC connection url 1、Oracle8/8i/9i数据库(thin模式) Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID String user="test"; String password="test"; Connection conn= DriverManager.getConnection(url,user,password); 2、DB2数据库 Class.forName("com.ibm.db2.jdbc.app.DB2Driver ").newInstance(); String url="jdbc:db2://localhost:5000/sample"; //sample为你的数据库名 String user="admin"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); 3、Sql Server7.0/2000数据库 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb为数据库 String user="sa"; String password=""; Connection conn= DriverManager.getConnection(url,user,password); 4、Sybase数据库 Class.forName("com.sybase.jdbc.SybDriver").newInstance(); String url =" jdbc:sybase:Tds:localhost:5007/myDB"; //myDB为你的数据库名 Properties sysProps = System.getProperties(); SysProps.put("user","userid"); SysProps.put("password","user_password"); Connection conn= DriverManager.getConnection(url, SysProps); 5、Informix数据库 Class.forName("com.informix.jdbc.IfxDriver").newInstance(); String url = "jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver; user=testuser;password=testpassword"; //myDB为数据库名 Connection conn= DriverManager.getConnection(url); 6、MySQL数据库 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicod e=true&characterEncoding=8859_1" //myDB为数据库名 Connection conn= DriverManager.getConnection(url); 7、PostgreSQL数据库 Class.forName("org.postgresql.Driver").newInstance(); String url ="jdbc:postgresql://localhost/myDB" //myDB为数据库名 String user="myuser"; String password="mypassword"; Connection conn= DriverManager.getConnection(url,user jdbc的配置: 1.旧jdbc(2000): driverClass 是 "com.microsoft.jdbc.sqlserver.SQLServerDriver"; jdbcurl 是 "jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=test;characterEncoding=gb2312". 2. 新jdbc(2005): driverClass 是 "com.microsoft.sqlserver.jdbc.SQLServerDriver"; jdbcurl 是 "jdbc:sqlserver://127.0.0.1:1433;database=test;characterEncoding=gb2312“
转自:http://hi.baidu.com/ou_yang_/blog/item/8b2c412c8782a4e98b139906.html
- JDBC Driver Connection URL
- JDBC driver connection url
- JDBC Driver and Connection summarize
- Oracle JDBC URL和Driver
- Oracle JDBC URL和Driver
- [SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
- DB2 JDBC driver's bug?, Connection is closed
- [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
- 1.通过原始的Driver接口获取JDBC数据库连接Connection
- JAVA-21-JDBC讲解,Driver、Connection、Statement、PreparedStatement、CallableStatement、ResultSet
- Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL ****
- Cannot create JDBC driver of class '' for connect URL 'null'
- Cannot create JDBC driver of class '' for connect URL 'null'
- Cannot create JDBC driver of class '' for connect URL 'null'
- Cannot create JDBC driver of class '' for connect URL 'null'
- cannot create jdbc driver of class '' for connect url 'null'
- No suitable driver found for jdbc:mysql:URL
- 用jdbc连接sqlserver数据库,driver和url问题
- [转] 根据文件的Handle获取文件路径
- android往文件中保存和读取数据
- layout_gravity 和 gravity以及对应值的详解
- vc6.0无法使用“添加到工程”或者"打开文件"解决方法
- jQuery基础学习总结
- JDBC driver connection url
- 使用JQuery validate插件进行客户端验证
- 输入验证码进入 万年历系统 1
- 得到两个list的合,交,并,差
- WriteProfileString 函数 , WritePrivateProfileString 函数, WritePrivateProfileStruct 函数
- 分享几本专业书籍及一些文档的链接
- Passwd文件内容含义
- 华为通信基础面试题库以及答案
- Ruby test unit的几点注意事项