controller service dao mapper 他们之间的关联
时间: 2023-12-18 12:03:14 浏览: 35
Controller负责接收和处理请求,调用Service层的方法处理业务逻辑,Service层调用DAO层的方法进行数据操作,而DAO层则通过Mapper来操作数据库。因此,他们之间的关联是Controller调用Service,Service调用DAO,DAO通过Mapper操作数据库。这种关系称为MVC(Model-View-Controller)模式,它将应用程序分为三个部分:Model(数据)、View(用户界面)和Controller(控制器),以实现应用程序的分层和解耦。
相关问题
使用Java编程和springboot框架,使用Spring MVC框架,连接mysql数据库实现 1.创建活动并关联奖品,一个活动必须关联8个奖品,总概率为100% 2.修改活动 活动名称不能重复 并更新关联奖品,给出具体程序,包括给出相应的controller层,service层,service实现类,dao层及mapper.xml文件
好的,针对您的问题,我会给出一个简单的示例程序,供您参考。需要说明的是,这只是一个示例程序,实际情况中还需要根据具体业务需求进行修改和完善。
首先,我们需要创建一个活动实体类,代码如下:
```java
public class Activity {
private String id;
private String name;
private List<Prize> prizes;
// getter and setter methods
}
```
其中,id为活动id,name为活动名称,prizes为关联的奖品列表。接着,我们需要创建一个奖品实体类,代码如下:
```java
public class Prize {
private String id;
private String name;
private int probability;
// getter and setter methods
}
```
其中,id为奖品id,name为奖品名称,probability为奖品概率。
接下来,我们需要创建对应的DAO层和Mapper.xml文件,用于实现对数据库的操作。这里我们使用Mybatis框架进行操作。DAO层代码如下:
```java
@Repository
public class ActivityDao {
@Autowired
private SqlSession sqlSession;
public void createActivity(Activity activity) {
sqlSession.insert("ActivityMapper.createActivity", activity);
}
public void updateActivity(Activity activity) {
sqlSession.update("ActivityMapper.updateActivity", activity);
}
public Activity getActivityById(String id) {
return sqlSession.selectOne("ActivityMapper.getActivityById", id);
}
public Activity getActivityByName(String name) {
return sqlSession.selectOne("ActivityMapper.getActivityByName", name);
}
}
```
其中,createActivity方法用于创建活动,updateActivity方法用于更新活动信息,getActivityById方法用于根据id获取活动信息,getActivityByName方法用于根据名称获取活动信息。注意,这里使用了@Autowired注解,需要在Spring配置文件中进行配置。
接下来,我们需要创建对应的Mapper.xml文件,代码如下:
```xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="ActivityMapper">
<insert id="createActivity" parameterType="Activity">
insert into activity(id, name)
values(#{id}, #{name})
</insert>
<update id="updateActivity" parameterType="Activity">
update activity
set name = #{name}
where id = #{id}
</update>
<select id="getActivityById" parameterType="String" resultMap="activityResultMap">
select *
from activity
where id = #{id}
</select>
<select id="getActivityByName" parameterType="String" resultMap="activityResultMap">
select *
from activity
where name = #{name}
</select>
<resultMap id="activityResultMap" type="Activity">
<id column="id" property="id"/>
<result column="name" property="name"/>
</resultMap>
</mapper>
```
其中,createActivity对应创建活动操作,updateActivity对应更新活动操作,getActivityById对应根据id获取活动信息操作,getActivityByName对应根据名称获取活动信息操作。
接下来,我们需要创建对应的Service层和实现类。Service层代码如下:
```java
public interface ActivityService {
void createActivity(Activity activity);
void updateActivity(Activity activity);
Activity getActivityById(String id);
Activity getActivityByName(String name);
}
@Service
public class ActivityServiceImpl implements ActivityService {
@Autowired
private ActivityDao activityDao;
@Override
public void createActivity(Activity activity) {
// 校验活动名称是否重复
Activity oldActivity = activityDao.getActivityByName(activity.getName());
if (oldActivity != null) {
throw new RuntimeException("活动名称已存在");
}
// 校验关联奖品数量是否正确
List<Prize> prizes = activity.getPrizes();
if (prizes == null || prizes.size() != 8) {
throw new RuntimeException("奖品数量不正确");
}
// 校验奖品概率之和是否为100%
int totalProbability = 0;
for (Prize prize : prizes) {
totalProbability += prize.getProbability();
}
if (totalProbability != 100) {
throw new RuntimeException("奖品概率之和不为100%");
}
// 保存活动信息
activityDao.createActivity(activity);
}
@Override
public void updateActivity(Activity activity) {
// 校验活动名称是否重复
Activity oldActivity = activityDao.getActivityByName(activity.getName());
if (oldActivity != null && !oldActivity.getId().equals(activity.getId())) {
throw new RuntimeException("活动名称已存在");
}
// 校验关联奖品数量是否正确
List<Prize> prizes = activity.getPrizes();
if (prizes == null || prizes.size() != 8) {
throw new RuntimeException("奖品数量不正确");
}
// 校验奖品概率之和是否为100%
int totalProbability = 0;
for (Prize prize : prizes) {
totalProbability += prize.getProbability();
}
if (totalProbability != 100) {
throw new RuntimeException("奖品概率之和不为100%");
}
// 更新活动信息
activityDao.updateActivity(activity);
}
@Override
public Activity getActivityById(String id) {
return activityDao.getActivityById(id);
}
@Override
public Activity getActivityByName(String name) {
return activityDao.getActivityByName(name);
}
}
```
其中,createActivity方法用于创建活动,updateActivity方法用于更新活动信息,getActivityById方法用于根据id获取活动信息,getActivityByName方法用于根据名称获取活动信息。注意,这里使用了@Autowired注解,需要在Spring配置文件中进行配置。
最后,我们需要创建对应的Controller层,代码如下:
```java
@RestController
@RequestMapping("/activity")
public class ActivityController {
@Autowired
private ActivityService activityService;
@PostMapping("/create")
public void createActivity(@RequestBody Activity activity) {
activityService.createActivity(activity);
}
@PostMapping("/update")
public void updateActivity(@RequestBody Activity activity) {
activityService.updateActivity(activity);
}
@GetMapping("/{id}")
public Activity getActivityById(@PathVariable String id) {
return activityService.getActivityById(id);
}
@GetMapping("/name/{name}")
public Activity getActivityByName(@PathVariable String name) {
return activityService.getActivityByName(name);
}
}
```
其中,createActivity对应创建活动操作,updateActivity对应更新活动操作,getActivityById对应根据id获取活动信息操作,getActivityByName对应根据名称获取活动信息操作。
至此,我们完成了使用Java编程和SpringBoot框架,使用SpringMVC框架,连接MySQL数据库实现创建活动并关联奖品,一个活动必须关联8个奖品,总概率为100%以及修改活动操作的示例程序。
使用Java编程和springboot框架实现创建活动并关联奖品,一个活动必须关联8个奖品,总概率为100% 给出相应的controller层,service层,service实现类,daoc层及mapper,
好的,以下是相应的代码实现:
1. Controller层
```java
@RestController
@RequestMapping("/activity")
public class ActivityController {
@Autowired
private ActivityService activityService;
@PostMapping("/create")
public ResponseEntity<Activity> createActivity(@RequestBody ActivityDTO activityDTO) {
Activity activity = activityService.createActivity(activityDTO);
return ResponseEntity.ok(activity);
}
}
```
2. Service层
```java
public interface ActivityService {
Activity createActivity(ActivityDTO activityDTO);
}
```
3. Service实现类
```java
@Service
public class ActivityServiceImpl implements ActivityService {
@Autowired
private ActivityMapper activityMapper;
@Override
public Activity createActivity(ActivityDTO activityDTO) {
// 验证奖品概率总和是否为100%
if (activityDTO.getPrizes().stream().mapToDouble(PrizeDTO::getProbability).sum() != 1.0) {
throw new IllegalArgumentException("奖品概率总和不为100%");
}
// 创建活动
Activity activity = new Activity();
activity.setName(activityDTO.getName());
activity.setStartTime(activityDTO.getStartTime());
activity.setEndTime(activityDTO.getEndTime());
// 创建奖品并关联活动
List<Prize> prizes = activityDTO.getPrizes().stream().map(prizeDTO -> {
Prize prize = new Prize();
prize.setName(prizeDTO.getName());
prize.setProbability(prizeDTO.getProbability());
prize.setActivity(activity);
return prize;
}).collect(Collectors.toList());
activity.setPrizes(prizes);
activityMapper.insert(activity);
return activity;
}
}
```
4. DAO层及Mapper
ActivityMapper.java
```java
@Mapper
public interface ActivityMapper {
void insert(Activity activity);
}
```
Activity.java
```java
public class Activity {
private Long id;
private String name;
private LocalDateTime startTime;
private LocalDateTime endTime;
private List<Prize> prizes;
// 省略getter和setter方法
}
```
Prize.java
```java
public class Prize {
private Long id;
private String name;
private double probability;
private Activity activity;
// 省略getter和setter方法
}
```
以上就是使用Java编程和Spring Boot框架实现创建活动并关联奖品的代码实现,希望能够对您有所帮助。