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
Ïà¹ØÎĵµ£º
ÏÂÃæÊÇÖ¸µ¼Îĵµ¡£Çë¸ú×ÅÒ»²½²½µÄ×ö¡£¾ÍÄܳɹ¦Á¬½ÓÉÏsql server 2008
javaÖÐÁ¬½Ósql server 2008µÄ×¢ÒâÊÂÏ
2000£¬2005µÄÊý¾Ý¿âÇý¶¯ÀàµÄд·¨ÊÇ£º
com.microsoft.jdbc.sqlserver.SQLServerDriver
URLµÄд·¨ÊÇ£º¼ÙÉèÊý¾Ý¿âÊÇnews
jdbc:microsoft:sqlserver://localhost:1433;databaseName=news
µ«ÊÇ20 ......
--¿ç·þÎñÆ÷²éѯÈçÏ£º
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Öеıí
--ÐèҪעÒâµÄÊÇÈô¶þ¸ö±íÖÐµÄ ......
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ÖеÄÈÕÆÚÓëʱ¼äº¯Êý
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
ÀýÈ磺ÏòÈÕÆÚ¼ÓÉÏ2Ìì
select dateadd(day,2,'2004-10-15') --·µ»Ø£º2004-10-17 00:00:00.000
3. datediff ·µ»Ø¿çÁ½¸öÖ ......