1.package com.oracle.util;
Importjava.sql.Connection;ImportJava.sql.DriverManager; Public classDbutil { //application for connecting Oracle database Private Static FinalString jdbcname= "Oracle.jdbc.driver.OracleDriver"; Private Static FinalString url= "Jdbc:oracle:thin: @localhost: 1521:orac"; Private Static FinalString user= "Scott"; Private Static FinalString password= "Tiger"; PublicConnection Getconn ()throwsException {class.forname (jdbcname);
/**
*drivermanager (the only class to use)
*connection (interface)
* / Connection Conn=drivermanager.getconnection (URL, user, password); returnConn; } Public voidCloseconn (Connection conn)throwsException {if(conn!=NULL) {conn.close (); } } Public Static voidMain (string[] args)throwsException {dbutil dbutil=NewDbutil (); Connection Conn=Dbutil.getconn (); if(conn!=NULL) {System.out.println ("Oracle Database Connection succeeded"); }Else{System.out.println ("Oracle Database Connection Failed"); } dbutil.closeconn (conn); }}
2.
Packagecom.oracle.test;Import Staticorg.junit.assert.*;Importjava.sql.Connection;ImportOrg.junit.After;ImportOrg.junit.Before;Importorg.junit.Test;ImportCom.oracle.util.DbUtil;
Public classjunittestoracle { //Connect Oracle database Dbutil in JUnit dbutil=NewDbutil (); @Before Public voidSetUp ()throwsException { //setup () method used in JUnit } @After Public voidTearDown ()throwsException { //teardown () method used in JUnit } @Test Public voidTest ()throwsException { //write content in the test () method Connection Conn=Dbutil.getconn (); if(conn!=NULL) {SYSTEM.OUT.PRINTLN ("Oracle Connection succeeded");} }}
JUnit connects to Oracle database