src/action/DataAction.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package action;

import java.io.File;
import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import common.DataBaseUtil;

public class DataAction extends DispatchAction {
	public ActionForward doSqlServerBackUp(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
		String mssqlBackupName=
        request.getParameter("mssqlBackupName");//自定义备份数据库名
		String mssqlBackupPath=request.getParameter("mssqlBackupPath");//自定义备份数据库保存路径
		String dbName="universityPMS_db";//被备份的数据库名称
		boolean flag=false;
		try {
			File file = new File(mssqlBackupPath);
			String path = file.getPath() + "\\" + mssqlBackupName + ".bak";//备份生成的数据路径及文件名
			String bakSql = "backup database "+dbName+" to disk=? with init";//备份数据库SQL语句
			PreparedStatement bak = DataBaseUtil.getConnection()
					.prepareStatement(bakSql);
			bak.setString(1, path);//path必须是绝对路径
			bak.execute(); //备份数据库
			bak.close();
			flag=true;
		} catch (Exception e) {
			flag=false;
			e.printStackTrace();
		}
	    response.setCharacterEncoding("utf-8");
	    try {
			if(flag==true){
				response.getWriter().print("<script type=\"text/javascript\">alert('SQLSERVER备份成功！');document.location.href='/universityPMS/DataAction.do?action=toBackIndex';</script>");
			}else{
				response.getWriter().print("<script type=\"text/javascript\">alert('SQLSERVER备份失败！');document.location.href='/universityPMS/DataAction.do?action=toBackIndex';</script>");
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
		return null;
	}
	/** 
	 * @Description: SqlServer还原
	 * @author 莫希柏
	 * @date Jul 4, 2012 4:28:05 PM   
	 */
	
	public ActionForward doSqlServerRecovery(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response){ 
			boolean flag = false;