contoh script berikut semoga bisa membantu
import java.sql.*;
import oracle.jdbc.*;
public class Procedures {
static Connection conn = null;
public static void main(String [] args)
{
try
{
DriverManager.registerDriver(
new oracle.jdbc.OracleDriver());
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@noizmaker:1521:osiris",
"david", "bigcat");
String [] sa = new String [1];
System.out.println("procedure returned: "
+ myMethod("John"));
conn.close();
}
catch(SQLException e)
{
System.out.println("Caught " + e);
}
}
public static String myMethod(String name)
throws SQLException
{
String fullname = "Unknown";
try
{
if(conn==null)
{
conn = DriverManager.getConnection(
"jdbc:default:connection:");
}
else
{
System.out.println("Executing at command prompt...");
}
Statement stmt = conn.createStatement();
String sql = "SELECT LAST_NAME FROM NAMES WHERE FIRST_NAME = '"
+ name + "'";
System.out.println(sql);
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
fullname = name + " " + rs.getString(1);
}
}
catch(SQLException e)
{
System.out.println("Caught " + e);
}
return "Hello " + fullname;
}
}
2007/5/25, Wadi Achmed <[EMAIL PROTECTED]>:
>
> Hello all,
>
> Ada yang tahu gimana cara programming java untuk di embed ke oracle db
> dan Java class nya tersebut akan melakukan query ke table/view di
> oracle db tsb?
>
> Apakah di java class nya harus bikin connection tersendiri ke oracle
> db nya? Kalau iya, berarti membutuhkan sebuah session lagi?
>
> TIA
>
> --
> Best regards,
> Wadi mailto:[EMAIL PROTECTED] <wadiachmed%40gmail.com>
>
>
>
--
Firman HM
PT. Xsis Mitra Utama
Graha BIP 7th Floor Jl. Jend. Gatot Subroto Kav.23 Jakarta 12930 -
Indonesia
Tel : +62-21-5210565 Hotline : +62-21-5210564 Fax : +62-21-5229777
[Non-text portions of this message have been removed]
