1.添加oracle数据库的驱动包 右击项目如下选择
看到如下图示及点击user library
新建User Libraries在oracle安装目录下找到如下class12.jar包
2.写数据库连接测试类
如下:连接数据库类
package a;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Connectionhelp {
public static Connection getConnection(){ Connection conn=null; String url="jdbc:oracle:thin:@192.168.4.15:1521:song";
String user="scott"; String passwd="tiger"; String className="oracle.jdbc.driver.OracleDriver"; try { System.out.println("连接开始"); Class.forName(className); } catch (ClassNotFoundException e) { } finally { } try { conn=DriverManager.getConnection(url,user,passwd); System.out.println("数据库连接成功...."); System.out.println("连接已经成功"); // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { } return conn; } // TODO Auto-generated catch block e.printStackTrace();
…… …… 余下全文