oracle和Mysql连接数据库

Mysql方式：

 

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

public class MysqlDB {
 private String strClass = "com.mysql.jdbc.Driver";
 private String strDriver = "jdbc:mysql://localhost:3306/s_smdb";
 private String strUser = "root";
    private String strPwd = "123";
 private Connection conn = null;
 private Statement stmt = null;
 private ResultSet rs = null;
 private static CDBAccess instance = null;
 
 private CDBAccess() throws ClassNotFoundException, SQLException{
  Class.forName(strClass);
  conn = DriverManager.getConnection(strDriver,strUser,strPwd) ;
 }
 
 public static CDBAccess getInstance() throws ClassNotFoundException, SQLException{
  if(instance == null){
   instance = new CDBAccess();
  }
  
  return instance;
 }
 
 public ResultSet executeQuery(String strsql) throws SQLException{
  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
  rs = stmt.executeQuery(strsql);
  
  return rs;
 }
 
 public int executeUpdate(String strsql) throws SQLException{
  int i = 0;
  stmt = conn.createStatement();
  i = stmt.executeUpdate(strsql);
  
  return i;
 }
 
 
 public void close() throws SQLException{
  if(rs != null){
   rs.close();
  }
  if(stmt != null){
   stmt.close();
  }
  if(conn != null){
   conn.close();
  }
  if(instance != null){
   instance = null;
  }
 }
}

 

Oracle方式：

package util;

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

public class OracleDB {
 public static Connection getConnection(){
  Connection con=null;
  String driver="oracle.jdbc.driver.OracleDriver";
  String url="jdbc:oracle:thin:@192.168.8.34:1521:ora9";
  String username="scott";
  String password="tiger";
  try{
   Class.forName(driver);
   
   con=DriverManager.getConnection(url,username,password);
  }catch(Exception e){
   e.printStackTrace();
  }
  return con;
 }
 public ResultSet exeQuery(String sql){
  ResultSet rs=null;
  Connection con=null;
  Statement sta=null;
  
  try{
   con=getConnection();
   sta = con.createStatement();
   rs=sta.executeQuery(sql);
  }catch(Exception e){
   e.printStackTrace();
  }
  return rs;
 }
 
 public int upaQuery(String sql){
  
  Connection con=null;
  int i=0;
  try{
   con=getConnection();
   con.setAutoCommit(false);
   Statement sta = con.createStatement();
   i=sta.executeUpdate(sql);
   con.commit();
  }catch(Exception e){
   e.printStackTrace();
  }
  return i;
 }
 //3.关闭资源
 public static void release(ResultSet rs,Statement stamt,Connection con){
  if(rs!=null){
   try{
     rs.close();
    }catch(Exception e){
     e.printStackTrace();
    }
  }
  if(stamt!=null){
   try{
     stamt.close();
    }catch(Exception e){
     e.printStackTrace();
    }
  }
  if(con!=null){
   try{
     con.close();
    }catch(Exception e){
     e.printStackTrace();
    }
  }
 }
}