jdbc连接Oracle

来源：互联网发布：南昌seo外包编辑：程序博客网时间：2024/06/07 20:31

package com.sw;import java.sql.*;public class TestOra2 {public static void main(String[] args) {Connection conn=null;Statement st=null;ResultSet rs=null;try {// 加载驱动Class.forName("oracle.jdbc.driver.OracleDriver");// 建立连接conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott", "Oracle1");//其余操作和sqlserver2000是一样的        st = conn.createStatement();        //        rs = st.executeQuery("select * from emp");        //        while(rs.next()){                System.out.println("ename:"+rs.getString(2));        }} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}       finally{        try {rs.close();        st.close();        conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}        }}}

使用jdbc连接数据时，需要下载oracle jdbc的驱动。