java与数据库的简单用法（html.01）

服务类

  @Service
  public class LianXi2Service extends UIHibernateService<LianXi2>{
@Autowired
private LianXi2Dao y_LianXi2Dao;
//查看
public EasyuiPage<LianXi2> findPage(EasyuiPage<LianXi2> page,String param)
throws IllegalAccessException,IllegalArgumentException,InvocationTargetException{
    Criteria criteria=y_HibernateDao.createCriteria();
    String[] fetchs=new String[]{"emp","projectInfo","emp.empSex"}; 
    fetchs=HibernateUtile.setCriteriaFetchs(criteria, LianXi2.class,fetchs);
    criteria.add(HibernateUtile.setCriteriaParam(param,LianXi2.class,fetchs));
    criteria.add(Restrictions.eq("isDelete",false));
    page=y_HibernateDao.findEasyuiPageByCriteria(page, criteria,fetchs);
    return page;
}
//修改，添加
public LianXi2 merge(LianXi2 lianXi2,String chechDateStr,String moveDateStr,String empId) throws ParseException{
    if (StringUtils.isNotBlank(chechDateStr)) {
        Date chechDate=DateUtile.simpleStrToDate(chechDateStr);
        lianXi2.setCheckDate(chechDate);
    }
    if (StringUtils.isNotBlank(moveDateStr)) {
        Date moveDate=DateUtile.simpleStrToDate(moveDateStr);
        lianXi2.setMoveDate(moveDate);
    }
    if (StringUtils.isNotBlank(empId)) {
        lianXi2.setEmpId(empId);
    }
    LianXi2 room=y_HibernateDao.get(lianXi2.getId());
    if (StringUtils.isNotBlank(lianXi2.getId())) {
        BeanUtils.copyProperties(lianXi2, room);
        y_LianXi2Dao.merge(room);
    }else {
        y_LianXi2Dao.merge(lianXi2);
    }
    return lianXi2;
}
//删除
public void deleteById(String[]ids){
    for(String id:ids){
        LianXi2 room=y_HibernateDao.get(id);
        room.setIsDelete(true);
        y_HibernateDao.merge(room);
    }
}           
}

实体类（注意要GET和SET一下，alt+shift+s）

    @Entity
   @Table(name="HR_ROOM")
    public class LianXi2 extends BaseObj implements Serializable{

/**
 * 
 */
private static final long serialVersionUID = -2750457017948952615L;

@Id
@GenericGenerator(name="generator",strategy="uuid2")
@GeneratedValue(generator="generator")
@Column(name="ROOM_ID")
private String id;

@Column(name="EMP_ID")
private String EmpId;

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="EMP_ID",insertable=false,updatable=false)
private HrEmpinfo emp ;


@Column(name="PROJECT_ID")
private String ProjectId;


@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="PROJECT_ID",insertable=false,updatable=false)
private PmProjectInfo projectInfo;


@Column(name="CHECK_DATE")
private Date CheckDate;

@Column(name="WEEK_DATE")
private String WeekDate;

@Column(name="MOVE_DATE")
private Date MoveDate;

@Column(name="ROOM_ADDRESS")
private String address;

@Column(name="ROOM_COUNT")
private String roomCount;

Web

    @Controller
    @RequestMapping("/web/hr/lianXi2")
    public class LianXi2Web {
@Autowired
private LianXi2Service y_LianXi2Service;

@RequestMapping(value = "/NewLianXi2.do", method = RequestMethod.GET)
public void operationSelf(Model model) {
    HrEmpinfo emp = UserContext.curUser().getEmp();
    String empName=emp.getEmpName();
    String empSex=emp.getEmpSex().getName();
    String empNation=emp.getNation().getName();
    String empId=emp.getEmpId();
    model.addAttribute("empName", empName);
    model.addAttribute("empSex", empSex);
    model.addAttribute("empNation", empNation);
    model.addAttribute("empId", empId);
            }

// 分页查询页面所有的数据
@ResponseBody
@RequestMapping(value = "/findpage.do", method = RequestMethod.POST)
private Map<String, Object> findPage(EasyuiPage<LianXi2> page, String param)
        throws IllegalAccessException, IllegalArgumentException, InvocationTargetException {
    page = y_LianXi2Service.findPage(page, param);
    Map<String, Object> map = page.getMap();
    return map;
}
//添加和修改
@ResponseBody
@RequestMapping(value="/merge.do",method=RequestMethod.POST)
private Map<String, Object> merge(LianXi2 lianXi2,String chechDateStr,String moveDateStr) 
        throws ParseException, IllegalAccessException, IllegalArgumentException, InvocationTargetException{
    String empId=UserContext.curUser().getEmpId();
    LianXi2 merge=y_LianXi2Service.merge(lianXi2,chechDateStr,moveDateStr,empId);
    return BeanUtile.beanToMap(merge);
}
//删除
@ResponseBody
@RequestMapping(value="/remove.do",method=RequestMethod.POST)
public void deleteById(String id ){
    String[] ids=StringUtils.split(id,',');
    //y_attPlanService.deleteById(ids);
    for (int i = 0; i < ids.length; i++) {
        LianXi2 hrRoom = y_LianXi2Service.get(ids[i]);
        hrRoom.setIsDelete(true);
        y_LianXi2Service.merge(hrRoom);
    }
}
 }

Dao类

     @Repository
  public class LianXi2Dao extends UIHibernateDao<LianXi2> {
  }