Java如何连接My SQL和Oracle库

Java连接MySQL数据库——含步骤和代码
工具：eclipse


　　　MySQL5.6


　　　MySQL连接驱动：mysql-connector-java-5.1.27.jar
连接：package com.dao.Impl;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class BaseDAO {
//链接MySQL的字符串
private static final String DRIVER="com.mysql.jdbc.Driver";
private static final String URL="jdbc:mysql://localhost:3306/user?charaterEncoding=utf8";
private static final String USERNAME="root";

private static final String PWD="";
protected Connection con;
protected PreparedStatement pst;
protected ResultSet rs;
//连接数据库
protected void getDate(){
try {
Class.forName(DRIVER);
con=DriverManager.getConnection(URL,USERNAME,PWD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
//关闭连接
protected void closeDate(){
try {
if(rs!=null){
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(pst!=null){
pst.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try{
if(con!=null){
con.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
//增删改操作
protected int exeUpdate(String sql,String[] parea){
int row = 0;
try {
this.getDate();
pst = con.prepareStatement(sql);
if(parea != null && parea.length>0){
for (int i = 0; i < parea.length; i++) {
pst.setString(i+1, parea[i]);
}
}
row = pst.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}finally{
this.closeDate();
}
return row;
}
//查询操作
protected ResultSet exeQuery(String sql,String[] parea){
try {
this.getDate();
pst = con.prepareStatement(sql);
if(parea != null && parea.length>0){
for (int i = 0; i < parea.length; i++) {
pst.setString(i+1, parea[i]);
}
}
rs = pst.executeQuery();
} catch (Exception e) {
e.printStackTrace();
}
return rs;
}
}
Java连接Oracle数据库，与上面不同的jar包更换ojdbc14.jar，然后就是下面这部分与上面不同：
//链接MySQL的字符串
private static final String DRIVER="oracle.jdbc.driver.OracleDriver";
private static final String URL="jdbc:oracle:thin:@localhost:1521:SOFT";
private static final String USERNAME="scott";

private static final String PWD="tiger";
protected Connection con;
protected PreparedStatement pst;
protected ResultSet rs;
当你学会一种数据库的连接时，其他的都与其相似，但他们的执行时，sql语句会有所不同！