数据库常用的数据模型有 浅析JAVA常用JDBC连接数据库的方法总结

浅析JAVA常用JDBC连接数据库的方法总结  

　　一 JDBC连接DB

复制代码 代码如下: Class forName("Com ibm db jdbc net DB Driver");   String url="jdbc:db ://dburl:port/DBname"   cn = DriverManager getConnection( url sUsr sPwd );  Class forName("Com ibm db jdbc net DB Driver"); String url="jdbc:db ://dburl:port/DBname" cn = DriverManager getConnection( url sUsr sPwd );

　　二 JDBC连接Microsoft SQLServer(microsoft)

复制代码 代码如下: Class forName( " microsoft jdbc sqlserver SQLServerDriver" );   cn = DriverManager getConnection( "jdbc:microsoft:sqlserver://DBServerIP: ;databaseName=master" sUsr sPwd );   Class forName( " microsoft jdbc sqlserver SQLServerDriver" ); cn = DriverManager getConnection( "jdbc:microsoft:sqlserver://DBServerIP: ;databaseName=master" sUsr sPwd );

　　三 JDBC连接Sybase(jconn jar)

复制代码 代码如下: Class forName( " sybase jdbc jdbc SybDriver" );   cn = DriverManager getConnection( "jdbc:sybase:Tds:DBServerIP: " sUsr sPwd );   Class forName( " sybase jdbc jdbc SybDriver" ); cn = DriverManager getConnection( "jdbc:sybase:Tds:DBServerIP: " sUsr sPwd );

　　四 JDBC连接MySQL(mm mysql bin jar)

复制代码 代码如下: Class forName( " gjt mm mysql Driver" );   cn = DriverManager getConnection( "jdbc:mysql://DBServerIP: /myDatabaseName" sUsr sPwd );   Class forName( " gjt mm mysql Driver" ); cn = DriverManager getConnection( "jdbc:mysql://DBServerIP: /myDatabaseName" sUsr sPwd );

　　五 JDBC连接PostgreSQL(pgjdbc jar)

复制代码 代码如下: Class forName( " postgresql Driver" );   cn = DriverManager getConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );   Class forName( " postgresql Driver" ); cn = DriverManager getConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );

　　六 JDBC连接Oracle(classes jar)

复制代码 代码如下: Class forName( "oracle jdbc driver OracleDriver" );   cn = DriverManager getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP: :ORCL" sUsr sPwd );   Class forName( "oracle jdbc driver OracleDriver" ); cn = DriverManager getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP: :ORCL" sUsr sPwd );

　　七 JDBC连接ODBC

复制代码 代码如下: lishixinzhi/Article/program/Java/JSP/201311/19892