Java通过JDBC连接数据库实例

Java通过JDBC连接数据库实例

import java.sql.Connection;

import java.sql.DriverManager;

public class conn {

       public Connection getCon() {

             try {

                  Class. forName("com.mysql.jdbc.Driver"); 

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

                  String user = "root"; // apps

                  String password = "rootroot"; // apps

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

                  System. out.println(conn.getMetaData().getURL());

                   return conn;

            } catch (Exception e) {

                  e.printStackTrace();

                   return null ;

            }

      }

}

常用数据库的驱动程序写法：

MySQL:com.mysql.jdbc.Driver

SQL Server 2005:com.microsoft.sqlserver.jdbc.SQLServerDriver

Oracle:com.microsoft.sqlserver.jdbc.SQLServerDriver

不同数据库的连接字符串

MySQL数据库:jdbc:mysql://主机名:3306/数据库名

SQL Server 2005数据库:jdbc:sqlserver://主机名:1433;databaseName=数据库名

Oracle数据库:jdbc:oracle:thin:@主机名:1521:数据库名