各种数据库JDBC连接

1.访问SQL Server

    DBDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver

    URL=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=demo

2.访问MySQL

    DBDriver=com.mysql.jdbc.Driver

    URL=jdbc:mysql://localhost/demo

3.访问Oracle

    DBDriver = jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:SID

 

    Class.forName (DBDriver);

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

    Statement stmt = conn.createStatement();

    ResultSet rset = stmt.executeQuery ()