package Method;
|
import java.util.Iterator;
|
import java.util.List;
|
import java.util.Vector;
|
import DataBase.DatabaseManagement;
|
|
/**±¸·Ý¹Ø¼üÊý¾Ý*/
|
public class Beifen {
|
|
static Vector<String> benfen=new Vector<String>();
|
/**»ñÈ¡±¸·ÝÊý¾ÝµÄ¼¯ºÏ*/
|
public static void Benfen() {
|
//±¸·Ý
|
tb_data("tb_tag");
|
tb_data("tb_achor");
|
tb_data("tb_anchor_nearby");
|
tb_data("tb_cenggao");
|
tb_data("tb_department");
|
tb_data("tb_fence");
|
tb_data("tb_fence_inout");
|
tb_data("tb_forward_data");
|
tb_data("tb_icon");
|
tb_data("tb_mac");
|
tb_data("tb_map");
|
tb_data("tb_person");
|
tb_data("tb_suanfa");
|
tb_data("tb_tongbuanchor");
|
tb_data("tb_user");
|
StringBuffer str=new StringBuffer();
|
for(int i=0;i<benfen.size();i++) {
|
str.append(benfen.get(i)+"\n");
|
}
|
SaveFIleInTxt.bei_fen(str.toString());
|
benfen.removeAllElements();
|
str=null;
|
}
|
|
public static void savelog() {
|
tb_data("tb_tag");
|
tb_data("tb_achor");
|
tb_data("tb_anchor_nearby");
|
tb_data("tb_cenggao");
|
tb_data("tb_department");
|
tb_data("tb_fence");
|
tb_data("tb_fence_inout");
|
tb_data("tb_forward_data");
|
tb_data("tb_map");
|
tb_data("tb_person");
|
tb_data("tb_suanfa");
|
tb_data("tb_tongbuanchor");
|
StringBuffer str=new StringBuffer();
|
for(int i=0;i<benfen.size();i++) {
|
str.append(benfen.get(i)+"\n");
|
}
|
String a="\n---------------ÒÔÏÂÊÇ"+GetNowTime.now()+"±¸·ÝÊý¾Ý---------------";
|
SaveFIleInTxt.savelog(a+"\n"+str.toString());
|
}
|
|
|
/**±¸·Ýtb_anchor*/
|
@SuppressWarnings("rawtypes")
|
public static void tb_data(String tablename) {
|
|
String sql = "select * from "+tablename;
|
Iterator iterator = DatabaseManagement.serch(sql).iterator();
|
int datalenth=DatabaseManagement.get_columname(tablename).length;
|
while (iterator.hasNext()) {// µü´úÆ÷´æÔÚÔªËØ
|
StringBuffer message=new StringBuffer();
|
List info = (List) iterator.next();// ½«µü´úÆ÷ÀïÃæµÄÔªËظøµ½info¼¯ºÏ
|
message.append(tablename+","+info.get(0)+",");
|
for(int i=1;i<datalenth;i++) {
|
if(i !=(datalenth-1)) {
|
String a=(String) info.get(i);
|
if(a==null) {
|
a="null";
|
}else if (a.length()<1 ){
|
a="null";
|
}
|
message.append(a+",");
|
}else {
|
String a=(String) info.get(i);
|
if(a==null) {
|
a="null";
|
}else if (a.length()<1 ){
|
a="null";
|
}
|
message.append(a);
|
}
|
}
|
benfen.add(message.toString());
|
message=null;
|
|
}
|
|
}
|
|
/**»Ö¸´±¸·ÝµÄÊý¾Ý*/
|
public static void huifu(String message) {
|
System.out.println(message);
|
String[] info=message.split(",");
|
String start=info[0];
|
huifu(info,start);
|
}
|
|
|
/**»Ö¸´±íÊý¾ÝµÄ·½·¨*/
|
public static void huifu(String[] info,String tablename) {
|
String[] ziduan=DatabaseManagement.get_columname(tablename);
|
int size=ziduan.length;
|
String[] zhi=new String[size];
|
for(int i=0;i<size;i++) {
|
zhi[i]=info[i+1];
|
}
|
String deleteSql="TRUNCATE TABLE "+tablename;
|
DatabaseManagement.update(deleteSql);
|
DatabaseManagement.insertfast(tablename, ziduan, zhi);
|
}
|
|
|
}
|
