f_2

集成了投票调查、流量统计、文件上传、留言版、论坛、软件下载、文章赏析、通讯录、网上购物 等板块 管理账户为peilei 密码为800901

常用数据库JDBC连接写法|peilei|1. MySQL([url]http://www.mysql.com)mm.mysql-2.0.2-bin.jar[/url]<br>Class.forName( &quot;org.gjt.mm.mysql.Driver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName&quot;, sUsr, sPwd );<br><br>2. PostgreSQL([url]http://www.de.postgresql.org)pgjdbc2.jar[/url]<br>Class.forName( &quot;org.postgresql.Driver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName&quot;, sUsr, sPwd );<br><br>3. Oracle([url]http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip[/url]<br>Class.forName( &quot;oracle.jdbc.driver.OracleDriver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL&quot;, sUsr, sPwd );<br><br>4. Sybase([url]http://jtds.sourceforge.net)jconn2.jar[/url]<br>Class.forName( &quot;com.sybase.jdbc2.jdbc.SybDriver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:sybase:Tds:MyDbComputerNameOrIP:2638&quot;, sUsr, sPwd );<br>//(Default-Username/Password: &quot;dba&quot;/&quot;sql&quot;)<br><br>5. Microsoft SQLServer([url]http://jtds.sourceforge.net)[/url]<br>Class.forName( &quot;net.sourceforge.jtds.jdbc.Driver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master&quot;, sUsr, sPwd );<br><br>6. Microsoft SQLServer([url]http://www.microsoft.com)[/url]<br>Class.forName( &quot;com.microsoft.jdbc.sqlserver.SQLServerDriver&quot; );<br>cn = DriverManager.getConnection( &quot;jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master&quot;, sUsr, sPwd );<br><br>7. ODBC<br>Class.forName( &quot;sun.jdbc.odbc.JdbcOdbcDriver&quot; );<br>Connection cn = DriverManager.getConnection( &quot;jdbc:odbc:&quot; + sDsn, sUsr, sPwd );|1073712473|218.68.248.79|ran|checkbox____|none|none||none||