java写后台_Java后台实现方法

Java后台实现方法

首先后台结构分为四个部分(以表schedule为例)

entity>mapper>service>controller

1. 在entity里面写好实体，新建目录schedule，再建子文件Schedule.java,在里面定义好全部表名的字段

package com.eisp.eoms.entity.schedule;

import java.sql.Timestamp;

//日志信息

public class Schedule {

private Long scheId;

private String schCode;

private String userCode;

private String orgCode;

private String scheduleContent;

private Timestamp startDate;

private Timestamp endDate;

private String comments;

}

2.在mapper里面写好接口

建立schedule目录，再建立ScheduleMapper.java文件

里面写sql语句

/**

* @author Administrator

*

*/

package com.eisp.eoms.mapper.schedule;

import java.util.List;

import com.eisp.eoms.entity.schedule.Schedule;

public interface ScheduleMapper {

ListselectByUserCode(String userCode);

Listselect();

}

//select和selectByUserCode名称不能一样

再建立ScheduleMapper.xml文件，里面写sql语

select * from EOMS_SCHEDULE

resultType="com.eisp.eoms.entity.schedule.Schedule">

select * from EOMS_SCHEDULE where USERCODE=#{param1}

//id相应ScheduleMapper.java中的select方法

3.在service层建立schedule目录。再建立ScheduleService.java文件，里面写的语句例如以下

package com.eisp.eoms.service.schedule;

import java.util.List;

import com.eisp.eoms.entity.schedule.Schedule;

public interface ScheduleService {

List selectByUserCode(String userCode);

List select();

}

再建立impl文件，里面建立ScheduleServiceImpl.java文件

package com.eisp.eoms.service.schedule.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.eisp.eoms.entity.schedule.Schedule;

import com.eisp.eoms.mapper.schedule.ScheduleMapper;

import com.eisp.eoms.service.schedule.ScheduleService;

@Service

public class ScheduleServiceImpl implements ScheduleService {

@Autowired

private ScheduleMapper scheduleMapper;

public List selectByUserCode(String userCode) {

return scheduleMapper.selectByUserCode(userCode);

}

public List select() {

return scheduleMapper.select();

}

}

4.在controller新建schedule文件件。里面建业务文件SonntagController.java文件用于接收数据

package com.eisp.eoms.controller.schedule;

import java.util.HashMap;

import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.servlet.ModelAndView;

import com.eisp.eoms.service.schedule.ScheduleService;

@Controller

@RequestMapping("/schedule/sonntag")

public class SonntagController {

@Autowired

private ScheduleService scheduleService;

@RequestMapping("/showIndex")

public ModelAndView scheduleIndex() {

return new ModelAndView("schedule/index");

}

@RequestMapping("/list")

@ResponseBody

public Map listAll() {

Map data = new HashMap();

data.put("list", scheduleService.select());

data.put("AAA", scheduleService.select());

System.out.println(data);

return data;

}

}

总结，经过以上几个环节。后台数据库表的数据可以成功调取出来。当然假设要载入到页面上。还须要js中用ajax传输