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();
}
2 验证连接类
package b;
import java.sql.Connection; import java.sql.SQLException; import a.Connectionhelp; public class test {
}
结果:如下即可证明连接正确 } /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub Connection conn=Connectionhelp.getConnection(); if(conn!=null){ } try { conn.close(); } catch (SQLException e) { } // TODO Auto-generated catch block e.printStackTrace();
第二篇:测试报告
惠州培训网
测试报告
Test Report
测试: 审核
更多免费资料下载请进: 好好学习社区