外文翻譯---在powerbuilder中處理圖片文件的方法研究

1、中文 中文 2696 字出處： 出處：Computer Science and Information Technology, 2009. ICCSIT 2009. 2nd IEEE International Conference on. IEEE, 2009: 405-407翻譯部分 翻譯部分英文原文Study on method of picture files processing in PowerBuilderJia Yinj

2、iang Zhang Tiejun Zhao JunyingAbstract—Pictures are one of the important elements of which the application is composed. A programmer is able to choose suitable treatment according to the system requirement. In PowerBuild

3、er picture control and ole control are the most commonly-used methods; blob data type field is used to access picture files in database and function of data window is used to display pictures dynamically. Each method has

4、 its own characteristics and application conditions. This article discusses and explores the methods of storage and display of picture files in PowerBuilder.Keywords: Blob Data Type; Picture Control; PictureProcessingI.

5、INTRODUCTIONPictures are composed of an important element in the application. Flexibility in the use of the picture will make the procedure more attractive. Method of picture files processing mainly includes picture stor

6、age, display and update, etc. PowerBuilder in access the database and data processing has a very strong function but weak in picture storage and display. As long as we master some commonly-used development skills, we wil

7、l be able to solve picture processing problem well in the practical application. Pictures stored in the form of file can be displayed with picture control or ole control; pictures stored in the database,a blob data type

8、field needed to be defined and picture data isoperated with binary large object command. In addition to the above two methods, pictures also can be displayeddynamically by using of the modify function of data window.Each

9、 method has its own characteristics and applicationconditions. This article discusses and explores the methods of storage and dw_1.settransobject(sqlca)dw_1.retrieve()Script code in clicked event of the command button is

10、 as following:string ls_string,ls_fnstring ls_filepath,ls_filenamegetfileopenname(“please choose the picture files“,ls_filepath,ls_filename,“bmp“,“bmp files(*.bmp),*.bmp,jpg files(*.jpg),*.jpg,all files (*.*),*.*“ )ls

11、_fn=ls_filepathls_string='create bitmap(band=detail x=“800“ y=“10“ width=“500“ height=“470“ ls_filename=“'+ls_fn+' “ border=“2“ name=ls_pn)' dw_1.modify(ls_string) Run window and click the command button,

12、 choose a picture in the pop-up dialog box, the selected picture will be displayed in detail band of data window, position is x=800 and y=10, picture size is 500 multiplied 470 pixels, border style is 2, that is “stylebo

13、x” type.This method has the following characteristics in comparison with ole control and picture control style: First, data window functions can support more file type and display a variety of file type formats, includin

14、g BMP, JPG,GIF, WMF Image file format, etc. Second, data window functions have the characteristics of flexibility, freedom, and can be set up in function of picture position, size, border, display area, and other propert

15、y. Third, faster images and less memory, pictures display are not placed to set a control, but dynamically generated in the process of program running.III. PICTURE FILES ACCESS IN DATABASEA. Access Pictures through the F

16、ile PathIn order to illustrate the operation of picture files, here two tables and their structure defined are given below: TABLE I. TABLE TPBColumn Name Data Type Width Null RemarkTpbh varchar 20

17、 No Primary Keytplj varchar 50 YesTABLE II. TABLE STUDENTColumn Name Data Type Width Null Remarkxh varchar 10 No Primary Keyxm varchar 8 Noxb