Oracle jdbc

2021-05-06 09:40:09 浏览数 (1)

代码语言:javascript复制
package com.cjt.jdbc; 
import java.sql.Connection; 
public class Oracle { 
    /**

     * @param args

     * @throws ClassNotFoundException

     * @throws SQLException

     */

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        // TODO Auto-generated method stub 
        Class.forName(“oracle.jdbc.driver.OracleDriver”);

 

        Connection conn = null;

 

        Statement stmt = null;

 

        ResultSet rs =null;

        String url = “jdbc:oracle:thin:@localhost:1521:opdatabase”;

        conn = DriverManager.getConnection(url,”scott”,”tiger”);

        stmt = conn.createStatement();

 

        rs = stmt.executeQuery(“select * from EMP”);

 

        while(rs.next())

        {

            System.out.println(rs.getObject(1));

        }

 

        stmt.close();

 

        conn.close();

 

    } 
} 

发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/100547.html原文链接:

0 人点赞