javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "sys";
try {
Class.forName("oracle.jdbc.driver.OracleDriver"); //OracleÇý¶¯³ÌÐò
con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
±¨µÄ´íÎóÊÇ:java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
sysÓû§±ØÐëʹÓÃsysdba»òÕßsysoperµÄÉí·Ý²ÅÄܵǽ¡£
Èç¹ûÄãʹÓÃDBA StudioµÇ½µÄ»°£¬ÄãÄÜ¿´µ½ÔÚÓû§Ãû£¬ÃÜÂëÏÂÃæÓÐÒ»¸öÑ¡Ôñ¿ò£¬Ä¬ÈÏÊÇNormal£»µ«¿ÉÒÔ´ÓÕâÀïÑ¡Ôñsysdba»òÕßsysoper¡£
JDBCÎÒ»¹²»ÖªµÀÔõô¸Ä±äµÇ½Éí·Ý¡£
Äã»»ÓñðµÄÓû§µÇ½ÊÔһϰɡ£
Ò»°ã³ÌÐòÖÐÓÃsystem/manager¾ÍÐÐÁË¡£
Â¥É϶þλÕý½â,ÎҾͲ»¶à˵ÁË
²»ÒªÓÃsysÁ¬½Óoralce£¬ÓÃsysн¨Ò»¸öÓû§²âÊÔ
ʹÓÃSCOTT/tigerµÇ½°É
sysÕ˺Ų»¶Ô
×Ô¼ºÔÚOracleн¨Ò»¸öDatabase user È»ºóÔÚ
private static final String URL = "jdbc:oracle:thin:@localhost:1521:user";
private static final String USERNAME = "user"; <
Ïà¹ØÎÊ´ð£º
ÎÒµÄjava applet ǶÈëhtmlºóÎÞ·¨ÏÔʾ£¬¶øÓÃappletviewerÏÔʾÕý³£ÎªÊ²Ã´£¬»¹ÓоÍÊÇÓÃhtml converterת»¯ºó¿ÉÒÔÏÔʾ£¬ÎªÊ²Ã´£¿Çë´óÏÀ´Í½Ì£¡
HTML code:
<HTML>
<HEAD>
<TITLE>TEST.HTML< ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
Èý¸öÊýx,y,z ±È´óС..
var x,y,z,t;
if (x>y)
{t=x;x=y;y=t;} //½»»»x,yµÄÖµ
if(x>z)
{t=z;z=x;x=t;}//½»»»x,zµÄÖµ
if(y>z)
{t=y;y=z;z=t;}//½»»»z,yµÄÖµ
ÕâÊÇ ......