jdbc链接mysql，access和oracle例子

一，链接mysql:

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

           Connection conn = DriverManager        .getConnection("jdbc:mysql://localhost/mydata?user=root&password=6656565");

           Statement stmt = conn.createStatement();

           ResultSet rs = stmt.executeQuery("select * from dept");

 

例子：

import java.sql.*;

public class TestMySqlConnect {

    public static void main(String[] args) {

       Connection conn = null;

       Statement stmt = null;

       ResultSet rs = null;

       try {

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

           conn = DriverManager

    .getConnection("jdbc:mysql://localhost/mydata?user=root&password=6656565");

           stmt = conn.createStatement();

           rs = stmt.executeQuery("select * from dept");

           while (rs.next()) {

              System.out.println(rs.getString("deptno"));

           }

       } catch (ClassNotFoundException e) {

           e.printStackTrace();

       } catch (SQLException e) {

           e.printStackTrace();

       } finally {

           try {

              if (conn != null) {

                  conn.close();conn = null;

              }

              if (stmt != null) {

                  stmt.close();stmt = null;

              }

              if (rs != null) {

                  rs.close();rs = null;

              }

           } catch (SQLException e) {

              e.printStackTrace();

           }

       }

    }

}

二，链接access

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

           Connection conn = DriverManager    .getConnection("jdbc:odbc:TestConnectToJava");

           Statement stmt = conn.createStatement();

           ResultSet rs = stmt.executeQuery("select * from guest");

例子：

import java.io.*;

import java.sql.*;

public class TestAccessConnect 

{

    public static void main(String[] args)

    {

       Connection conn=null;

       Statement stmt=null;

       ResultSet rs=null;

       try{

           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

           conn=DriverManager.getConnection("jdbc:odbc:TestConnectToJava");

           stmt=conn.createStatement();

           rs=stmt.executeQuery("select * from guest");

           while (rs.next()){

              System.out.println(rs.getString("content"));

           }

       } catch (ClassNotFoundException e){

           e.printStackTrace();

       } catch(SQLException e){

           e.printStackTrace();

       } finally{

           try {

              if (rs != null) {

                  rs.close();rs = null;

              }

              if (stmt != null) {

                  stmt.close();stmt = null;

              }

              if (conn != null) {

                  conn.close();conn = null;

              }

           } catch (SQLException e) {

              e.printStackTrace();

           }

       }

    }

}

三，链接oracle

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

           conn=DriverManager

    .getConnection("jdbc:oracle:thin:@192.168.1.103:1521:ORCL",user,password);

           stmt=conn.createStatement();

           rs=stmt.executeQuery("select * from emp");

 

例子：

import java.sql.*;

public class TestOracleConnect {

    public static void main(String [] args){

       Connection conn=null;

       Statement stmt=null;

       ResultSet rs=null;

       try {

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

    conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.103:1521:ORCL","huanran","huanran");

           stmt=conn.createStatement();

           rs=stmt.executeQuery("select * from emp");

           while (rs.next()){

              System.out.println(rs.getString("ename"));

           }         

       } catch (ClassNotFoundException e) {

           e.printStackTrace();

       } catch (SQLException e){

           e.printStackTrace();

       } finally {

           try{

              if (rs != null){

                  rs.close();rs=null;

              }

              if (stmt != null){

                  stmt.close();stmt=null;

              }

              if (conn!=null){

                  conn.close();conn=null;

              }

           } catch (SQLException e){

              e.printStackTrace();

           }

       }

    }

}