java实现sqlserver及mysql的备份与还原(经典版)

《java实现sqlserver及mysql的备份与还原(经典版)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

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{/

2、***@Description:获取数据库连接*@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=

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

4、ctionconn){if(conn!=null){try{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.Inpu

5、tStream;importjava.io.InputStreamReader;importjava.io.OutputStream;importjava.io.OutputStreamWriter;importjava.sql.CallableStatement;importjava.sql.PreparedStatement;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importorg.apache.str

6、uts.action.ActionForm;importorg.apache.struts.action.ActionForward;importorg.apache.struts.action.ActionMapping;importorg.apache.struts.actions.DispatchAction;importcom.wingo.util.DataBaseUtil;publicclassDataActionextendsDispatchAction{/***@Description:SqlServer备份*@author莫希柏

7、*@dateJul4,20122:45:16PM*/publicActionForwarddoSqlServerBackUp(ActionMappingmapping,ActionFormform,HttpServletRequestrequest,HttpServletResponseresponse)throwsException{StringmssqlBackupName=request.getParameter("mssqlBackupName");//自定义备份数据库名StringmssqlBackupPath=request.get

8、Parameter("mssqlBackupPath");//自定义备份数据库保存路径StringdbName="datatest";//被备份的数据