ï¼1ï¼å¨MyEclipseä¸å¼å
¥Oracle 11gèªå¸¦çJDBCå
ï¼å¦âG:\app\welcome\product\11.1.0\db_1\jdbc\lib\ojdbc6.jarâï¼ï¼å³å»java项ç®ï¼éæ©âBuild PathâãâConfigure Build Pathâï¼åå»âAdd External JARsâæé®ï¼éæ©ä½ çojdbc6.jarï¼
ï¼2ï¼å¼æ·Oracleæå¡ï¼
ï¼3ï¼ç¼åæµè¯ä»£ç ï¼
import java.sql.*;
public class TestOracle {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM scott.emp");
while(rs.next()){
System.out.println(rs.getInt(1) + "\t" + rs.getString(2));
}
}catch(Exception err){
System.out.println(err.toString());
}
}
}
ï¼4ï¼è¿è¡Javaç¨åºï¼
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE
7782 CLARK
7788 SCOTT
7839 KING
7844 TURNER
7876 ADAMS
7900 JAMES
7902 FORD
7934 MILLER
å¦æä½ çJDKçæ¬å¤ªä½æ太é«ï¼ä½ä¸è½ç¨ojdbc6.jarï¼è¦ç¨ojdbc5.jaræojdbc6_g.jarã
温馨提示:内容为网友见解,仅供参考