连接Oracle的驱动与msql

最新推荐文章于 2024-07-01 10:31:05 发布

iteye_9310

最新推荐文章于 2024-07-01 10:31:05 发布

阅读量139

点赞数

分类专栏： oracle总结文章标签： Oracle MySQL JDBC

本文链接：https://blog.csdn.net/iteye_9310/article/details/81935171

版权

oracle总结专栏收录该内容

9 篇文章 0 订阅

订阅专栏

Mysql的驱动：

    public PersonOperation() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            try {
                connection = DriverManager.getConnection(
                        "jdbc:mysql://localhost:3306/linger", "root", "123456");

   //"jdbc:mysql://localhost:3306/checkcode?useUnicode=true&characterEncoding=utf-8";
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        // connection = DBPool.getConnection();
    }

Oracle的驱动：

public class Driver {
    public static void main(String[] args) throws IOException,
            InstantiationException, IllegalAccessException,
            ClassNotFoundException {
        Connection con = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:orcl", "system", "sys");
            System.out.println("连接Oracle数据库成功");
            Statement statement = con.createStatement();
            ResultSet resultSet = statement
                    .executeQuery("select * from scott.emp");
            while (resultSet.next()) {
                System.out.print(resultSet.getString(1));
                System.out.print(resultSet.getString(2));
                System.out.print(resultSet.getString(3));
                System.out.println(resultSet.getString(4));
            }
        } catch (SQLException e) {
        }
    }
}