Employeealary.java:;;;


package test.salaryhike;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class EmployeeSalary {

    public void salaryhike(Connection con, String dateofjoin){

        //Write your code here
           
    }
    public static void main(String[] args){

        Connection con = null;

        //TestCase 1      
  try{
            con = DBConnection.getConnection();
            String date = "2005-10-21";
            new EmployeeSalary().salaryhike(con,date);
        }
        catch(Exception e){
            e.printStackTrace();
        }
        finally{
            if(con!=null)
            DBConnection.closeConnection(con);


        }   
 }

}

================================================
DBConnection.java:::::::::

package test.salaryhike;

import java.sql.Connection;
import java.sql.SQLException;
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

// Use the DBConnection class to connect with the database.
// All database connection properties are specified.
// You don't need to change anything in this class.
public class DBConnection {
    // Use this to get a SQL Connection
    public static Connection getConnection() throws Exception {
        try {
            doInit();
            return mDataSrc.getConnection();
        } catch (Exception e) {
            System.out.println("[DBConnection.getConnection]: " + e.toString());
            throw e;
        }
    }

    // Use this to close a SQL Connection
    public static void closeConnection(Connection connection) {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (Exception e) {
            System.out.println("[DBConnection.closeConnection]: " + e.toString());
        }
    }

    // Use this to test whether the database connection works or not.
    public static void main(String args[]) {
        try
        {
            Connection conn = DBConnection.getConnection();
            System.out.println("DBConnection.getConnection Success...");
            DBConnection.closeConnection(conn);
            System.out.println("DBConnection.closeConnection Success...");
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    // Private variables and functions
    private static MysqlDataSource mDataSrc = new MysqlDataSource();
    private static boolean isInitDone = false;
    private static String DB_SERVER = "202.138.101.234";
    private static int DB_SERVER_PORT = 3306;
    private static String DB_NAME = "mysqldb_139826";
    private static String USER_NAME = "mysqldb_139826";
    private static String USER_PASSWORD = "mysqldb_139826";

    private static synchronized void doInit() throws Exception {
        if (isInitDone) return;
        mDataSrc.setServerName(DB_SERVER);
        mDataSrc.setPort(DB_SERVER_PORT);
        mDataSrc.setDatabaseName(DB_NAME);
        mDataSrc.setUser(USER_NAME);
        mDataSrc.setPassword(USER_PASSWORD);
        isInitDone = true;
    }
}