To connect the MySQL database with Visual Basic, MySQL ODBC drivers should be installed and configured on the system. The following steps show how was the installation process have been done.
Download MySQL for Windows (x86) setup file from their official web site. (http://dev.mysql.com/downloads/mysql/5.0.html)
Downloaded ODBC 3.5.1 MSI Installer (stable) for Windows (x86) from http://dev.mysql.com/downloads/connector/odbc/3.51.html
Once downloaded the files and before installing them t...
more »
Variables
I have enabled the Option Explicit statement, because to declare all the variables in my program. [I checked the Require Declaration option on the Editor Tab of the Option dialog box]
To declare a variable I used the following statements:
• Dim (e.g. Dim filenumber As Integer)
• Private
• Public
• Static
The following table lists the scope of a variable and its accessibility from various sections of a project....
more »
Programming techniques
The implementation phase of software development is also concerned with translating the design specification into source code.
This section describes the overall process of implementing the Webmaster Console (WmConsole). The technical configuration about the connection between the MySQL database and Visual Basic is described. And descriptions of the screen shots and source code of the WmConsole is also explained.
Coding style
It has been recognised that a good ...
more »
A database is used to store user details such as the user name, password, and access level. The below table shows the fields, attribute type and the description of the user table.
...
more »
There were many tools and technologies available to implement this project. Some of the tools that I have used:
Microsoft Windows XP:
Microsoft windows XP is an operating system which is more widely used and all the computers in BMJ has installed and running this software and the users in BMJ also used to the windows environment. Because of this it was decided that this application would be design and capable to run under windows operating system.
Microsoft Visual Basic 6.0
Visual Ba...
more »
User Interface is a very important thing when designing the application. User interface provides a mechanism for end users to interact with the application. Designing a good user interface which is easy to use and understand is crucial for a successful application. A well designed user interface makes it easy and simple for the user to understand and use. And a poorly designed user interface will be hard to understand and use and can lead to distraction and frustration.
The following four pri...
more »
The evolutionary model
The evolutionary model is also known as the prototyping model. The basic idea of prototyping is that instead of fixing requirements before design and coding can begin, a prototype is built to understand the requirements. It is built using known requirements. Designing the prototype gives a feel of how the real system will look.
Current sbmj monthly process (manual)
In short the current tasks can be summarised as follows:
Take content and convert into html files.
P...
more »
Functional requirements
Authenticated method for access the system
Prepare template and directories for population
Generate Article template
Strip and process HTML pages
Edit HTML to prepare for populating templates
Populating the templates with article text
Rename Images (Batch process)
Converting Images (Image resize)
Prepare current issue template
Search files and folders
Search and replace file contents (batch processing)
Inbuilt FTP Client
Non-functional requi...
more »
Methodology
I have used DSDM methodology in my project. DSDM (Dynamic Systems Development Method) is a framework and it focuses on delivery of the business solution, rather than just team activity. It used to check the feasibility and business sense of a project before it is created.
I used this framework in my design and implementation phase of my project. The reasons why I have chosen this framework are because the system is delivered on time and on budget, the client is actively involve...
more »
The key overall objective of this project is to provide the facility and the tools for processing the HTML pages, populating PHP templates, processing images for the webmaster to manage the monthly process of the studentBMJ.com website. This will include some in-built tools such as template editor, HTML Stripper, Search, Batch rename, FTP client, etc...
This solution will make the process easy, accurate and reduce the time.
The project aims, objectives and the deliverables which this project...
more »