📄 datadictionarymanager.java
字号:
package com.example.gw.datadictionary;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import com.example.businessmodel.Page;
import com.example.gw.system.user.UserInfo;
public class DataDictionaryManager implements IDataDictionaryManager {
private IDataDictionaryDao dataDictionaryDao;
public void setDataDictionaryDao(IDataDictionaryDao dataDictionaryDao) {
this.dataDictionaryDao = dataDictionaryDao;
}
public IDataDictionaryDao getDataDictionaryDao() {
return dataDictionaryDao;
}
/**
* 查询字典具体内容列表
*/
public Page findDictionary(HttpServletRequest request, int start,
int page_size) throws Exception {
String sql = "";
UserInfo user = (UserInfo) request.getSession()
.getAttribute("userinfo");
if (user.getUnit().getUnitId() != null
&& !"".equals(user.getUnit().getUnitId() + "")
&& request.getParameter("codeId") != null
&& !"".equals(request.getParameter("codeId"))) {
sql = " from DataDictionary where fatherId = '"
+ request.getParameter("codeId") + "' and unitId = '"
+ user.getUnit().getUnitId() + "' order by id desc";
}
return dataDictionaryDao.loadPage(sql, start, page_size);
}
/**
* 查询具体字典信息(分页专用)
* @param where sql查询条件
* @param startNum 开始纪录数
* @param recordNum 每页显示纪录数
* @return
* @throws Exception
*/
public String findDataListXml(String where,int startNum,int recordNum)throws Exception{
List propertiesList = new ArrayList();
propertiesList.add("id");
propertiesList.add("content");
propertiesList.add("unitId");
return dataDictionaryDao.loadPageXml(where,startNum,recordNum,propertiesList);
}
/**
* 查询字典信息(普通分页)
* @param request
* @param hsql where sql 查询条件
* @param pageSize 每页显示记录数
* @param startNum 开始记录数
* @throws Exception
*/
public void findDataListPage(HttpServletRequest request,String hsql,int pageSize,int startNum)throws Exception{
}
/**
* 字典具体内容存入数据库
*/
public void saveDictionary(DataDictionary dataDictionary) {
dataDictionaryDao.save(dataDictionary);
}
/**
* 字典内容修改存入数据库
*/
public void updateDictionary(DataDictionary dataDictionary) {
dataDictionaryDao.update(dataDictionary);
}
/**
* 查找字典具体内容
*/
public DataDictionary findObj(String id) {
DataDictionary form = (DataDictionary) dataDictionaryDao.findById(
DataDictionary.class, new Integer(id));
return form;
}
/**
* 删除具体字典内容
*/
public void deleteDictionary(DataDictionary dataDictionary) {
dataDictionaryDao.delete(dataDictionary);
}
/**
* 获得具体字典内容列表 返回具体字典集合
*/
public List getDataDictionaryList(String sortvalue, String unitid,
String state) {
String sql = "from DataDictionary where unitId="
+ unitid
+ " and dataDictionaryDescription in (select id from DataDictionaryDescription where state='"
+ state + "' and id=" + sortvalue + ")";
List list = dataDictionaryDao.find(sql);
return list;
}
public List findDataDictionaryList(String unitId,String fatherid){
String where = " from DataDictionary where unitId="+unitId+" and fatherId="+fatherid;
List list = dataDictionaryDao.find(where);
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -