backupdata.jsp

jsp-公司管理系统-注册、会员管理等功能

<%-- backupData.jsp程序代码 --%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.CallableStatement" %>
<%@ page import="java.sql.SQLException" %>
<%
//取得页面传递过来的用户资料
request.setCharacterEncoding("gb2312");
String backupMan=request.getParameter("backupMan");
String backupDate=request.getParameter("backupDate");

//建立数据库连接并执行数据插入
Connection conn=null;
CallableStatement cstmt=null;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	conn=DriverManager.getConnection("jdbc:odbc:datasource_suit","sa","710318");
	cstmt=conn.prepareCall("{call backup_userInfo(?,?)}");
	cstmt.setString(1,backupDate);
	cstmt.setString(2,backupMan);
	cstmt.executeUpdate();
	out.println("已成功备份数据库表");
}catch(Exception e){
	out.println("执行存储过程备份库表数据失败，数据已被回滚.");
}
finally{
	try{
		if(cstmt!=null){
			cstmt.close();
		}
		if(conn!=null){
			conn.close();
		}
	}catch(SQLException sqle){}
}
%>