附錄A系統(tǒng)管理員模塊功能簡化圖附錄B系統(tǒng)主程序清單@Controller

@RequestMapping("/base")

@Scope("prototype")

public

class

SystemManageController

extends

BaseController

{

private

static

final

Logger

logger

=

LoggerFactory.getLogger(SystemManageController.class);

public

static

String

databasename

=

"";

public

static

String

mysqldump

=

"";

public

static

String

username="";

public

static

String

password

=

"";

public

static

String

mysqlexe="";

static{

try

{

Properties

properties

=

new

Properties();

properties.load(SystemManageController.class.getResourceAsStream("/perties"));

databasename

=

properties.getProperty("databasename");

mysqldump

=

properties.getProperty("mysqldump");

username

=

properties.getProperty("username");

password

=

properties.getProperty("password");

mysqlexe

=

properties.getProperty("mysqlexe");

}

catch

(Exception

e)

{

logger.error("讀取mysql備份還原配置失敗");

}

}

@InitBinder

public

void

initBinder(WebDataBinder

binder)

{

SimpleDateFormat

dateFormat

=

new

SimpleDateFormat("yyyy-MM-dd

HH:mm:ss");

dateFormat.setLenient(false);

binder.registerCustomEditor(Date.class,

new

CustomDateEditor(dateFormat,

true));

}

@Autowired

private

ServiceFactory

serviceFactory;

@RequestMapping("/queryUser")

@ResponseBody

public

String

queryUser(String

status,

Integer

page,

Integer

rows,

String

key)

{

return

responseSuccess(serviceFactory.getSystemManageService().queryAllUser(page,

rows,

status,

key));

}

@RequestMapping("/{operation}/modiUser")

@ResponseBody

public

String

modiUser(UserView

userView,

String

allprivileges,

@PathVariable("operation")

String

operation)

{

boolean

flag

=

false;

if

(mons.lang.StringUtils.isNotBlank(operation))

{

try

{

int[]

myprivileges

=

null;

("===========================>allprivileges："

+

allprivileges);

if

(mons.lang.StringUtils.isNotBlank(allprivileges))

{

String[]

privileges

=

allprivileges.split(",");

myprivileges

=

new

int[privileges.length];

for

(int

i

=

0;

i

<

myprivileges.length;

i++)

{

myprivileges[i]

=

StringUtils.getIntegerValue(privileges[i],

-1);

}

}

flag

=

serviceFactory.getSystemManageService().modifyUser(userView,

myprivileges,

operation);

}

catch

(Exception

e)

{

logger.error("用戶信息管理異常!");

}

}

return

responseSuccess(flag);

}

@RequestMapping("/queryAllPrivilege")

@ResponseBody

public

String

queryAllPrivilege()

{

return

responseArraySuccess(serviceFactory.getSystemManageService().queryAllPermission());

}

@RequestMapping("/queryAllSector")

@ResponseBody

public

String

queryAllSector()

{

return

responseArraySuccess(serviceFactory.getSystemManageService().queryAllSectors());

}

@RequestMapping("/queryAllUserPrivilege")

@ResponseBody

public

String

queryAllUserPrivilege(String

accountnumber)

{

return

responseArraySuccess(serviceFactory.getSystemManageService().queryAllUserPer(accountnumber));

}

@RequestMapping("/modiPass")

@ResponseBody

public

String

modiPass(String

pass,

HttpServletRequest

request)

{

boolean

flag

=

false;

String

accountnumber

=

MyWebUtils.getCurrentUser(request).getAccountnumber();

flag

=

serviceFactory.getSystemManageService().modifyPass(pass,

accountnumber);

return

responseSuccess(flag);

}

@RequestMapping("/databaseBF")

@ResponseBody

public

String

databaseBF(String

location,

HttpServletRequest

request)

{

boolean

flag

=

false;

if(mons.lang.StringUtils.isNotBlank(location)){

try

{

Runtime

rt

=

Runtime.getRuntime();

Process

child

=

rt

.exec(mysqldump+"

-h

localhost

-u"+username+"

-p"+password+"

"+databasename);

InputStream

in

=

child.getInputStream();

InputStreamReader

xx

=

new

InputStreamReader(in,

"utf-8");

String

inStr;

StringBuffer

sb

=

new

StringBuffer("");

String

outStr;

//

組合控制臺輸出信息字符串

BufferedReader

br

=

new

BufferedReader(xx);

while

((inStr

=

br.readLine())

!=

null)

{

sb.append(inStr

+

"\r\n");

}

outStr

=

sb.toString();

CreateFileUtil.createFile(location);

File

objfile

=

new

File(location);

FileOutputStream

fout

=

new

FileOutputStream(objfile);

OutputStreamWriter

writer

=

new

OutputStreamWriter(fout,

"utf-8");

writer.write(outStr);

writer.flush();

in.close();

xx.close();

br.close();

writer.close();

fout.close();

flag

=

true;

}

catch

(Exception

e)

{

("數(shù)據(jù)庫備份操作失敗!");

}

}

return

flag?responseSuccess(flag):responseFail("數(shù)據(jù)庫備份操作失敗！");

}

@RequestMapping("/databaseHY")

@ResponseBody

public

String

databaseHY(HttpServletRequest

request,@RequestParam("refreshfile")MultipartFile

multipartFile)

{

boolean

flag

=

false;

try

{

Runtime

runtime

=

Runtime.getRuntime();

Process

process

=

runtime

.exec(mysqlexe+"

-hlocalhost

-u"+username+"

-p"+password+"

--default-character-set=utf8

"+databasename);

OutputStream

outputStream

=

process.getOutputStream();

BufferedReader

br

=

new

BufferedReader(new

InputStreamReader(

multipartFile.getInputStream(),

"utf-8"));

String

str

=

null;

StringBuffer

sb

=

new

StringBuffer();