JDBC 常用驱动类及url格式

时间：2022-05-12 21:29:14

1. oracle

　　　　 <dependency>

            <groupId>com.oracle</groupId>

            <artifactId>ojdbc6</artifactId>

            <version>11.2.0.3.0</version>

        </dependency>
　　　　 String driver = "oracle.jdbc.OracleDriver";// 驱动类全路径名

        String url = "jdbc:oracle:thin:@//myhost:1521/myservicename";

        String username = "scott";

        String password = "tiger";

2. mysql

　　　　 <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.35</version>

        </dependency>
　　　　 String driver = "com.mysql.jdbc.Driver";// 驱动类全路径名

        String url = "jdbc:mysql://localhost:3306/mydb";

        String username = "monty";

        String password = "greatsqldb";

3.

相关文章