连接Oracle与MySql代码

  连接Oracle的代码

public class ORAConntion ...{
    public Connection con;
    public Statement sta;
    public ResultSet res;
    public PreparedStatement prepar;
    
    public Connection Getcon()
    ...{
        try ...{
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        try ...{
            con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ora","system","system");
            sta=con.createStatement();
        } catch (SQLException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
            System.out.print("错误");
        }
        return con;
    }
    public void doclose()
    ...{
        try ...{
            con.close();
            sta.close();
        } catch (SQLException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
    }

}

 

 连接MySql的代码

public class DBManager ...{
    private Connection con;
    
    private java.sql.Statement sta;
    private static DBManager db=null;
    
    private DBManager()...{
        
    }
    //通过方法来得到对象
    public static DBManager getInstance()...{
        if(db==null)
        //    synchronized (DBManager.class) {
        //        if(db==null)
            db=new DBManager();
        //    }
        return db;
    }
    //得到连接
    private void getcon()
    ...{
        try ...{
            Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
            con=DriverManager.getConnection("jdbc:mysql://localhost:3306/school?user=root&password=admin&useUnicode=true&characterEncoding=gb2312");
        } catch (ClassNotFoundException e1) ...{
            // TODO 自动生成 catch 块
            System.out.print("驱动出错了");
            e1.printStackTrace();
        } catch (SQLException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
        } catch (InstantiationException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
        } catch (IllegalAccessException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
    }
    //该方法用于执行update,insert,delete语句. 
    public  boolean execute(String sql)...{
        System.out.print(sql);
        try ...{
            if(con==null || con.isClosed()==true)...{
                getcon();
            }
            sta=con.createStatement();
            sta.execute(sql);
        } catch (SQLException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
            return false;
        }
        return true;
    }
    public ResultSet executeQuete(String sql)...{
        System.out.print(sql);
        ResultSet rs=null;
        try ...{
            if(con==null || con.isClosed()==true)...{
                getcon();
            }
            sta=con.createStatement();
            rs=sta.executeQuery(sql);
        } catch (SQLException e) ...{
            // TODO 自动生成 catch 块
            e.printStackTrace();
            return null;
        }
        return rs;
    }

}

 

 PS: 记得自己打驱动包啊.