java连接常用数据库
---------MySql-----
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","username", "password");
--------Access ---------
建立ODBC数据源
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:accessdb");
--------oracle---------
Class.forName("
oracle.jdbc.driver.OracleDriver"
).newInstance();
Connection con=DriverManager.getConnection("
jdbc:oracle:thin:@localhost:1521:dbname
","username","password");
---------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 );
---------Microsoft SQL Server---------
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
--------PostgreSQL---------------
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd )
相关文档：
1. package book.io;
2.
3. import java.io.File;
4.
5. /**
6. *
7. * @author XWZ
8. * 20 ......
example： 求5的阶乘。。
如下：
public class Test {
static int multiply(int n){
if(n==1||n==0)
return n;
else
return n*multiply(n-1);
}
public static void main(String[] args){
System.out.println(multiply(10));
}
......
2009-11-09 15:33:36
文件属性配置类
package cn.sist.file;
public class FileProperty {
private int sysProperty = 0;
private int hiddenProperty = 0;
private int readProperty = 0;
private int arriveProperty = 0;
private boolean changeAll = false;
public FileProperty setC ......
Job Title: Java Consultant- Staff Software Engineering
Location: Shanghai
Company: HP China (www.hp.com)
This is a position reporting to Product Development Manager. The Staff Software Engineering will be responsible for leading development of robust high-volume ......
