这个Model
package cn.com.cisec.hnjt.model;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import org.codehaus.jackson.annotate.JsonIgnoreProperties;
@Entity
public class WorkOrderAll {
private int id;
private Warning waring;
private String time;
private int count;
@Id
@GeneratedValue
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
@OneToOne(fetch=FetchType.EAGER)
public Warning getWaring() {
return waring;
}
public void setWaring(Warning waring) {
this.waring = waring;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
}
-----------------------------------------------------
这个是Dao
package cn.com.cisec.hnjt.dao;
import java.util.List;
import cn.com.cisec.hnjt.model.WorkOrderAll;
public interface WorkOrderAllDao {
List<WorkOrderAll> getWorkOrderAll();
}
--------------------------------------------
这个事实DaoImpl
package cn.com.cisec.hnjt.dao.impl;
import java.util.List;
import javax.annotation.Resource;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.stereotype.Repository;
import cn.com.cisec.hnjt.dao.WorkOrderAllDao;
import cn.com.cisec.hnjt.model.WorkOrderAll;
@Repository
public class WorkOrderAllDaoImpl implements WorkOrderAllDao {
private SessionFactory sessionFactory;
private Session session;
public SessionFactory getSessionFactory() {
return sessionFactory;
}
@Resource
public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}
@Override
public List<WorkOrderAll> getWorkOrderAll() {
session=sessionFactory.openSession();
List<WorkOrderAll> workOrderAll=session.createQuery("from WorkOrderAll").list();
return workOrderAll;
}
}
------------------------------------------------------
这个是WorkOrderAllService
package cn.com.cisec.hnjt.service;
import java.util.List;
import cn.com.cisec.hnjt.model.TrafficLight;
import cn.com.cisec.hnjt.model.WorkOrderAll;
public interface WorkOrderAllService {
List<WorkOrderAll> getWorkOrderAll();
}
-------------------------------------------------------------------
这个是WorkOrderAllServiceImpl
package cn.com.cisec.hnjt.service.impl;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import cn.com.cisec.hnjt.dao.WorkOrderAllDao;
import cn.com.cisec.hnjt.model.WorkOrderAll;
import cn.com.cisec.hnjt.service.WorkOrderAllService;
@Service
public class WorkOrderAllServiceImpl implements WorkOrderAllService {
private WorkOrderAllDao workOrderAllDao;
public WorkOrderAllDao getWorkOrderAllDao() {
return workOrderAllDao;
}
@Resource
public void setWorkOrderAllDao(WorkOrderAllDao workOrderAllDao) {
this.workOrderAllDao = workOrderAllDao;
}
public List<WorkOrderAll> getWorkOrderAll(){
return workOrderAllDao.getWorkOrderAll();
}
}
-------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------
最后这个是拿数据的WorkOrderAllController
-------------------------------------------------------------------------------------------------------------------------------------
package cn.com.cisec.hnjt.control;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import cn.com.cisec.hnjt.model.Manager;
import cn.com.cisec.hnjt.model.TrafficLight;
import cn.com.cisec.hnjt.model.WorkOrderAll;
import cn.com.cisec.hnjt.service.WorkOrderAllService;
@Controller
@RequestMapping("/gdxq")
public class WorkOrderAllController {
private WorkOrderAllService workOrderAllService;
public WorkOrderAllService getWorkOrderAllService() {
return workOrderAllService;
}
@Resource(name="workOrderAllServiceImpl")
public void setWorkOrderAllService(WorkOrderAllService workOrderAllService) {
this.workOrderAllService = workOrderAllService;
}
@ResponseBody
@RequestMapping("/getworkOrderAll")
public Map<String,Object> getWorkOrderAll(){
Map<String, Object> map = new HashMap<String, Object>();
List<WorkOrderAll> list = workOrderAllService.getWorkOrderAll();
List<TempWorkOrderAll> tempList = new ArrayList<TempWorkOrderAll>();
Iterator i=list.iterator();
while(i.hasNext()){
WorkOrderAll workOrderAll=(WorkOrderAll) i.next();
TempWorkOrderAll temp = new TempWorkOrderAll();
temp.setId(workOrderAll.getId());
temp.setCount(workOrderAll.getCount());
temp.setTime(workOrderAll.getTime());
TrafficLight t=workOrderAll.getWaring().getTrafficLight();
String address=t.getAddress();
int number =t.getSerialNumber();
temp.setAddress(address) ;
temp.setNumber(number);
String name="";
Iterator il= t.getManager().iterator();
while(il.hasNext()){
Manager manager=(Manager) il.next();
name=name+manager.getName()+",";
}
temp.setName(name);
tempList.add(temp);
}
//把 id,number,name,count,time,address封装到list里
map.put("workOrderAll",tempList);
return map;
}
public String export(){
return "success";
}
}
//临时建一个对象,然后把取出来的数据封装到对象里,然后再是新建一个数组,把对象封装到数组里,最后把数组封装到map里就是Json格式的文本了。
class TempWorkOrderAll{
int id;
int count;
String time;
String address;
int number;
String name;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public int getNumber() {
return number;
}
public void setNumber(int number) {
this.number = number;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
public String getTime() {
return time;
}
public void setTime(String time) {
this.time = time;
}
}