Çë½ÌDRIVER={Microsoft ODBC for Oracle} Á¬½ÓÎÊÌ⣡
ÊÇÕâÑùµÄÎÒ×°ÁËһ̨2003µÄÐéÄâ»ú£¡
ÐéÄâ»úIP£º192.168.1.108
±¾»úIP£º192.168.1.100
ÎÒÔÚÐéÄâ»úÉÏ×°ÁËoracle 10G ,ÏÖÔÚÏë±àд¸ö³ÌÐò¶ÁÈ¡oracleÊý¾Ý¿âÀïµÄ¼Ç¼£¬
ÎÒÔÚ±¾»ú×°Á˸öoracle XE Client£¬ÇëÎʸÃÈçºÎÁ¬½Ó ÐéÄâ»úÉϵÄoracle
ÎÒÓà DRIVER={Microsoft ODBC for Oracle};UID=¡°system¡°;PWD=¡±5897577¡°;SERVER=¡±Êý¾Ý¿âÃû×Ö ;¡±
°ÑÎÒдµÄ³ÌÐò·Åµ½ÐéÄâ»úÉÏ¿ÉÒÔÁ¬½Ó£¬·Åµ½±¾»úÕâÑù¾Í²»ÄÜÁ¬½ÓÁË£¡
ÇëÎÊÈçºÎÐ޸ģ¬»òÕßÆäËû·½·¨£¡
ÄÇÎÒÈí¼þÖÐÔõôдÄØ£¿
ÂÛ̳ÈËÆøÔõôÕâôÉÙ
Ïà¹ØÎÊ´ð£º
oracleÌ«¹óÁË,Áìµ¼Èû»³Émysql
ÔÀ´µÄoracleÊDz¼ÖÃÔÚlinux·þÎñÆ÷ÉÏ,¿Í»§¶ËÓÃBCB¿ª·¢µÄ,ÔÚwindowsÏÂÔËÐÐ,µ«ÔËÐеĻúÆ÷ÉϱØÐë×°Ò»¸öoracleµÄ¿Í»§¶Ë
¿´ÁËÏ´úÂë,³ÌÐòÊÇͨ¹ý²éÕÒoracle¿Í»§¶ËÔÚ×¢²á±íÖеÄÊý¾Ý» ......
ÕâÊÇÎÒÔÀ´Á¬½ÓSQLµÄ´òÓ¡µÄ´úÂë
Connection1.Open "Provider=MSDataShape.1;Persist Security Info=True;Data Source=mm;User ID=sa;Password=sa;Initial Catalog=lc-liuh2;Data Provider=SQLOLEDB.1"Ê ......
--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ
CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM
BEFORE UPDATE ON TSTK_IMPORTITEM
FOR EACH ROW
DECLARE
VAR_LIBGOODCOUNT NUMERIC(12,2);
BEGIN
......
ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle. ......
ÎÒÓõÄÊÇPreparedStatementÀ´·¢ËÍÌá½»£¬²¢ÇÒÊý¾ÝÁ¿·Ç³£ÅÓ´ó¡£
Ò»´ÎÐèÒªÖ´ÐÐ8900¶àÌõ¸üÐÂÓï¾ä£¬Ò²¾ÍÊÇUpdateÓï¾ä¡£
ÎÒÊÔ¹ý·Ö¿ª£¬Ò»²¿·ÖÒ»²¿·ÖÀ´Ö´ÐÐÌá½»£¬µ«»¹ÊÇÒ»ÑùµÄËÙ¶ÈÂý£¬¶øÇÒÔ½Ö´ÐÐÔ½Âý¡£ÊµÔÚÊÇûÓÐʲô ......