copyservlet.java

来自「设备管理系统：三种管理员：普通员工、设备管理员、超级管理员。可进行设备添加删除维」· Java 代码 · 共 46 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package back;

import java.io.IOException;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class copyServlet extends HttpServlet
{


    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException
    {
        response.setContentType("text/html;charset=UTF-8");
        request.setCharacterEncoding("gb2312");
        Calendar c = Calendar.getInstance(Locale.CHINESE);
        SimpleDateFormat simpleDateTimeFormat = new SimpleDateFormat(" yyyyMMdd-HH:mm:ss ");
        String sname = simpleDateTimeFormat.format(c.getTime());
        try
        {
             Connection conn=null;
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	         conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=db_database07", "sa","1234");
	         Statement stat = conn.createStatement();
			 String sql="BACKUP DATABASE db_database07 TO disk='F:\\sqlserver_backup\\"+sname+".bak' WITH DIFFERENTIAL";
			stat.executeQuery(sql);
        } catch(Exception e)
        {
            e.printStackTrace();
        }
    }


}