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();

		}

	}

}

巴特西

2018.6.9 MyEclipse连接Oracle数据库方法及步骤

最新文章

热门文章