Web Database Application Development Techniques

    PHP-MySQL-Flash-JavaScript web application development for the irrigation prediction (2004 work)

        The application gets weather observation data, calculates, and creates dynamic graph & multiple pages display.

        The example can be found at   http://aiei.ifas.ufl.edu. To login, enter "jin" as user name and "jin" as password jin. Then click on "Graph Data" in the menu.  

       Request data from observation (e.g. AIEI-261.dat), insert observation data to database

    PHP-MySQL web application development for the coupon management online developed in Linux and Apache (2003 work)

         Screen Shots: index, choose which coupon to edit, data entry for adding a coupon.

ASP-XML-XSLT-SQL web application development for TV Guide on line ( main contribution to the demo at NAB 2002 national show)

         ScreenShot

        Database table display configuration ,  Full features

    ASP-MS SQL for maintaining and extending the web-based statewide application http://fawn.ifas.ufl.edu

    SQL Statement sample: Date Handling, MySQL statement, Union

JavaScript: Screener; MyWebPage;  Moving Picture; Floating Logo1, 2; Web Page link caption (mouse over a button to see what will happen), etc.

    CSS (Cascading Style Sheets): Examples

  Misc.: (1997 to 2004 work) Some experience with IIS 5; Building on-line store (2000 work) using ready to go software; Streaming video synchronized with dhtml for Ad Insertion Over the internet; Cookies by using *.asp; Searching; Email; PayPal online payment; Integrating output files of various computer technologies into a cohesive web based project; Regional view block; Picture protection; Custom icon for a website; Web statistics tools, website promotion and web traffic watching; Loading speed consideration; Browser compatibility; User computer resolution compatibility; Project planning; Marketing/advertising. 

MS Access Application and VBA/SQL Programming (Soil Lab Management is being developed now.)

       Screen Shot, Created advanced features at the beginning work: Advanced features developed

XML in Microsoft RS Format or Standard XML Format as well as DOMDocument Object
(2002-2003 work)

    1.  ADO Persist XML format and  XML92 format: Attributes type name represents field name of database, attribute value represents the database record.

          2.   Ordinary xml format: Element name represents field name of database, content represents database record data of database.

     1. Export database data to XML file: asp codes for both persist xml and xml 92 format

           2. Import XML file to database data using in Visual C++ and asp

    Display online data in XML format

    XSL file as a style sheet transfers the data of the XML file into an html table. (Installation of IE 6 and msxml 3 are required.)  

    Linking the XML document to the HTML page: Display XML element or attribute in web page: Table, List

SVG (Scale Vector Graphics) Programming: (2005 work)

    SVG is a language for describing two-dimensional graphics in XML.

    To view the sample, the installation of SVG viewer is required. However my web server does not install SVG viewer. Click here to install

  Documentation Tool

  HTMLHelp:(2001 work) 1. Window based sample NUMAPSManual.  (safe to open this file from CD) or click Window Application, CDDrive:\HTMLHelp\Hh4mfc.exe, then click help menu; 2. Web Based Sample (The 2001 technology would not work for new Window System).

Java-MS Access (A small part of a simulation team work in 2005)

    Screenshot 1, 2, 3, 4, 5. Seminar on error handling

   Reading data from on-line, user input, data file (command line), historical data from database

    Documentation for programming work: 1, 2, 3

Graphic Diagram in Scientific Research (2005 work)

    Tree Plan View , Layered Soil

Interactive Digital Multimedia Presentation which can be combined with web app. or window app.

    Macromedia Flash and ActionScript: (you may run and play these *.exe files from CD.  These *.exe files will not install anything on your computer):  MyProfile (see "My Profile" CD),  Greeting with advertising for Wal-Mart, ADNetLive, Email (Send data out of the Flash movie with the user's e-mail client),  Text Effect, Flash interacts with web page (controls web page closing). http://fawn.ifas.ufl.edu shows flash in web page.

Adobe Photoshop (Learning Exercise): Blending of multiple images (2003 work); Place images with other images; Image Slicing; Change background (New year's card).

Gif Animator: Florist asf file   (The 2000 technology would not work for newest version of Windows Media player.) This movie is created from a animated gif file.

     Adobe Premiere (Windows Media Player is required):  adnet.avi ; encode *avi to streaming file: adnet128.asf , adnet056.asf, adnet028.asf, adnet128.rm, adnet056.rm, adnet028.rm, Gift Certificate.

Microsoft Windows Media Technology (NetShow): (2001 work) Caption, Sami (smi programming), Florist (video control webpage), plug-in asf to PowerPoint, singer performance (convert VCR type to streaming file), lecture (Including video, black board & content table); combine video clip by using *.asx programming, embedded code in video clip. For more samples see Ad Insertion for Streaming Video and streaming event below

Real SMIL Programming (Real player is required): Florist, My House (this is a Real sample that I know how to create) 

Visio: Sample

Misc.:  Experienced with the following software: Ulead Video studio, Cool 3D,  PowerPoint, Macromedia Authorware, Macromedia Fireworks, CorelDraw, autorun, create Business card CD and CD labels, music CD creation.

Visual C++ Applications

ADO-XML:(2002 work) 1. Export Database to XML file, 2. Import XML file to Database for Pervasive.SQL database management system

DCOM System Application: (2002 work)1. Remote Encoder using Windows Media SDK; 2. Team work in Machine Components development  for TV Automation (Sony Mini Disk, DG System, DTMF Tone Generator, Accom Axess), which interface with the equipment by using RS422 protocol through COM serial port, using portmonitor to watch the input and output command and writing to event viewer.

COM Applications: (important contribution to the demo at NAB 2002 national show) 1. Video Capture (using DirectX SDK to convert analog video to digital video and display); 2. embedded player to receive Streaming Video.

Windows Applications: (2002 work)1. VersionScout (using multiple thread to search multiple PC hard disks files in network and to display their version info), 2. PromoPurger (edit, undo, redo, save, open record sets files with certain formats by using CList and CListView), 3. PromoManager (edit, save, open record sets files with certain formats by using Stingray Objective Grid)

Numerical Simulation:(1997 work) Partial Differential Equation Image Processing (Noise Reduction), data graph with noise, data graph with reduced noise . Display picture of raw numerical data of calculated matrix by using Metlab or Paint Shop Pro.

Misc.: My skills and experience also include: SQL, Database Server, thread, Unicode, port monitor, trace monitor, InstallShield, SourceSafe, Metlab, usage of SDK and entrance level of creating COM component, etc. 

Ten+ Years Numerical Simulation in Fortran, C, PHP and Java:

Multifunctional water and nutrient balance model for citrus irrigation schedule and nitrogen leaching prediction for decision support system of Citrus Production

        Simulation of One-Dimensional Steady Bipolar Semiconductor Devices (1981 work).

Films-Stopping, project description.(1993 work)

Fermi-Surface in Fortran (1993 work)

Commercial Insertion for Streaming Video Over the Internet (The 2000 technology may not work for newest version of Window System)

    Streaming Video Banner: (important contribution to the demo at NAB 2001 national show. See video banner below.) Windows Media Technology (The 2000 technology would not work for newest version of Windows Media player.), Real Technology (Real Player plug-in is required).  A video commercial plays in the banner at the top of the screen. To enlarge the commercial, click on "Click Here to Expand."  If you click on the "Click Here for Info" box under the enlarged window, the website of the advertiser will be displayed.  These are streaming video synchronized with DHTML by using both Microsoft Windows Media and Real technologies. These two products were used as part of the million dollar deal between Applied Digital Technology and Streamedia.

  To see the screen shot in Internet Explorer 6: movie control picture and text, click text to see the enlarger movie, click movie to see web page.

    Seamless Commercial Insertion for Streaming Video:  The commercial video can be in the same window as the main video and is not restricted to the beginning of the main video.  

Windows Media Tech. Demo 1 (important contribution to the demo at NAB 2000 national show) created by using script programming for play list and command, Demo 2 created by using NetShow tool (edit and embed script command inside the video to create video caption. The caption may not show with the newest version of the Windows Media player)  When the caption shows up, clicking on the caption will display the website of the advertiser.   

Real Technology Demo created by using script programming to control video caption timing. When the caption show up, clicking on the caption will display the website of the advertiser.

     Streaming Application Development: Customized Frame, Streaming Video Banner in JavaScript, VBScript or Visual C++ by using SDK

    Two Years Research in Ad Insertion for Streaming Video using streaming video server and video encoder for video streaming (live, semi live or video on demand); inserting video of Ad by sending command in real time from server or from encoder; monitoring streaming and video properties; etc. for both Windows Media Technology and Real Technology. Click here to see where to insert the Ad.

Streaming Event 

Tennessee Beauty Pageant Show

UF Homecoming

Telenorba, Bari, Italy

Fast Track to Fame

Chinese Language

Characters type; character input by using pen writing; fast computer translation between English document and Chinese document; convert Chinese picture file to text file; convert between Chinese operating system and English operating system; photo edit with Chinese font

My Working Style