资源描述:
《JDBC连接数据库大全gb》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、JDBC里统一的使用方法Class.for(jdbcDriverName);Connectionconn=DriverManager.getConnection(url,user,password);这里的接口是统一的,不同的是每种数据库提供的jdbcDriver和Url不同我们一起来看看吧MySQL1.Class.forName("com.mysql.jdbc.Driver");2.Connectioncon=DriverManager.getConnection("jdbc:mysql://host:
2、port/database","user","password");复制代码Oracle数据库(thin模式)1.Class.forName("oracle.jdbc.driver.OracleDriver");2.Connectioncon=DriverManager.getConnection("jdbc:oracle:thin:@host:port:databse","user","password");复制代码Timesten数据库(thin模式)1.Class.forName("com.time
3、sten.jdbc.TimesTenDriver");2.Connectioncon=DriverManager.getConnection("jdbc:timesten:client:dsn=dsnname")复制代码MicrosoftSQLServer1.Class.forName("net.sourceforge.jtds.jdbc.Driver");2.Connectioncon=DriverManager.getConnection("jdbc:jtds:sqlserver://host:por
4、t/database","user","password");复制代码or1.Connectioncon=DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");复制代码DB21.Class.forName("com.ibm.db2.jdbc.app.DB2Driver");2.Connectionconn=DriverManager.getConnection("jdbc:db2://l
5、ocalhost:5000/sample",user,password);复制代码Firebird1.Class.forName("org.firebirdsql.jdbc.FBDriver");2.Connectioncon=DriverManager.getConnection("jdbc:firebirdsql://host:port/fdb_file_path","user","password");复制代码PointBase(Server)1.Class.forName("com.pointba
6、se.jdbc.jdbcUniversalDriver");2.Connectioncon=DriverManager.getConnection("jdbc:pointbase:server://host:port/databasename","user","password");复制代码HSQLDB(Server)1.Class.forName("org.hsqldb.jdbcDriver");2.Connectioncon=DriverManager.getConnection("jdbc:hsql
7、db:hsql://localhost:port/mydb","user","password");复制代码Derby 这个少有人听说吧,cloudscape应该听说过吧,该项目由此衍生1.Class.forName("org.apache.derby.jdbc.ClientDriver");2.Connectioncon=DriverManager.getConnection("jdbc:derby://host:port//mydb","user","password");复制代码1.Class.f
8、orName("org.apache.derby.jdbc.EmbeddedDriver");2.Connectionconn=DriverManager.getConnection("jdbc:derby:mynewDB",p);复制代码cloudscape1.Class.forName("com.cloudscape.core.JDBCDriver");2.Connectionconn=DriverManager.getC