import java.sql.Connection ;
import java.sql.DriverManager ;
import java.sql.ResultSet ;
import java.sql.Statement ;
import oracle.jdbc.OracleDriver ;

class JdbcTestOracle {
public static void main (String args[]) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e) {
System.err.println (e) ;
System.exit (-1) ;
}
try {
DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver());
Connection connection = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:iqdb",
"localu",
"localp");
System.out.println("Connected to database");

String password = "pAssS9worLd";
String encryptedPassword;
encryptedPassword = null;
String sqlStatement = "SELECT packages.crypto_pkg.encrypt(?) AS encrypted_password FROM dual";

Statement statement = connection.createStatement () ;

PreparedStatement statement = connection.prepareStatement(sqlStatement);


statement.setString(1, password);
ResultSet rs = statement.executeQuery();
while (rs.next()){
{
encryptedPassword = rs.getString("encrypted_password");
System.out.println (encryptedPassword);
}
connection.close () ;
}
catch (java.sql.SQLException e) {
System.err.println(e.toString());
System.out.println("Some error");
System.exit (-1) ;
}
}
}