/**
* 通过JDBC访问数据库列表页面跳转
*
* @return
*/
@RequestMapping(params = "addorupdate")
public ModelAndView addorupdate(SbJdbcEntity sbJdbc, HttpServletRequest req) {
if (StringUtil.isNotEmpty(sbJdbc.getId())) {
sbJdbc = sbJdbcService.getEntity(SbJdbcEntity.class, sbJdbc.getId());
req.setAttribute("sbJdbcPage", sbJdbc);
}
List<Department> departList = systemService.getList(Department.class);
req.setAttribute("departList", departList);
return new ModelAndView("sb/demo/notag/sbEasyUI");
}
/**
* 添加通过JDBC访问数据库
*
* @param ids
* @return
*/
@RequestMapping(params = "save")
@ResponseBody
public AjaxJson save(SbJdbcEntity sbJdbc, HttpServletRequest request) {
AjaxJson j = new AjaxJson();
if (StringUtil.isNotEmpty(sbJdbc.getId())) {
message = "更新成功";
SbJdbcEntity t = sbJdbcService.get(SbJdbcEntity.class, sbJdbc.getId());
try {
MyBeanUtils.copyBeanNotNull2Bean(sbJdbc, t);
sbJdbcService.saveOrUpdate(t);
systemService.addLog(message, Globals.Log_Type_UPDATE, Globals.Log_Leavel_INFO);
} catch (Exception e) {
e.printStackTrace();
}
} else {
message = "添加成功";
sbJdbcService.save(sbJdbc);
systemService.addLog(message, Globals.Log_Type_INSERT, Globals.Log_Leavel_INFO);
}
return j;
}
/**
* 删除通过JDBC访问数据库
*
* @return
*/
@RequestMapping(params = "del")
@ResponseBody
public AjaxJson del(SbJdbcEntity sbJdbc, HttpServletRequest request) {
AjaxJson j = new AjaxJson();
String sql = "delete from sb_demo where id='" + sbJdbc.getId() + "'";
sbJdbcService.executeSql(sql);
message = "删除成功";
systemService.addLog(message, Globals.Log_Type_DEL, Globals.Log_Leavel_INFO);
j.setMessage(message);
return j;
}