java查询和添加客户信息_4.从零点五开始的Java之路(增删改查-客户)

经过1-3的学习，话不多说了，上代码。

1.先是ConsumerService接口类。

public interface ConsumerService {

int addConsumer(Consumer consumer);

List queryAllConsumer(Consumer consumer);

int updateConsumer(Consumer consumer);

int delConsumer(Consumer consumer);

}

2.ConsumerMapper接口类。

@Mapper

@Repository

public interface ConsumerMapper {

int addConsumer(Consumer consumer);

List queryAllConsumer(Consumer consumer);

int updateConsumer(Consumer consumer);

int delConsumer(Consumer consumer);

}

一定要注意@Mapper和@Repository注释。

3.ConsumerServiceImpl类实现方法。

@Service

public class ConsumerServiceImpl implements ConsumerService {

@Autowired

ConsumerMapper consumerMapper;

@Override

public int addConsumer(Consumer consumer) {

int result = consumerMapper.addConsumer(consumer);

return result;

}

@Override

public List queryAllConsumer(Consumer consumer) {

List consumers = consumerMapper.queryAllConsumer(consumer);

return consumers;

}

@Override

public int updateConsumer(Consumer consumer) {

int result = consumerMapper.updateConsumer(consumer);

return result;

}

@Override

public int delConsumer(Consumer consumer) {

int result = consumerMapper.delConsumer(consumer);

return result;

}

}

4.ConsumerMapper.xml数据库操作

user_id, consumer_name,consumer_mobile,consumer_address, consumer_remark

user_id,consumer_id, consumer_name, consumer_mobile,consumer_address,consumer_remark,consumer_status

insert into consumer ()

values (#{user_id},#{consumer_name},#{consumer_mobile},#{consumer_address},#{consumer_remark})

select * from consumer

consumer_status = 0

and user_id = #{user_id}

and consumer_name like concat('%',#{consumer_name},'%')

and consumer_mobile like concat('%',#{consumer_mobile},'%')

and consumer_address like concat('%',#{consumer_address},'%')

and consumer_remark like concat('%',#{consumer_remark},'%')

update consumer

consumer_name = #{consumer_name,jdbcType=VARCHAR},

consumer_mobile = #{consumer_mobile,jdbcType=VARCHAR},

consumer_address = #{consumer_address,jdbcType=VARCHAR},

consumer_remark = #{consumer_remark,jdbcType=VARCHAR},

where consumer_id = #{consumer_id} and user_id = #{user_id}

update consumer

set

consumer_status = 1

where consumer_id = #{consumer_id} and user_id = #{user_id}

一定要注意parameterType中Consumer的包路径，还有resultMap中的字段前后要一致。睁大你的卡姿兰大眼睛。

5.ConsumerController接口命名操作类。

@RestController

@RequestMapping("/consumer")

public class ConsumerController {

@Autowired

ConsumerService service;

//添加客户

@RequestMapping(value = "/addConsumer", method = RequestMethod.POST)

public Response addConsumer(@RequestBody Consumer consumer) {

//判断传来的信息是否为空

if (consumer == null) {

return new Response<>(500, "客户信息不能为空！");

}

int result = service.addConsumer(consumer);

if (result > 0) {

return new Response<>(200, "添加成功！");

}

return new Response<>(500, "添加失败！");

}

//查询客户列表

@RequestMapping(value = "/getConsumerList", method = RequestMethod.POST)

public Response getConsumerList(@RequestBody Consumer consumer) {

//判断传来的信息是否为空

if (consumer == null) {

return new Response<>(500, "查询信息不能为空！");

}

List consumers = service.queryAllConsumer(consumer);

if (consumers != null) {

return new Response<>(200, "获取成功！", consumers);

}

return new Response<>(500, "获取失败！");

}

//修改客户信息

@RequestMapping(value = "/updateConsumer", method = RequestMethod.POST)

public Response updateConsumer(@RequestBody Consumer consumer) {

//判断传来的信息是否为空

if (consumer == null) {

return new Response<>(500, "修改信息不能为空！");

}

int result = service.updateConsumer(consumer);

if (result > 0) {

return new Response<>(200, "修改成功！");

}

return new Response<>(500, "修改失败！");

}

//删除客户

@RequestMapping(value = "/delConsumer", method = RequestMethod.POST)

public Response delConsumer(@RequestBody Consumer consumer) {

//判断传来的信息是否为空

if (consumer == null) {

return new Response<>(500, "客户信息不能为空！");

}

int result = service.delConsumer(consumer);

if (result > 0) {

return new Response<>(200, "删除成功！");

}

return new Response<>(500, "删除失败！");

}

}

写到这里一个简单的项目算是基本OK了。大家可以根据自己的需求再多加练习。

有什么问题欢迎指出，毕竟我也才开始学习java，大家一起学习一起进步。