private void DisplayPackageData() {
	
		try {
			// if the action mode is add, exit here
			if(actionMode.equals("add")){
				return;
			}
			
			// creates DB connection
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "ictoosd", "ictoosd");
			Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			
			// ***Select package data
			// Select SQL
			String sql = "select ";
			sql += "pkgname,pkgstartdate,pkgenddate, ";
			sql += "pkgbaseprice,pkgagencycommission,pkgdesc ";
			sql += "from packages ";
			sql += "where ";
			sql += "packageid = " + packageID;
			
			// executes SQL
			stmt.execute(sql);
				
			// get the resultset
			ResultSet rs = stmt.executeQuery(sql);
			
			// display package data
			if (rs.next()){
				// package name
				txtPkgName.setText(rs.getString("pkgname").toString());
				
				// Start date
				String dateValue = rs.getString("pkgstartdate").toString();
				Date startDate = new SimpleDateFormat("yyyy-MM-dd").parse(dateValue);
				dcStartDate.setDate(startDate);
				
				// End date
				dateValue = rs.getString("pkgenddate").toString(); 
				Date endtDate = new SimpleDateFormat("yyyy-MM-dd").parse(dateValue);
				dcEndDate.setDate(endtDate);
				
				// base price
				DecimalFormat df = new DecimalFormat("0.00");
				txtBasePrice.setText("$" + df.format(Double.parseDouble(rs.getString("pkgbaseprice").toString())));
				
				// agency commission
				txtAgcyCms.setText("$" + df.format(Double.parseDouble(rs.getString("pkgagencycommission").toString())));
				
				// description
				taDescription.setText(rs.getString("pkgdesc").toString());
				
			}	
				conn.close();				
				
		} catch (Exception e) {
		    //add your error handling code here
			e.printStackTrace();
		}
	
	}