jdbc链接mysql，access和oracle例子

一，链接 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();

}

}

}

}