一，鏈接 mysql: Class. forName ( "com.mysql.jdbc.Driver" ); Connection conn = DriverManager . getConnection ( "jdbc:mysql://localhost/mydata?user=rootpassword=6656565" ); Statement stmt = conn.createStatement(); ResultSet rs = stmt.execute

一，鏈接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.*;

publicclass TestMySqlConnect {

??? publicstaticvoid 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.*;

publicclass TestAccessConnect?

{

??? publicstaticvoid 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.*;

publicclass TestOracleConnect {

??? publicstaticvoid 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();

?????????? }

?????? }

??? }

}

?