Java实现SqlServer及MySql的备份与还原(经典版).doc

《Java实现SqlServer及MySql的备份与还原(经典版).doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Java实现Sqlserver及MySql的备份与还原注：本人是采用Struts1做的一个简单小例子。实现步骤：1.数据库基类packagecom.wingo.util;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;/***@ClassName:DataBaseUtil*@Description:TODO*@author莫希柏*@dateJul4,20122:21:41PM*/publicclassDataBaseUtil{/***@Descr

2、iption:获取数据库连接*@author莫希柏*@dateJul4,20122:23:11PM*/publicstaticConnectiongetConnection(){Connectionconn=null;try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");Stringurl="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=datatest";Stringusername="sa";Stringpasswor

3、d="sa";conn=DriverManager.getConnection(url,username,password);}catch(ClassNotFoundExceptione){e.printStackTrace();}catch(SQLExceptione){e.printStackTrace();}returnconn;}/***@Description:关闭*@author莫希柏*@dateJul4,20122:22:57PM*/publicstaticvoidcloseConn(Connectionconn){if(conn!=null){t

4、ry{conn.close();}catch(SQLExceptione){e.printStackTrace();}}}}1.action类packagecom.wingo.action;importjava.io.BufferedReader;importjava.io.File;importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.io.InputStreamRea

5、der;importjava.io.OutputStream;importjava.io.OutputStreamWriter;importjava.sql.CallableStatement;importjava.sql.PreparedStatement;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.struts.action.ActionForm;importorg.apache.struts

6、.action.ActionForward;importorg.apache.struts.action.ActionMapping;importorg.apache.struts.actions.DispatchAction;importcom.wingo.util.DataBaseUtil;publicclassDataActionextendsDispatchAction{/***@Description:SqlServer备份*@author莫希柏*@dateJul4,20122:45:16PM*/publicActionForwarddoSqlServ

7、erBackUp(ActionMappingmapping,ActionFormform,HttpServletRequestrequest,HttpServletResponseresponse)throwsException{StringmssqlBackupName=request.getParameter("mssqlBackupName");//自定义备份数据库名StringmssqlBackupPath=request.getParameter("mssqlBackupPath");//自定义备份数据库保存路径StringdbName="datate

8、st";//被备份的数据