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.net/100547.html原文链接：https://javaforall.net
