package?com.finance.controller;

import?java.io.BufferedReader;
import?java.io.File;
import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.IOException;
import?java.io.InputStream;
import?java.io.InputStreamReader;
import?java.io.OutputStream;
import?java.io.OutputStreamWriter;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;
import?java.util.Properties;

import?javax.annotation.Resource;
import?javax.servlet.http.HttpServletResponse;
import?javax.servlet.http.HttpSession;

import?org.springframework.stereotype.Controller;
import?org.springframework.web.bind.annotation.RequestMapping;
import?org.springframework.web.bind.annotation.RequestParam;

import?com.finance.core.des.DESUtils;
import?com.finance.entity.Database;
import?com.finance.entity.PageBean;
import?com.finance.service.DatabaseService;
import?com.finance.util.CurrentConn;
import?com.finance.util.DateUtil;
import?com.finance.util.ResponseUtil;
import?com.finance.util.StringUtil;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

/**
?*?數據庫管理的Controller層
?*?@author?趙鵬（zhaopeng）
?*
?*/
@Controller
public?class?DatabaseController?{
	@Resource
	private?DatabaseService?databaseService;
	
	private?static?String?username;
	private?static?String?password;

	static{
		Properties?prop?=?new?Properties（）;
		try?{
			InputStream?is?=?CurrentConn.class.getResourceAsStream（“/db.properties“）;
			prop.load（is）;
			username?=?DESUtils.getDecryptString（prop.getProperty（“username“））;
			password?=?DESUtils.getDecryptString（prop.getProperty（“password“））;
			is.close（）;
		}?catch?（Exception?ex）?{
			ex.printStackTrace（）;
		}
	}
	
	/**
	?*?數據庫備份管理頁面
	?*/
	@RequestMapping（“/databackManage.do“）
	public?String?databackManage（）?{
		return?“databackManage“;
	}
	
	/**
	?*?數據庫恢復管理頁面
	?*/
	@RequestMapping（“/datarecoverManage.do“）
	public?String?datarecoverManage（）?{
		return?“datarecoverManage“;
	}
	
	/**
	?*?數據庫整理管理頁面
	?*/
	@RequestMapping（“/dataorderManage.do“）
	public?String?dataorderManage（）?{
		return?“dataorderManage“;
	}
	
	/**
	?*?數據庫初始化管理頁面
	?*/
	@RequestMapping（“/datainitManage.do“）
	public?String?datainitManage（）?{
		return?“datainitManage“;
	}
	
	/**
	?*?添加數據庫操作記錄
	?*?
	?*?@return
	?*?@throws?Exception
	?*/
	private?Boolean?save（Database?database）?throws?Exception?{
		int?resultTotal?=?0;
		resultTotal?=?databaseService.addDatabase（database）;
		boolean?result?=?false;
		if?（resultTotal?>?0）?{?//?執行成功
			result?=?true;
		}
		return?result;
	}

	/**
	?*?刪除數據庫操作記錄
	?*?@param?ids
	?*?@param?response
	?*?@return
	?*?@throws?Exception
	?*/
	@RequestMapping（“/databasedelete.do“）
	public?String?delete（@RequestParam（value?=?“ids“）?String?ids?HttpServletResponse?response）?throws?Exception?{
		JSONobject?result?=?new?JSONobject（）;
		String[]?idsStr?=?ids.split（““）;
		for（String?idStr?:?idsStr）?{
			databaseService.deleteDatabase（Intege

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-18?11:20??ffms\
?????目錄???????????0??2017-07-18?10:21??ffms\.settings\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\00\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\01\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\02\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\03\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\04\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\05\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\06\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\07\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\08\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\09\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\0a\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\0b\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\0c\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\0d\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\0e\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\0f\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\10\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\11\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\12\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\13\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\14\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\15\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\16\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\17\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\18\
?????目錄???????????0??2017-07-18?11:22??ffms\.svn\pristine\19\
?????目錄???????????0??2017-07-18?11:23??ffms\.svn\pristine\1a\
............此處省略3194個文件信息