±íA£º ¹¤ºÅ ÐÕÃû ±íB£º Á÷³Ì±àºÅ Á÷³ÌÃû ·¢ÆðÈË ±íC£º Á÷³Ì±àºÅ Á÷³Ì²½Öè °ìÀíÈË
001 Àî1 &nb ......
±íA£º ¹¤ºÅ ÐÕÃû ±íB£º Á÷³Ì±àºÅ Á÷³ÌÃû ·¢ÆðÈË ±íC£º Á÷³Ì±àºÅ Á÷³Ì²½Öè °ìÀíÈË
001 Àî1 &nb ......
Á¬½ÓÒѾ½¨Á¢ÆðÀ´ÁË£¬ÏÖÔÚÏë²åÈëÓï¾ä£¬
vcÖеÄÓï¾äÊÇ
CString sql="Insert into car(a,b,c) VALUES('W','W','W')";
m_db.ExecuteSQL(sql);
ÔËÐÐʱÌáʾ´íÎ󣺶ÔÏóÃû'car'ÎÞЧ¡£
ÉÏÍø²éÁËһЩ×ÊÁÏ£¬Ëµ¿ÉÄÜÊÇÓû§ÃûµÄÎÊÌ⣬µ«Ê ......
ÓÃjspÑ¡ÔñÁËɾ³ýÊý¾Ýºó£¬Ê¹Êý¾Ý²»»á³öÏÖÔÚjspÒ³ÃæºÍÊý¾Ý¿âÖУ¬Ò²¾ÍÊÇÒª¸üÐÂÊý¾Ý£¬¸÷λ´óÏÀ¸ÃÔõô×ö£¿Ð»Ð»£¡£¡
index.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>
<html>
<body>
<div align=&q ......
Éè·þÎñÆ÷AÀïµÄMySQLµÄÊý¾Ý¿âtestÖÐÓÐÒ»±ítest1(id int, msg varchar(20))£¬ÆäÖÐÓÐ1Ìõ¼Ç¼µÄmsgÀï°üº¬·±Ìå×Ö¡£
ÏÖÓÚ·þÎñÆ÷BÀïµÄSQL SERVER2008ÖÐʹÓÃMyODBC 5.1×÷Á´½Ó·þÎñÆ÷µ½A¡£
µ±Ö´ÐÐÓï¾ä select * from openquery(test,'select * from test.test1') ʱ£¬·µ»ØÒÔÏ´íÎó£º
Á´½Ó·þÎñÆ÷ 'test ......
RT...
¼ÙÉèÓÐÒ»¸ö´æ´¢¹ý³Ì
CREATE OR REPLACE PROCEDURE OUT_DATE as
begin
dbms_output.put_line(sysdate);
end;
ÎÒÔÚSQL ScratchpadÖÐÖ´ÐÐ execute out_date; ºÃÏñ²»Ðж¡£¡£
ûÓùýSQL Scratchpad¡£¡£¡£
Ö´ÐÐexecute out_date;ÊDZ§´í°¡»¹ÊÇûÓнá¹ûÏÔʾ£¿
ÆÚ´ý¡£¡£¡£
......