发表于: 2020-01-09 23:54:14
1 1157
今天完成的事情:
填写接口对应的SQL语句
1. 主页面
//主页面/重置
List<onework> findAll(int pageNow,int pageSize);
<!-- 主页面-->
<select id="findAll" resultType="pojo.onework" >
select * from onework limit #{pageNow},#{pageSize}
</select>
用了limit函数
2. 根据姓名 状态搜索
//根据姓名和状态查询
List<onework> searchAll(String oneworkName, int state);
<!-- 姓名和状态-->
<select id="searchAll" resultType="pojo.onework" >
SELECT * FROM onework
<where>
<if test="onework_name ! = null and onwork_name !=''">
onework_name as oneworkName LIKE '%' #{onework_name}'%'
</if>
<if test="state! = null and state !=''">
AND state = #{state}
</if>
</where>
LIMIT 0,10</select>
用了动态sql语句 if+where
1. 当姓名not null 状态not null 同时可查询2个
2. 姓名null 状态not null 查询状态(where去掉and )
3. 姓名not null 状态 null 只查询onework
4.姓名null 状态null 跳过where语句里的内容
3. 添加
//增加姓名
int addName (onework onework);
<!-- 添加-->
<insert id="addName" parameterType="pojo.onework" >
INSERT INTO onewrok (onework_name) values (#{onework_name})
</insert>
只添加了一个name (因为id是自增 而状态state不填数据得话 默认为0 代表下架 )
4. 更改状态(上下架) 更改名字
昨天分成2个put 今天合成一个了
//更改姓名和状态boolean putTwo(onework onework);
<!--更改名字和状态-->
<update id="putTwo" parameterType="pojo.onework">
update onework
<set>
<choose>
<when test="onework_name!=null and onework_name!='' ">
onework_name =#{onework_name}
</when>
<otherwise>
state=#{state}
</otherwise>
</choose>>
where id = #{id}
</set>
</update>
这里用了 set +choose(otherwise)
choose类似 java的switch语句 不等于a 就等于b 只能选择一个
即:
name不为null 只修改name
name为null state填入参数修改
2者只存在一个
5. 删除
//删除
boolean deleteId(int id);
<delete id="deletrId" parameterType="java.lang.Integer">
DELETE FROM onework where id = #{id}
</delete>
controller层
@Controller
@RequestMapping("/onework")
public class oneworkController {
static Map<String,Object> map = new HashMap<>();
@Autowired
oneworkService one;
@ResponseBody
@RequestMapping(method = RequestMethod.GET)
public Map findAll(@RequestParam(value = "pageNow",defaultValue = "0")int pageNow,
@RequestParam(value = "pageSize",defaultValue = "10") int pageSize) {
try {
List<onework> onework = one.findAll(pageNow, pageSize);
map.put("onework", onework);
map.put("code", 200);
map.put("msg","进入主页面成功");
return map;
}catch (Exception e) {
map.put("code",201);
map.put("msg","进入主页面失败");
return map;
}
}
@ResponseBody
@RequestMapping(value = "/searchAll",method = RequestMethod.GET)
public Map secrchAll(@RequestParam(value = "onework_name")String onework_name,
@RequestParam(value = "state") int state) {
try {
List<onework> onework = one.searchAll(onework_name, state);
map.put("onework", onework);
map.put("code", 200);
map.put("msg","查询成功");
return map;
}catch (Exception e) {
map.put("code",201);
map.put("msg","查询失败");
return map;
}
}
@ResponseBody
@RequestMapping(method = RequestMethod.POST)
public Map addName(@RequestBody onework onework){
try {
one.addName(onework);
map.put("code", 200);
map.put("msg","添加成功");
return map;
}catch (Exception e) {
map.put("code",201);
map.put("msg","添加失败");
return map;
}
}
@ResponseBody
@RequestMapping(method = RequestMethod.PUT)
public Map putTwo(@RequestBody onework onework) {
try {
one.putTwo(onework);
map.put("code", 200);
map.put("msg", "更改成功");
return map;
} catch (Exception e) {
map.put("code", 201);
map.put("msg", "更改失败");
return map;
}
}
@ResponseBody
@RequestMapping(value = "/{id}", method = RequestMethod.DELETE)
public Map deleteId(int id) {
try {
one.deleteId(id);
map.put("code", 200);
map.put("msg", "删除成功");
return map;
} catch (Exception e) {
map.put("code", 201);
map.put("msg", "删除失败");
return map;
}
}
}
postman测试
哦豁 没一个对的 暂时还没修复
明天计划的事情:
解决404问题
把所有的页面代码都写完
评论