ÈçÌ⣡¸ßÊÖ°ï°ï棡£¡£¡
¸ßÊÖÃǰï°ïæ°¡ £¡ÔÚÏߵȡ£¡£¡£¡£¡£¡£¡£¡£
ÔÚjobÉÏÉèÖö¨Ê±ÔËÐеÄʱ¼äºÍ¼ä¸ôʱ¼ä
to: hebo2005
ÎÒ°´Äã¸øÎÒµÄÀý×ÓдÁËÒ»¸öÀàËÆµÄ±¨´í°¡£¡
ÕâÊÇÎÒдµÄ
񡜧 create table t(name ......
ÇóMyEclipseÁ´½Óoracle·½ÃæµÄµç×ÓÊé
Java code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBCon {
public static String driver="oracle.jdbc.driver.OracleDriver";
......
ÎÒµÄoracleÊý¾Ý¿âÓиö×Ö¶ÎÀàÐÍFD_USER_IDÊÇ number£¨38£©£¬ÎÒÓÃodbc¶ÁÈ¡Ëû£¬
ÆäÖÐCRecordset rs£»
CDBVariant v;
rs.GetFieldValue(FD_USER_ID, v,SQL_C_SLONG);
ÔÚÎҵĻú×ÓÉÏ ¶Á³öÀ´µÄv.m_lVal ÊÇÕýÈ·µÄ
µ«ÊÇÔÚÁíÍâµÄ»ú×ÓÉ϶Á Ìáʾ˵numberic out ......
ÔʼÓï¾ä£º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 ;
ÕâÑùµÄ»°³öÀ´µÄ½á¹ûΪ¿Õ¡£
Ó¦¸ ......
ÓÃÃüÁî select count(*) from v$process
¿ÉÒÔ²éѯµ±Ç°µÄprocessÊý£¬µ«ÊÇÎÒÒª²éѯÒÔÍù×î¸ßµÄprocessÔõô°ì°¡£¿
Õâ¸ö¡£¡£ºÃÏñûÓÐÌØ±ðµÄÊÔͼ²éѯ°É¡£
ÒýÓÃ
Õâ¸ö¡£¡£ºÃÏñûÓÐÌØ±ðµÄÊÔͼ²éѯ°É¡£
ÎÒÖ÷ÒªÊÇÏëÁ˽âÒ»ÏÂ×î´óµÄprocessÊǶà´ó£¬È»ºó±ãÓÚÉèÖÃprocessµÄÖµÂ
²»¹ý»°Ëµ»ØÀ´£¬pro ......
ÔËÐÐ./runInstallerºó±¨´í
Check complete. The overall result of this check is: Failed < < < <
Problem: This software can only be installed into an existing Oracle Database 10g Oracle Home.
Recommendation: Choose an existing Oracle Database 10g Oracle Home for installing this sof ......