Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

AIRÖ´ÐÐSQLÓï¾ä

 ÎÒÃǵÄSQLÓï¾äµÄÖ´Ðж¼ÊÇÓÉÒ»¸öÀàÀ´Íê³ÉµÄ£¡Õâ¸öÀà¾ÍÊÇSQLStatement£¬Õâ¸öÀà¾ÍÊÇÎÒÃÇÓÃÀ´Ö´ÐÐSQLÓï¾äµÄÀ࣬¸ÃÀàµÄʹÓÃÒ²ÊǷdz£¼òµ¥µÄ£¬ÎÒÃÇÖ»ÐèÒª¼ÇסÁ½¸öÊôÐÔÁ½¸ö·½·¨¡£ÎÒÃÇÀ´¿´Ò»Ï£¡
textÊôÐÔ£ºËùÒªÖ´ÐеÄSQLÓï¾ä£¬¸ÃÊôÐÔÊÇÒ»¸ö×Ö·û´®¸ñʽ£¬ËùÒÔÎÒÃǵÄSQLÓï¾ä¶¼ÊÇ×Ö·û´®£¡
sqlConnectionÊôÐÔ£º¸ÃÊôÐÔÊÇÉèÖÃSQLStatement¶ÔÏóËùÒª°ó¶¨µÄSQLConnection¶ÔÏó£¬Õâ¸öÊôÐÔÎÒÃÇÒ»°ãÔÚ´´½¨SQLStatment¶ÔÏóµÄʱºò¾ÍÉ趨µÄ£¡
execute·½·¨£ºÕâ¸ö·½·¨ºÜ¼òµ¥£¬±íʾִÐÐSQLÓï¾ä¡££¨ÓеãÏñplay£©
getResult·½·¨£ºÕâ¸ö·½·¨Í¦ÖØÒªµÄ£¬ÒòΪÎÒÃÇ·ÃÎʵÄÊý¾Ý¿âºó·µ»ØµÄÊý¾Ý¶¼Í¨¹ýÕâ¸ö·½·¨´æ´¢µ½Ò»¸öSQLResult¶ÔÏóÖУ¡
    ºÃÁË£¡ÎÒÃÇÀ´¿´Ò»¸öʵÀý°É£¡Õâ¸öʵÀýÖн«Ö´ÐÐÒ»¸ö²éѯÓï¾ä£¬¸ÃÓï¾ä²éѯºóµÄ½á¹û»átrace³öÀ´£¡
package
{
import flash.data.SQLConnection;
import flash.data.SQLResult;
import flash.data.SQLStatement;
import flash.display.Sprite;
import flash.errors.SQLError;
import flash.events.MouseEvent;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;
/**
* ...
* */
public class Main extends Sprite
{
   private var file:File = File.applicationDirectory.resolvePath("abc.db");
   private var shuju:SQLConnection = new SQLConnection();
   private var sqlcaozuo:SQLStatement = new SQLStatement();
   private var a:Sprite = new Sprite();
   public function Main():void
   {
    shuju.addEventListener(SQLEvent.OPEN, openfile);
    shuju.addEventListener(SQLErrorEvent.ERROR, cuowu);
    shuju.addEventListener(SQLEvent.CLOSE, ting);
    shuju.open(file);
    //////////
    a.graphics.beginFill(0x00ff00);
    a.graphics.drawRect(0, 0, 100, 100);
    a.graphics.endFill();
    addChild(a);
    a.addEventListener(MouseEvent.CLICK, an);
   }
   private function ting(evt:SQLEvent):void
   {
    trac


Ïà¹ØÎĵµ£º

MyEclipse5.5ÏÂÁ¬½ÓSql Server 2008µÄ·½·¨

ÏÂÃæÊÇÖ¸µ¼Îĵµ¡£Çë¸ú×ÅÒ»²½²½µÄ×ö¡£¾ÍÄܳɹ¦Á¬½ÓÉÏsql server 2008
 
javaÖÐÁ¬½Ósql server 2008µÄ×¢ÒâÊÂÏ
2000£¬2005µÄÊý¾Ý¿âÇý¶¯ÀàµÄд·¨ÊÇ£º
com.microsoft.jdbc.sqlserver.SQLServerDriver
URLµÄд·¨ÊÇ£º¼ÙÉèÊý¾Ý¿âÊÇnews
jdbc:microsoft:sqlserver://localhost:1433;databaseName=news
 
µ«ÊÇ20 ......

SQL SERVER¿ç·þÎñÆ÷²éѯ(SQL SERVER DBLINK)

--¿ç·þÎñÆ÷²éѯÈçÏ£º
SELECT a.*,b.stor_Name
from OPENROWSET('MSDASQL',
   'DRIVER={SQL Server};SERVER=tom;UID=sa;PWD=123',
   pubs.dbo.authors) AS a,stores b
ORDER BY a.au_lname, a.au_fname
--ÆäÖУ¬tomΪԶ³Ì·þÎñÆ÷Ãû£¬stores ÊDZ¾»úÊý¾Ý¿âpubsÖеıí
--ÐèҪעÒâµÄÊÇÈô¶þ¸ö±íÖÐµÄ ......

sql µ¼³ö£¬½â¾ösheet±í´óСÏÞÖÆ

CREATE proc sqlToMultiExcelFile
@sqlstr nvarchar(4000), --²éѯÓï¾ä,Èç¹û²éѯÓï¾äÖÐʹÓÃÁËorder by ,Çë¼ÓÉÏtop 100 percent
@primaryKey varchar(100),--·ÖÒ³Ö÷¼ü×Ö¶Î
@path nvarchar(1000), --Îļþ´æ·ÅĿ¼
@fname nvarchar(250), --ÎļþÃû
@sheetname varchar(250)='sheet1' --Òª´´½¨µÄ¹¤×÷±íÃû,Ä ......

sql serverÈÕÆÚʱ¼äº¯Êý

Sql ServerÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
    select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
   ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
   select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ