java连接sqlserver,mysql,oracle

连接sqlserver

Class.forName("com.microsoft.jdbc.sqlserver.SQLServer");

private static final String URL = "jdbc:microsoft.sqlserver://localhost:1433;databaseName=mydb";//mydb为数据库的名字

private static final String USERNAME = "sa";

private static final String PASSWORD = "123456";

Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);

连接mysql

Class.forName("org.gjt.mm.mysql. Driver");

String url = "jdbc:mysql://locahost/mydb?user=tianliang&password=123456&useUnicode=true&characterEncoding=utf8";

Connection conn = DriverManager.getConnection(url);

连接oracle

Class.forName("oracle.jdbc.driver.OracleDriver");

String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID

String user = "test";

String password = "test";

Connection conn = DriverManager.getConnection(url,user,password);