init.jsp

oa 源代码

<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="com.redmoon.forum.person.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ page import="org.jdom.*"%>
<%@ page import="org.jdom.output.*"%>
<%@ page import="org.jdom.input.*"%>
<%@ page import="java.util.Iterator"%>
<%@ page import="com.redmoon.forum.*"%>
<%@ page import="com.redmoon.forum.person.*"%>
<%@ page import="com.cloudwebsoft.framework.db.*"%>
<%@ page import="cn.js.fan.util.web.*"%>
<%@ page import="java.sql.*"%>
<%
JdbcTemplate jt = new JdbcTemplate(new com.cloudwebsoft.framework.db.Connection(cn.js.fan.web.Global.defaultDB));

out.print("清除account<BR>");
String sql = "delete from account";
jt.addBatch(sql);

// address
out.print("清除Address<BR>");
sql = "delete from address";
jt.addBatch(sql);
sql = "delete from address_type";
jt.addBatch(sql);

out.print("清除assert<BR>");
sql = "delete from asset_info";
jt.addBatch(sql);
sql = "delete from asset_type_info";
jt.addBatch(sql);

out.print("清除boardroom<BR>");
sql = "delete from boardroom";
jt.addBatch(sql);
sql = "delete from boardroom_used_status";
jt.addBatch(sql);

out.print("清除book<BR>");
sql = "delete from book";
jt.addBatch(sql);
sql = "delete from book_type";
jt.addBatch(sql);

out.print("清除email<BR>");
sql = "delete from email";
jt.addBatch(sql);
sql = "delete from email_attach";
jt.addBatch(sql);
sql = "delete from email_pop3";
jt.addBatch(sql);


out.print("清除flow<BR>");
sql = "delete from flow_cms_images";
jt.addBatch(sql);
sql = "delete from flow_document_attach";
jt.addBatch(sql);
sql = "delete from flow_doc_content";
jt.addBatch(sql);
sql = "delete from flow_document";
jt.addBatch(sql);
sql = "delete from flow_monitor";
jt.addBatch(sql);
sql = "delete from flow_link";
jt.addBatch(sql);
sql = "delete from flow_action";
jt.addBatch(sql);
sql = "delete from flow";
jt.addBatch(sql);
sql = "delete from flow_predefined";
jt.addBatch(sql);
sql = "delete from flow_sequence";
jt.addBatch(sql);
sql = "delete from flow_my_action";
jt.addBatch(sql);

out.print("清除表单信息<BR>");
sql = "delete from form_table_fw";
jt.addBatch(sql);
sql = "delete from form_table_shouwen";
jt.addBatch(sql);
sql = "delete from form_table_gzjbd";
jt.addBatch(sql);
sql = "delete from form_table_dcdbd";
jt.addBatch(sql);
sql = "delete from form_table_zbdjd";
jt.addBatch(sql);
sql = "delete from form_table_hysqd";
jt.addBatch(sql);
sql = "delete from form_table_fydjd";
jt.addBatch(sql);
sql = "delete from form_table_qjsqd";
jt.addBatch(sql);
sql = "delete from form_table_jcna";
jt.addBatch(sql);
sql = "delete from form_table_qksqd";
jt.addBatch(sql);
sql = "delete from form_table_rcszjrd";
jt.addBatch(sql);
sql = "delete from form_table_lxsqb";
jt.addBatch(sql);
sql = "delete from form_table_cpxgsqs";
jt.addBatch(sql);
sql = "delete from form_table_cpznjcbg";
jt.addBatch(sql);
sql = "delete from form_table_ncd";
jt.addBatch(sql);
sql = "delete from form_table_qzkhdjd";
jt.addBatch(sql);
sql = "delete from form_table_khfkdjd";
jt.addBatch(sql);
sql = "delete from form_table_vehicle_apply";
jt.addBatch(sql);
sql = "delete from form_table_gsfw";
jt.addBatch(sql);
sql = "delete from form_table_bgypsnd";
jt.addBatch(sql);
sql = "delete from form_table_jbdjd";
jt.addBatch(sql);
sql = "delete from form_table_ccsqd";
jt.addBatch(sql);
sql = "delete from form_table_sales_linkman";
jt.addBatch(sql);
sql = "delete from form_table_sales_provider_info";
jt.addBatch(sql);
sql = "delete from form_table_sales_provider_name";
jt.addBatch(sql);
sql = "delete from form_table_sales_product_info";
jt.addBatch(sql);
sql = "delete from form_table_sales_contract";
jt.addBatch(sql);
sql = "delete from form_table_sales_customer_service";
jt.addBatch(sql);
sql = "delete from form_table_sales_product_service";
jt.addBatch(sql);
sql = "delete from form_table_sales_product_sell";
jt.addBatch(sql);
sql = "delete from form_table_sales_product_service_sell";
jt.addBatch(sql);
sql = "delete from form_table_sales_customer";
jt.addBatch(sql);

out.print("清除kaoqin<BR>");
sql = "delete from kaoqin";
jt.addBatch(sql);

out.print("清除log<BR>");
sql = "delete from log";
jt.addBatch(sql);

out.print("清除网络硬盘<BR>");
sql = "delete from netdisk_document_attach";
jt.addBatch(sql);
sql = "delete from netdisk_document";
jt.addBatch(sql);
sql = "delete from netdisk_doc_content";
jt.addBatch(sql);
sql = "delete from netdisk_dir_priv";
jt.addBatch(sql);
sql = "delete from netdisk_directory";
jt.addBatch(sql);

out.print("清除oa_message信息<BR>");
sql = "delete from oa_message_attach";
jt.addBatch(sql);
sql = "delete from oa_message";
jt.addBatch(sql);

out.print("清除office_equipment信息<BR>");
sql = "delete from office_equipment";
jt.addBatch(sql);
sql = "delete from office_equipment_op";
jt.addBatch(sql);
sql = "delete from office_equipment_type";
jt.addBatch(sql);

out.print("清除dept_user信息<BR>");
sql = "delete from dept_user";
jt.addBatch(sql);
sql = "INSERT INTO dept_user (DEPT_CODE, USER_NAME, ORDERS) VALUES ('admin','admin',0)";
jt.addBatch(sql);

out.print("清除task信息<BR>");
sql = "delete from task";
jt.addBatch(sql);
sql = "delete from task_attach";
jt.addBatch(sql);

out.print("清除user_admin_dept信息<BR>");
sql = "delete from user_admin_dept";
jt.addBatch(sql);

out.print("清除user_archive信息<BR>");
sql = "delete from user_archive";
jt.addBatch(sql);

out.print("清空用户组信息<BR>");
sql = "delete from sq_user_group";
jt.addBatch(sql);

out.print("清除权限相关信息<BR>");
sql = "delete from user_group_of_role";
jt.addBatch(sql);
sql = "delete from user_group_priv";
jt.addBatch(sql);
sql = "delete from user_of_group";
jt.addBatch(sql);
sql = "delete from user_of_role";
jt.addBatch(sql);
sql = "delete from user_priv";
jt.addBatch(sql);
sql = "delete from user_role";
jt.addBatch(sql);
sql = "delete from user_role_priv";
jt.addBatch(sql);

sql = "delete from user_setup";
jt.addBatch(sql);

sql = "delete from users";
jt.addBatch(sql);

sql = "insert into users (name,pwd,pwdRaw,realName,regDate,proxy) values ('admin', '96e79218965eb72c92a549dd5a330112','111111', 'admin', '2006-08-30', '')";
jt.addBatch(sql);

out.print("清除user_plan<BR>");
sql = "delete from user_plan";
jt.addBatch(sql);


out.print("清除vehicle<BR>");
sql = "delete from vehicle";
jt.addBatch(sql);
sql = "delete from vehicle_driver";
jt.addBatch(sql);
sql = "delete from vehicle_maintenance";
jt.addBatch(sql);
sql = "delete from vehicle_type";
jt.addBatch(sql);
sql = "delete from vehicle_use";
jt.addBatch(sql);
sql = "delete from visual_attach";
jt.addBatch(sql);

out.print("清除work_log<BR>");
sql = "delete from work_log";
jt.addBatch(sql);

out.print("清除work_plan<BR>");
sql = "delete from work_plan";
jt.addBatch(sql);
sql = "delete from work_plan_attach";
jt.addBatch(sql);
sql = "delete from work_plan_dept";
jt.addBatch(sql);