oracle²éѯÎÊÌ⣡¼±
ÔʼÓï¾ä£ºvar indexsql="select * from fla_info where obj_id = 1; ÎÒÏëÒª²éѯid=1µÄÊý¾Ý ÏÖÔÚÏëÓÃÒ»¸ö±äÁ¿£¬ÀýÈçnumber ´úÌæÊýÖµ1¡£¾ÍÊÇÕâÑù£º var number = 1 £» var indexsql="select * from fla_info where obj_id = number ; ÕâÑùµÄ»°³öÀ´µÄ½á¹ûΪ¿Õ¡£ Ó¦¸ÃÔõÑùÐ޸ģ¿Ð»Ð»¸÷λ¸ßÊÖ£¡
ÔÚPL/SQL ÖпÉÒÔÓÃ&±äÁ¿´úÌæ ±ÈÈçSQL code: SELECT * from EMP WHERE EMPNO=# ÔËÐкó»áÌáʾÄãÊäÈë±äÁ¿Ö² Ò²¿ÉÒÔÔÚÃüÁîÐÐÌáʾ·ûÏ ¶¨Òå±äÁ¿ SQL code: SQL>DEFINE A=7788 SQL>SELECT * from EMP WHERE EMPNO=&AÒýÓà var indexsql="select * from fla_info where obj_id = '" + number + "'"; ʵ¼ÊÉÏÕâÀïÒѾÊÇǰ¶Ë³ÌÐòµÄÎÊÌâÁË phoenix_99˼·û´í£¬Õâ¸öµ¥ÒýºÅûÓбØÒªÌí¼Ó лл¸÷λÁË£¬°´Phoenix_99µÄ·½·¨ÒѾ½â¾öÁË£¡
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿ Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£ ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠ÒýÓà ²»ÄÜÖ±½ÓÁ¬½ÓÂ𣿠²»ÄÜ ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......