Test Applet using JDBC to Oracle


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]

±Û¾´ÀÌ :ÃÖÁø¼ö 1999³â 9¿ù 22ÀÏ 04:30:11

¾Æ·¡ÀÇ code´Â Oracle web site¿¡ ³ª¿ÍÀÖ´Â appletÀÔ´Ï´Ù.
--------------------------------------------------
import java.sql.*;
import java.awt.*;
import java.io.*;
import java.util.*;


public class JdbcApplet extends java.applet.Applet
{
static final String driver_class = "oracle.jdbc.driver.OracleDriver";


static final String connect_string =
"jdbc:oracle:thin:scott/tiger@dlsun511:1721:dbms733";


static final String query = "select 'Hello JDBC: ' || sysdate from dual";
Button execute_button;
TextArea output;
Connection conn;
public void init ()
{
this.setLayout (new BorderLayout ());
Panel p = new Panel ();
p.setLayout (new FlowLayout (FlowLayout.LEFT));
execute_button = new Button ("Hello JDBC");
p.add (execute_button);
this.add ("North", p);
output = new TextArea (10, 60);
this.add ("Center", output);
}
public boolean action (Event ev, Object arg)
{
if (ev.target == execute_button)
{
try
{
// Clear the output area
output.setText (null);


// See if we need to open the connection to the database
if (conn == null)
{
// Load the JDBC driver
output.appendText ("Loading JDBC driver " + driver_class + "\n");
Class.forName (driver_class);


// Connect to the databse
output.appendText ("Connecting to " + connect_string + "\n");
conn = DriverManager.getConnection (connect_string);
output.appendText ("Connected\n");
}


// Create a statement
Statement stmt = conn.createStatement ();


// Execute the query
output.appendText ("Executing query " + query + "\n");
ResultSet rset = stmt.executeQuery (query);


// Dump the result
while (rset.next ())
output.appendText (rset.getString (1) + "\n");


// We're done
output.appendText ("done.\n");
}
catch (Exception e)
{
// Oops
output.appendText (e.getMessage () + "\n");
}
return true;
}
else
return false;
}
}
------------------------------------------------------
Netscape4.5 ¿¡¼± ÀߵǴµ¥,
IE5.0 ¿¡¼± "No Suitable Driver" ¶ó´Â error°¡ »ý±â°í, appletviewer ¿¡¼± "access denied (java.net.SocketPermission MyHostName resolve)" ¶ó´Â error °¡ »ý±é´Ï´Ù. DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); ¸¦ »ç¿ëÇصµ °á°ú´Â ¸¶Âù°¡ÁöÀÔ´Ï´Ù. html file¿¡ codebase¿Í archive¸¦ Á¦´ë·Î ³Ö¾ú½À´Ï´Ù. µµ´ëü ¹«½¼ ¹®Á¦Àϱî¿ä?



´ÙÀ½ ±Ûµé:



À̾ ±Û¿Ã¸®±â(´äÇϱâ)

À̸§:
E-Mail:
Á¦¸ñ:
³»¿ë:
HTML ÅÂ±× Æ÷ÇÔ ¿©ºÎ: HTML ¹®¼­ÀÏ °æ¿ì üũ
°ü·Ã URL(¼±ÅÃ):
URL Á¦¸ñ(¼±ÅÃ):
°ü·Ã À̹ÌÁö URL:


[ ´ÙÀ½ ±Ûµé ] [ À̾ ±Û¿Ã¸®±â(´äÇϱâ) ] [ ÀÚ¹Ù ¹¯°í ´äÇϱâ ]