package web;

/*
 * Copyright 2004 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 *     http://www.apache.org/licenses/LICENSE-2.0
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * $Header:$
 */

import java.rmi.RemoteException;
import java.sql.SQLException;
import org.apache.beehive.controls.api.bean.Control;

import org.apache.beehive.sample.*;


import javax.jws.Oneway;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;

/* 
 * Sample for WSM/controls integration.
 */
@WebService( targetNamespace="http://beehive.apache.org/EmployeeDB")
public class Service {

   @Control 
    public EmployeeDBControl employeeDB;



   	@WebMethod
   	public void createTable() throws RemoteException,SQLException {
   		employeeDB.createTable();
    }

    @WebMethod
    public void dropTable() throws RemoteException,SQLException {
    	employeeDB.dropTable();
    }
    
    
    @WebMethod
    public void insertEmployee(WSEmployee e) throws RemoteException, SQLException {
        employeeDB.insertEmployee(e);
    }

    @WebMethod
    public WSEmployee selectEmployee(int p_id) throws RemoteException, SQLException {
        return employeeDB.selectEmployee(p_id);
    }

    @WebMethod
    public WSEmployee[] selectEmployees() throws RemoteException, SQLException {
        return employeeDB.selectEmployees();
    }

    @WebMethod
    public void changeTitle(int p_id, String p_title) throws RemoteException, SQLException {
        employeeDB.changeTitle(p_id, p_title);
    }

    @WebMethod
    public void deleteEmployee(int p_id) throws RemoteException, SQLException {
        employeeDB.deleteEmployee(p_id);

    }


}