Ӧ
COMPUTER APPLICATIONS
1999 19 10 Vol.19 No.10 1999



ASPWebӦݿͼݵĴ
·
ͼΪMicrosoft SQL Server6.5Ϊݿϵͳ΢ASPȽܷ˼룬ȻݿṹΣ˵Visual Basic 4.0ADO1.5ActiveX ڿASP WebӦõĹУʹǹڽݿͼݴActiveX 
1
ǿԲԼϤһֱ(Visual BasicVisual C++Visual J++)һЩضActiveX ԱASPWebӦʱʹáΪɶݿͼݵЧǿһActiveX LoadImageòɴ SQL ServerйرȡͼݣȡĶͼݴһʱͼļСWebӦҪݿд洢Ķͼݷ͵ͻڿͻжʾʱASPͨøòйطȡʱͼļλáHTML<IMG>ǣݿϵͳд洢Ķͼݿ׵ıصͻʾ
2ݿ
Microsoft SQL Server д洢ͼݵݿжӦΪimage΢SQLҵ(SQL Enterprise Manager)Ժ׵شݿ⡣ǽһ4MСΪtestdbݿ⡣Ϊ˱˵ͻص㣬testdbݿֻһTestImg TestImgSQLű£
create table TestImg( imgid numeric identity,
imgtype char(3) null,
imgdata image null,
imgdes text null,
constraint PKTESTIMG primary key
(imgid)
)
imgidΪñimgtypeͼͣgifjpgWebӦʹͼ͡imgdataд洢ͼݡimgdesдͼı
3ActiveX 
Visual Basic 4.0ActiveX Ĺ£
1) ʼVisual Basic 4.0ProjectΪLoadImage
2) ѡTools˵еOptions˵Ȼ굥Project tabProject Nameı༭мLoadImage
3) ȥVisual Basic 4.0Զȱʡ(DefaultForm)
4) Insert˵Class Module˵ProjectмһImageࡣڸ(property)УInstancingΪ2 - Creatable MultiUseNameΪImagePublicΪTrue
5) ΪActiveX ڵ(Entry Point)еActiveX Ҫһڵ㡣ASPļдòĶʵʱ뽫ڵ㿪ʼִСActiveX ڵΪModuleSub Main̡ΪˣInsert˵Module˵һģ(Module)ڳģĴм磺
Sub Main()
End Sub
6) Imageм´룺
Private mDbConn As Object䶨ݿӶ
Private mDbRec As Object䶨ݿ¼
Private fld As Object䶨ݿֶζ
Private mFileName() As String飬ڴʱļ·
Private mlngImageId() As LongڴͼID顣
Private mlngNumberOfFiles As LongʱļĿ
Const bSize = 1024һδӿжȡbyte
ImageFileڷʱļ
Public Property Get ImageFile
(ByVal imgid As Integer) As String
Dim intPos As Integer
Dim i As Integer
For i = 0 To mlngNumberOfFiles - 1
If mlngImageId(i) = imgid Then
intPos = 5 + Len(Trim(Str(imgid))) + 4
ImageFile = Right(mFileName(i), intPos)
End If
Next i
End Property
 CreateImageFile̸ͼIDӦʱļ
Public Sub CreateImageFile
(ByVal imgid As Integer)
Dim SqlCmd As String , OutputFile As String,
ImageType AsString
Dim OutputFileNum As Integer, 
LeftOver As Long, i As Integer,byteData() As Byte
For i = 0 To mlngNumberOfFiles - 1
If mlngImageId(i) = imgid Then 
ʱͼļǷѴڡ
Exit Sub
End If
Next i
mDbConn.ConnectionString = "DRIVER={SQL
Server};SERVER=(local);UID=sa; " &
"PWD=sapassword;WSID=CONTROL;DATABASE=testdb"
ݿַ
mDbConn.ConnectionTimeout = 15
mDbConn.Open 
ݿӡ
SqlCmd = "SELECT * from TestImg 
where imgid=" &imgid 
SQL
Set mDbRec.ActiveConnection = mDbConn
mDbRec.Open SqlCmd, , 0, 1
ݿ¼
Set fld = mDbRec.Fields("imgdata")
öӦֶζ
mlngNumberOfFiles = mlngNumberOfFiles + 1
ReDim Preserve mFileName(mlngNumberOfFiles)
ĴС
ReDim Preserve mlngImageId(mlngNumberOfFiles)
ĴС
mlngImageId(mlngNumberOfFiles - 1) = imgid
ImageType = mDbRec.Fields("imgtype")
ȡͼϢ
mFileName(mlngNumberOfFiles - 1) =
App.Path & "\images" &"\image" & Trim(Str(imgid)) & "." & ImageType 
乹ʱļȫ·
OutputFile = mFileName(mlngNumberOfFiles - 1)
OutputFileNum = FreeFile
Open OutputFile For Binary As #OutputFileNum 
䴴ԶƷʽʱļ
FileLength = fld.ActualSize - 1
ʤͼݵĴС(byte)
NumBlocks = FileLength bSize
LeftOver = FileLength Mod bSize
byteData() = fld.GetChunk(LeftOver)
ȡͼݡ
Put #OutputFileNum, , byteData() 
׷ͼݵʱļ
For i = 1 To NumBlocks
byteData() = fld.GetChunk(bSize)
Put OutputFileNum, LeftOver + (i - 1) 
* bSize, byteData()
Next i
mDbRec.Close 
رռ¼
mDbConn.Close 
رݿӡ
Close #OutputFileNum 
رʱļ
End Sub
ʼ̴ݿӶͼ¼
Private Sub ClassInitialize()
mlngNumberOfFiles = 0
Set mDbConn = CreateObject("ADODB.Connection")
Set mDbRec = CreateObject("ADODB.Recordset")
End Sub
ͷռϵͳԴ
Private Sub ClassTerminate()
If mDbRec.State = adStateOpen Then mAdoRst.Close
If mDbConn.State = adStateOpen Then mAdoConn.Close
Set mDbRec = Nothing
Set mDbConn = Nothing
End Sub
7) ɱ롣ɱWindows NTWindows 95regsver32.exeߣActiveXеǼעᡣ
4ʹActiveX 
΢Visual InterDev 1.0 һWebĿ(Web Project)ڸĿнһASPļShowImage.aspʹǵActiveX ʱӦASPServerCreateObjectһActiveX ʵȻCreateImageFileڽʱͼļεImageFileȡʱͼļļͨHTML<IMG>ǽͼڿͻϽʾǼҪʾimgid=20ͼݣӦASPļShowImage.asp£
<%@ LANGUAGE="VBSCRIPT" %>
<HTML>
<HEAD> <TITLE>Show Database Image</TITLE> 
</HEAD>
<BODY>
<% Set MyObj=Server.CreateObject("LoadImage.Image")
MyObj.CreateImageFile(20)
FileName = "./images/" & MyObj.ImageFile(20) %>
<font size=6> Here is the Image retrieved: </font>
<IMG ALIGN=BOTTOM SRC= "<% =FileName %>">
</BODY> </HTML>
5
ͨһActiveX ASPʵWebӦнݿϵͳд洢ĶͼڿͻϽʾ÷пڶ̣ʹףŵ㡣WebӦÿԱø÷Ƴҵľ걸ܵActiveX ɶݿϵͳд洢ĶͼݵЧ
߼飺·ʿҪоӦ硣
ᡡʦҪоϢ
ߵλѧԶϢѧԺ.(710048)
ο
1ݡPiroz Mohseni. Webݿ⿪Աָ. еҵ磬1997
ո:1999-05-06(޸ĸ)
