myeclipse连接oracle数据库方法视频,2018.6.9 MyEclipse连接Oracle数据库方法及步骤

在windows栏找到showXXX 然后选择最后一个others 找到Database 然后选择oracle 接着就是jar包的问题了 这个不同于mysql oracle如果装在了本机上面可以在文件夹 D:\app\qichunlin\product\11.2.0\dbhome_1\jdbc\lib 下面找到

然后记得就是build一下导入Jar包

测试：

package com.glut.demo;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class OracleTest{

public static void main(String[] args) {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

System.out.println("Class Successful");

String url="jdbc:oracle:thin:@localhost:1521:booksales";

Connection conn = DriverManager.getConnection(url,"bs","bs");

System.out.println("Connection to Oracle DB Successful");

String sql = "select * from sys.students";

PreparedStatement pstmt = conn.prepareStatement(sql);

ResultSet rs = pstmt.executeQuery();

while (rs.next()) {

String sid = rs.getString("sid");

String sname = rs.getString("sname");

String sclass = rs.getString("class");

System.out.println(sid+" "+sname+" "+sclass);

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}