DelLibraryFile.java

/**
 * Tencent is pleased to support the open source community by making MSEC available.
 *
 * Copyright (C) 2016 THL A29 Limited, a Tencent company. All rights reserved.
 *
 * Licensed under the GNU General Public 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
 *
 *     https://opensource.org/licenses/GPL-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.
 */


package beans.service;

import beans.dbaccess.IDL;
import beans.dbaccess.LibraryFile;
import beans.dbaccess.SharedobjectTag;
import beans.response.DelIDLTagResponse;
import beans.response.DelLibraryFileResponse;
import ngse.org.DBUtil;
import ngse.org.JsonRPCHandler;
import org.apache.log4j.Logger;

import java.io.File;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by Administrator on 2016/1/31.
 *  * 删除标准服务的库文件版本
 */
public class DelLibraryFile extends JsonRPCHandler {
    static private void RemoveFile(String filename) {
        File file = new File(filename);
        file.delete();


    }
    public DelLibraryFileResponse exec(LibraryFile request)
    {
        Logger logger = Logger.getLogger(this.getClass().getName());
        DelLibraryFileResponse response = new DelLibraryFileResponse();
        response.setMessage("unkown error.");
        response.setStatus(100);
        String result = checkIdentity();
        if (!result.equals("success"))
        {
            response.setStatus(99);
            response.setMessage(result);
            return response;
        }
        if (request.getFile_name()== null ||
                request.getFile_name().equals("") ||
                request.getSecond_level_service_name() == null||
                request.getSecond_level_service_name().equals("")||
                request.getFirst_level_service_name() == null ||
                request.getFirst_level_service_name().equals(""))
        {
            response.setMessage("file name and service name  should NOT be empty.");
            response.setStatus(100);
            return response;
        }
        DBUtil util = new DBUtil();
        if (util.getConnection() == null)
        {
            response.setMessage("DB connect failed.");
            response.setStatus(100);
            return response;
        }
        String sql = "delete from t_library_file where file_name=? and first_level_service_name=? and second_level_service_name=?";
        List<Object> params = new ArrayList<Object>();
        params.add(request.getFile_name());
        params.add(request.getFirst_level_service_name());
        params.add(request.getSecond_level_service_name());
        try {
            int delNum = util.updateByPreparedStatement(sql, params);
            String filename = LibraryFile.getLibraryFileName(request.getFirst_level_service_name(), request.getSecond_level_service_name(), request.getFile_name());

            logger.error("delte file:"+filename);
            RemoveFile(filename);
            if (delNum > 0)
            {
                response.setMessage("success");
                response.setDelNumber(delNum);
                response.setStatus(0);
                return response;
            }
            else {
                response.setMessage("delete record number is "+delNum);
                response.setDelNumber(delNum);
                response.setStatus(100);
                return response;
            }
        }
        catch (SQLException e)
        {
            response.setMessage("Delete record failed:"+e.toString());
            response.setStatus(100);
            e.printStackTrace();
            return response;
        }
        finally {
            util.releaseConn();
        }
    }
    public static String deleteAll(String flsn, String slsn)
    {
        DBUtil util = new DBUtil();
        if (util.getConnection() == null)
        {
            return "DB connect failed.";
        }

        try {
            String sql = "select file_name from t_library_file where  first_level_service_name=? and second_level_service_name=?";
            List<Object> params = new ArrayList<Object>();

            params.add(flsn);
            params.add(slsn);

            ArrayList<LibraryFile> result = util.findMoreRefResult(sql, params, LibraryFile.class);

            for (int i = 0; i < result.size() ; i++) {
                String file_name = result.get(i).getFile_name();
                sql = "delete from t_library_file where file_name=? and first_level_service_name=? and second_level_service_name=?";
                params = new ArrayList<Object>();
                params.add(file_name);
                params.add(flsn);
                params.add(slsn);

                //删除数据库记录
                int delNum = util.updateByPreparedStatement(sql, params);

                String filename = LibraryFile.getLibraryFileName(flsn, slsn, file_name);

                RemoveFile(filename);
            }
            return "success";


        } catch (Exception e) {

            e.printStackTrace();
            return e.getMessage();
        } finally {
            util.releaseConn();
        }


    }
}