java源代码实例

<%@ page language="java" import="java.util.*,com.*,org.apache.log4j.Logger" pageEncoding="UTF-8"%>
<%@page import="java.sql.*;"%>
<%
  boolean flag=true;
  Connection con=null;
  ResultSet rs=null;
  String filePath="";
  Logger logger=Logger.getLogger("doDataBak.jsp");
   
  String value = request.getParameter("bakname");
  if(value==null || value.trim().equals("")){
  //为它取个名字
  java.util.Date now = new java.util.Date();
  java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyyMMddHHmmss");
  value = formatter.format(now);
   
  }

   
try{
  con=new DateBakDao().getCon("bak");
  filePath=this.getServletConfig().getServletContext().getRealPath("/")+"admin\\bak\\"+value+".dat";
  String sql="backup database stream to disk='"+filePath+"'"+" with init"; 
  //out.print(sql);
  Statement st=con.createStatement();  
  st.execute(sql); 
   
  logger.info("成功备份数据库到"+filePath);
  st.close();
   
}catch(Exception e){
  flag=false;
  e.printStackTrace();
  logger.info("备份数据库时出现错误");
  
}finally{
  new DateBakDao().closeCon(rs,null,con);
  
}


if(flag==true && new java.io.File(filePath).isFile()){
  out.print("<script>alert('备份成功')</script>");
  out.print("数据备份在"+filePath);
}else{
  
  out.print("<script>alert('备份失败')</script>");
}
%>