₦airaland Forum

I am up for this project. I think this project is NOT for light minded people. I would suggest we open a CVS (Concurrent Versions System) which is software package to manage software development done by several people. We can host the CVS as a web server so that registered users can login and submit their code and collect new task.

Basically, we will have a project manager that provides task by the help of system analyst and software engineers. We need to create a project plan i.e. to develop a Nigeria super mario. The project manager would now break the task into small manageable parts. Users can login and allocate themself a task when finished would login and submit the code, at the the software engineer will engineer the whole code to produce a game.

Mind you to develop a very good game software we would need C/C++, 3DMax, Photoshop, Unreal, Doom3 and ZBrush.

[glow=#bbffcc,0,50]I know this is long code and most probably you will not need all the methods.  Use the ones that apply to use and discard the rest[/glow]
       
       

package com.sun.projectDir.db;

import java.net.*;
import java.sql.*;
import java.io.*;
import java.util.*;
import java.util.Date;

public class EnterpriseBean {
    
    
    private String temp;
    private static final String username = "admin";
    private static final String password = "admin";
    private static String error;
    private static Connection con;
    private static Statement stm;
    private static ResultSet rs;
    private static final String DRIVER = "jdbc:mysql://localhost:3306/databasename";
    private static final String url = "com.mysql.jdbc.Driver";
    
    public EnterpriseBean( ){
        try{
            this.connect( );
        }catch( SQLException e ){
            error = "Unable to connect to databse from initial Contructor";
        }catch( Exception ed ){
            error = "Exception in the constructor";
        }//End exception
    }//End contructor
    
  /*
    This method connect user(s) to MDBS
   */
    public void connect( )throws SQLException, Exception{
        try{
            Class.forName( DRIVER ).newInstance( );
            con = DriverManager.getConnection( url, username, password );
        }catch( SQLException sql ){
            error = "Could not connect to data base";
            throw new SQLException( error );
        }catch( Exception ioe ){
            error = "An unknown error while connecting to data base";
            throw new Exception( error );
        }//End exceptions
    }//End connect method
/*
This methos disconnect user(s) from MDBS
 */
    public void disconnect( )throws SQLException, Exception{
        try{
            if( con != null ){
                con.close( );
            }//End if
        }catch( SQLException exp ){
            error = "Unable to close data base connection";
            throw new SQLException( error );
        }//End try catch
    }//End disconnect Method
/*
This method insert an array string containing data into
MDBS. The querry must be an array of type String Object
 */
    public void executeQuery( String []query )throws SQLException, Exception{
        try{
            PreparedStatement update;
            update = con.prepareStatement( "INSERT INTO tracking VALUES( ?, ?, ?, );" );
            for( int index = 0; index < query.length ; index++ ){
                update.setString( index+1, query[index] );
            }//End for
            update.execute( );
//stm = con.createStatement( );
//stm.executeUpdate( query );
        }catch( SQLException sql ){
            error = "executeQuery problem from database";
            throw new SQLException( error );
        }catch( Exception ioe ){
            error = "An unknown error while connecting to data base";
            throw new Exception( error );
        }//End exceptions
    }//End executeQuery
    
/*
This method insert an array string containing data into
MDBS. The querry must be an array of type String Object
 */
    public void executeQuery( String query )throws SQLException, Exception{
        try{
            PreparedStatement update;
            update = con.prepareStatement( query );
            update.execute( );
//stm = con.createStatement( );
//stm.executeUpdate( query );
        }catch( SQLException sql ){
            error = "executeQuery problem from database";
            throw new SQLException( error );
        }catch( Exception ioe ){
            error = "An unknown error while connecting to data base";
            throw new Exception( error );
        }//End exceptions
    }//End executeQuery
/*
This method insert an array string containing data into
MDBS. The querry must be an array of type String Object
 */
    public void executeQueryInventory( String []query )throws SQLException, Exception{
        try{
            PreparedStatement update;
            update = con.prepareStatement( "INSERT INTO customer VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, );" );
            for( int index = 0; index < query.length; index++ ){
                update.setString( index+1, query[index] );
            }//End for
            update.execute( );
//stm = con.createStatement( );
//stm.executeUpdate( query );
        }catch( SQLException sql ){
            error = "executeQuery problem from database";
            throw new SQLException( error );
        }catch( Exception ioe ){
            error = "An unknown error while connecting to data base";
            throw new Exception( error );
        }//End exceptions
    }//End executeQueryInventory
/*
This method try to update a record column where values which are array type of
string to "Resolved"
 */
    public void resolveData( String [] values ) throws SQLException, Exception{
        
        if ( con != null ){
            try{
                PreparedStatement resolve;
                resolve = con.prepareStatement( "UPDATE customer SET status= ? WHERE telephone = ?" );
                for ( int index = 0; index < values.length; index++ ){
                    resolve.setString( 1, "Resolved" );
                    resolve.setString( 2, values[index] );
                    resolve.executeUpdate( );
                }//End for
            }catch ( SQLException e ){
                error = "update failed: possible update error";
                throw new SQLException( error );
            }catch ( Exception e ){
                error = "An exception occured while updating bug";
                throw new Exception( error );
            }//End try
        }else{
            error = "Exception occured while connecting to database";
            throw new Exception( error );
        }//End if
    }//End removeBug
/*
This method take every selected string record from bugDetails and put them into
archive table
 */
    public void archiveData( String []theData ) throws SQLException, Exception{
        
        String fname = null;
        String lname = null;
        String address = null;
        String postcode = null;
        String telephone = null;
        String dob = null;
        String sex = null;
        
        if( !isConnect( ) ){
            this.connect( );
        }//End if
        try{
            for( int index = 0; index < theData.length; index++ ){
                String query = "SELECT * FROM customers WHERE cid="+theData[index];
                stm = con.createStatement( );
                rs = stm.executeQuery( query );
                while( rs.next( ) ){
                    fname =rs.getString( "name" );
                    lname =rs.getString( "lastname" );
                    address =rs.getString( "address" );
                    postcode =rs.getString( "postcode" );
                    telephone = rs.getString( "telephone" );
                    dob =rs.getString( "dob" );
                    sex =rs.getString( "sex" );
                    
                }//End while
//If you want to save customer details for later i.e. customer values
                String insert = "INSERT INTO archive VALUES( '"+fname+"', '"+last+"',"+
                        "'"+address+"', '"+postcode+"', '"+telephone+"',"+
                        "'"+dob+"','"+sex"')";
            }//End for
        }catch( SQLException e ){
        }catch( Exception ex ){
        }//En exception
    }//End archiveData
    
/*
Update the database record by supplying the values as string array
 
 */
    public void updateData( String []key, String values ) throws SQLException, Exception{
        try{
            PreparedStatement update;
            update = con.prepareStatement( "UPDATE customer SET cid= ? WHERE phone = ?" );
            for( int index = 0; index < key.length; index++ ){
                update.setString( 1, values );
                update.setString( 2, key[index] );
                update.executeUpdate( );
            }//End for
        }catch ( SQLException e ){
            error = "update failed: possible update error";
            throw new SQLException( error );
        }catch ( Exception e ){
            error = "An exception occured while updating bug";
            throw new Exception( error );
        }//End try
    }//End updateData
    
/*
Reomve or delete record from database. Pass this method string array of
record to delete.
 */
    public void removeData( String [] values ) throws SQLException, Exception{
//con.setAutoCommit( false );
        if ( con != null ){
            try{
                PreparedStatement delete;
                delete = con.prepareStatement( "DELETE FROM customer WHERE phone=?;" );
                for ( int index = 0; index < values.length; index++ ){
                    delete.setString( 1, values[index] );
                    delete.execute( );
                }//End for
//con.commit( );
//con.setAutoCommit( true );
            }catch ( SQLException e ){
                error = "update failed: possible delete error";
                throw new SQLException( error );
            }catch ( Exception e ){
                error = "An exception occured while deleting bug";
                throw new Exception( error );
            }//End try
        }else{
            error = "Exception occured while connecting to database";
            throw new Exception( error );
        }//End if
    }//End removeBug
/*
Get all the records from any database table. The record is store in
Resultset, which is return to the caller of this method
 */
    public ResultSet viewQuery( String query )throws SQLException, Exception{
        try{
            stm = con.createStatement( );
            rs = stm.executeQuery( query );
        }catch( SQLException sql ){
            error = "Record set update problems";
            throw new SQLException( error );
        }
        return rs;
    }//End viewQuery
/*
Get all the records from any database table. The record is store in
Resultset, which is return to the caller of this method
 */
    public ResultSet viewQuery( )throws SQLException, Exception{
        return rs;
    }//End viewQuery
/*
Close Rseultset that is connected to a conncetion database
Call this method if you want to close Resultset connection
 */
    public void closeRs( )throws SQLException, Exception{
        try{
            rs.close( );
        }catch( SQLException e){
            error = "Could not close result set";
            throw new SQLException( error );
        }//End exception
    }//End closeRs
    public boolean isConnect( ) {
        if( con != null )
            return true;
        else
            return false;
    }//End isConnect
}//End EnterpeiseBean

Tell me if you need any help

[glow=#ff55tt,0,50]Learn Software Engineer using Java[/glow]

@Senu, please can you increase the charater numbers for "Maximum allowed characters in signatures" I need to edit my signature to a url link but the character you set do not allow me to add more entries... please

In tomcat reference container for Java the directory structure is organised in this form.

     webapps
        appsDir
          index.html
         jsp
            search.jsp
            login.jsp
         WEB-INF
           web.xml
            classes
                com -- optional
                   sun  -- optional
                      projecDir   -- optional
                        db  -- optional
                        beans -- optional
                        controller -- optional
                        servlet -- optional
           lib -- optional

             

Put this code in the beans directory

[glow=brown,0,50]
import java.io.*;
import java.io.serializable;

public class SessionBean extends Serializable{
/**
   * If you need to use other session attributes, mut be listed here
*/

       String upsTrackNumber = null;
       public SessionBean ( ){
       }//End default Contructor

     // Get the string from the user HTTP session and set it to object
      public void setUpsTrackNumber (String toSet){
         this.upsTrackNumber = toSet;
      }//End setUpsTrackNumber

    // Return this object back to any calling object, probably to access the db
     public String getUpsTrackNumber ( ){
        return this.upsTrackNumber;
    }//End getUpsTrackNumber
}//End SessionBean
[/glow]

The HTML file above find the <form method=post action=""> in the action part between the quotes put search.jsp . Below is the search script


[glow=magenta,0,50]
<@ page import="com.sun.projectDir.beans.SessionBean"%>
<@ page import="com.sun.projectDir.db.EnterpriseBean" %>
<jsp:useBean id="ups" scope="page" class="com.sun.projectDir.SessionBean" />
<jsp:useBean id="eb" scope="session" class="com.sun.projectDir.db.EnterpriseBean" />
<jsp:setProperty name="uspTrackNumber" property="*" />
<HTML>
   <HEAD></TITLE>Ups Tracker</TITLE>
    </HEAD>

  <body>
                  <%

                        String firstName = null;
                        String lastName = null;
                        String address   = null;
                        String postCode = null;

                         //etc. Put all the information You want to display

                             
                            String upsNumber = ups.getUpsTrackNumber();
                            if ( upsNumber != null ){
                               eb = new EnterperiseBean ( );
                               firstname = eb.getFirstname();
                                //etc.
                            }//End if
       %>

         <Table boder=0>
                  <Td>
                       <tr>First Name</tr>
                        </tr>Last Name</tr>
                       etc.
                    </Td>

            <%=firstName%>
            <%=lastName%>
            <!--
                    etc.  All the information you want to view
             -->
     </table>
   </body>
</html>

[/glow]

I will write the EnterpriseBean for you later.  This is how the system access your database.

If you ask me Nigeria needs a [glow=blue,2,50]Project Managers[/glow] to manage and run the conutry. Because Nigeria herself is a project and by my estimation needs 50 years to manage under good project manager.  She needs someone with 30 years of sucessfull project management to lead us.  We don't need liars like lawyers, accountants, ex-leaders and millitary junters.

For jees sake what would it take to fix Nigeria?  My heart bleeds for that country, I wakeup everyday and say to myself I wish Nigeria was like London. But isn't that ironic, London was once like Nigeria corruption, crime, slavery etc. but the revolute and fight off the bad leaders.  Well, maybe we should do the same.

We all know what is good and how to make it good.  So what is the problem then?  What is holding us back? I don't like that saying that Nigerian are Intelligent, intelligent my foot.  To live in a nice house and probably drive the most expensive car in a poor road makes you intelligent, haaar!.  We can not even be accepted in world wide ecommerce because of Nigeria attainment in fraud.

No proper good and sucessful infrastructure has been put up after the colonial reigm.  Maybe we should call back the colonial master back in again.  I would not like it more than any one of you but I'd been in a better hands to these crimainals ruling us.

[move][glow=navy,1,50]
A simple interface, HTML, modify to suit your style[/glow][/move]

[center][glow=magenta,1,50]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>UPS</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>



<body><form name="form1" method="post" action="">
<div align="center">
 <table width="465" border="0" cellpadding="0" cellspacing="0">
   <!--DWLayoutTable-->
   <tr>
     <td width="30" height="21">&nbsp;</td>
     <td width="28">&nbsp;</td>
     <td width="21">&nbsp;</td>
     <td width="24">&nbsp;</td>
     <td width="202">&nbsp;</td>
     <td width="55">&nbsp;</td>
     <td width="40">&nbsp;</td>
     <td width="65">&nbsp;</td>
   </tr>
   <tr>
     <td height="77">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td colspan="2" valign="top"><table cellspacing="0" cellpadding="0">
       <tr>
         <td class="pi-mA1-c-t-spc"></td>
       </tr>
       <tr>
         <td class="pi-mA1-c" valign="top"><table cellspacing="0" cellpadding="0">
             <tr>
               <td>Please enter your UPS Tracking Numbers below and select the Track button. You can enter only to 1 numbers at a time. </td>
             </tr>
         </table></td>
       </tr>
     </table></td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="22">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="31">&nbsp;</td>
     <td valign="top">1.</td>
     <td>&nbsp;</td>
     <td colspan="4" valign="top">  <input name="textfield" type="text" size="50" maxlength="30"></td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="26">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="33">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td colspan="4" valign="top"><input type="submit" name="Submit" value="ok                "></td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="155">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
 </table>

</div>  </form>
</body>
</html>
[/glow][/center]

I will post the [glow=red,2,50]JSP[/glow] code later to access the database.  Remember my solution is purely Java platform

#### ATTENTION:

#
# Table structure for table `customer`
#
CREATE DATABASE upsTraking;
USE upsTraking;

#### ATTENTION:

#
# Table structure for table `customer`
#
CREATE DATABASE {databasename};
GRANT ALL PRIVILEGES ON {databasename}.* TO 'databaseuse_user'@'localhost' IDENTIFIED BY 'thepassword';
USE {databasename};
FLUSH privileges;

CREATE TABLE Customer (
  CID int(11) unsigned NOT NULL auto_increment,
  ID_MSG int(10) unsigned NOT NULL default '0',
  Firstname varchar(128) NOT NULL default '-1,0',
  Lastname  varchar(128) NOT NULL default '-1,0',
  Address   varchar(128) NOT NULL default '-1,0',
  Postcode  varchar(10) NOT NULL default '-1,0',
  Telephone int(10) unsigned NOT NULL default '0',
  DOB       int(10) unsigned NOT NULL default '0',
  Sex       varchar(5) NOT NULL default '-1,0',
  CONSTRAINT cid_pk PRIMARY KEY (CID),
  UNIQUE ID (ID, CID),
  KEY ID_MSG (ID_MSG)
);

#
# Table structure for table `tracking`
#

CREATE TABLE tracking (
  TrakingID int(10) unsigned NOT NULL default '0',
  UNIQUE ID (ID, CID),
  CID int(11) unsigned NOT NULL,
  FOREIGN KEY (CID),
  REFERENCES customer(CIS) ,

);


The is probably the mysql database schema you will need NOTE is it not normalized, so you can do that. Save it as my.sql and run it on your prefer database.  Change the {} to your prefer settings.

We are willing to help you since you asked nicely, but you need to tell us what script language you would prefer it on i.e. php, asp, jsp, c#, j#, .NET etc. and I thinks it would probably be a database solution for optimization purpose.  What database server, would like it one oracle, mysql, db2, pointbase etc.?

I believe there are professional web-driven database designers here.  I would personally help you if it were on Java platform.  I don't want to start learning php and asp as I find them boring.


[center][glow=red,2,150]Java rocks[/glow][/center]

Probably, this is off-course the subject topic, but I was wondering if anyone knows a good freeware Mysql Editor?

[quote author="larger_20"]I hate to break it to u but you're this-qualified.[/quote]Why attack IK, he is only trying to get a job. Anyway sha, pass English or no pass English poster should be able to proof read their comments.

[quote author="babagana"]Why Is It Bad When A Woman Sleeps With Many Men But Cool When A Man Does Same?[/quote]Because women feel used, but men feel fulfilled. It is ironic because I felt used once.

Ghana man get very upset when someone refer them as ghananian. A person from Ghana is refer to as Ghanians.

[quote author="Bonie"]It dosn't matter where your Wife comes from, After all our Nigerians are far abroad marrying from every corner, why not; in our own mother land. any way Inte- Tribal Marriage at time is one ofthe best, is just sal about understanding, my Uncle marry a ghananian lady and they ar doing fine, its all about understning boooooooooooooooo[/quote]Correction, there is no such thing as ghananian, it is Ghanian.

Send your Requirements Specification, and visit http://www.getafreelancer.com/ and put your project there. Tell me when u do, then I will bid for it.

Soulful, I have send you an invite to enitan@hotmail.com

Chxta, how much are you willing to pay for it?. Also can you post your requirement specifications

See these figures

1. http://ezmoney2u.bravehost.com/12dailypro/img/12dpcalc1.GIF


Other affiliates program

2. http://radu20.xhost.ro/

Yes, I invested heavily and so far so good.  Remember.

Disclaimer Please always be aware that investing your money online comes with risk, and that you should never invest what you cannot afford to lose!

Maybe you should look here http://www.getafreelancer.com/

I know many of use do not know that importance of antivirus untill someone in Zurich start using my credit card. Here is a free antivirus scan, if your antivirus has expired. Remember because you bought your PC with antivirus do not make you immune to virus for life. Antivirus expires and requires monthly subscription fee to send you update virus file.

In case you have forgotten to subscribe here is a free scan

http://housecall.trendmicro.com/

I you don't mind investing money to make money here is a website I would strongly recommend for guys with lynx eyes. http://www.12dailypro.com/?ref=253465

Post your email address you would like to receive the gmail account, I would send you an invite