API前置系统开发流程：5.通过mybatis实现数据库读写

上一篇，我已经完成了数据路的搭建和链接，这一篇来实现数据库操作

一、创建mapper interface（包名全部以carDebit开头，除非把Application.java文件从com.carDebit目录扔到根目录去）

package com.carDebit.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.carDebit.model.Person;
//Mapper注解必须写，否则运行中调用时会找不到mapper或者报错
@Mapper
public interface PersonSql {
	
	public  int insertPerson(Person insertDB);
	
	public Person queryPerson(Person queryDB);
	
	public List<Person> queryPersonAll();

}

二、编写person.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.carDebit.mapper.PersonSql">
	<resultMap type="com.carDebit.model.Person" id="person">
		<result column="NAME" jdbcType="VARCHAR" property="name"/>
		<result column="AGE" jdbcType="VARCHAR" property="age"/>
		<result column="SEX" jdbcType="VARCHAR" property="sex"/>
	</resultMap>
	<resultMap type="com.carDebit.model.ListPerson" id="Listperson">
		<collection property="personInfo"  ofType="com.carDebit.model.Person">
			<result column="NAME" jdbcType="VARCHAR" property="name"/>
			<result column="AGE" jdbcType="VARCHAR" property="age"/>
			<result column="SEX" jdbcType="VARCHAR" property="sex"/>
	    </collection>
	</resultMap>
	<select id="queryPerson" parameterType="com.carDebit.model.Person" resultMap="person">
		select * from userInfo where NAME = #{name}
	</select>
	<select id="queryPersonAll" resultMap="Listperson">
		select * from userInfo
	</select>
	<insert id="insertPerson" parameterType="com.carDebit.model.Person">
		insert into userInfo (NAME,AGE,SEX)
		values(
			#{name,jdbcType=VARCHAR},
			#{age,jdbcType=VARCHAR},
			#{sex,jdbcType=VARCHAR}
		)
	</insert>
</mapper>

三、调用mapper完成数据库操作
先写一个service interface

package com.carDebit.service;

import com.carDebit.model.ListPerson;
import com.carDebit.model.Person;

public interface PersonService {
	
	public int insertPerson(Person insertDB);
	
	public Person queryPerson(Person queryDB);
	
	public ListPerson queryPersonAll();
}

再建一个实现类，在实现类中调用mapper的方法完成数据库操作

package com.carDebit.serviceImpl;

import java.util.List;

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

import com.carDebit.mapper.PersonSql;
import com.carDebit.model.ListPerson;
import com.carDebit.model.Person;
import com.carDebit.service.PersonService;

@Service("PersonService")
public class PersonServiceImpl implements PersonService {
	@Autowired
	private PersonSql personSql;
	@Override
	public int insertPerson(Person insertDB) {
		// TODO Auto-generated method stub
		int resp = 0;
		resp = personSql.insertPerson(insertDB);
		return resp;
	}
	
	@Override
	public Person queryPerson(Person queryDB) {
		// TODO Auto-generated method stub
		Person person = new Person();
		person = personSql.queryPerson(queryDB);
		return person;
	}

	@Override
	public ListPerson queryPersonAll() {
		// TODO Auto-generated method stub
		ListPerson listPerson = new ListPerson();
		List<Person>  listperson = personSql.queryPersonAll();
		listPerson.setPersonInfo(listperson);
		return listPerson;
	}
}

最后在controller那边去调用它（我把最开始的testContoller修改了以下，方便调用）

package com.carDebit.controller;

import java.io.BufferedInputStream;
import java.lang.reflect.Field;
import java.lang.reflect.Modifier;

import javax.servlet.http.HttpServletRequest;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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 com.carDebit.model.ListPerson;
import com.carDebit.model.Person;
import com.carDebit.model.Req;
import com.carDebit.service.PersonService;

import net.sf.json.JSONObject;

@Controller
@RequestMapping("/testApp")
public class testController {
	private static Logger logger = LoggerFactory.getLogger(testController.class);
	@Autowired
	private PersonService personService;
	@RequestMapping("/test")
	@ResponseBody
	public String testApp() {
		logger.info("hello");
		return "hello word";
	}
	@RequestMapping(value="/server",produces= {"application/json;charset=UTF-8"})
	@ResponseBody
	public String server(HttpServletRequest req) {
		
		StringBuffer str = new StringBuffer();
		
		try {
			BufferedInputStream in = new BufferedInputStream(req.getInputStream());
			int i;
			char c;
			while((i=in.read()) != -1) {
				c = (char)i;
				str.append(c);
			}
		} catch (Exception ex) {
			// TODO: handle exception
			ex.printStackTrace();
		}
		JSONObject obj = JSONObject.fromObject(str.toString());
		Req request = new Req();
		request = dealJson(obj,request);
//		logger.info(person.getName());
		Object router = router(request);
		JSONObject resp = JSONObject.fromObject(router);
		String respJson = resp.toString();
		return respJson;
	}
	
	public <T> T dealJson(JSONObject obj,T temp){		
		Field[] fields = temp.getClass().getDeclaredFields();
		for(Field field:fields) {
			int mod = field.getModifiers();
			if(Modifier.isStatic(mod) || Modifier.isFinal(mod)) {
				continue;
			}
			field.setAccessible(true);
			try {
				field.set(temp,obj.get(field.getName()));
			} catch (IllegalArgumentException | IllegalAccessException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return temp;		
	}
	
	public Object router(Req req) {
		
		String transType = req.getReqType();
		Object resp;
		Person person = new Person();
		
		switch (transType) {
		case "I":
			person = dealJson(req.getPerson(),person);
			resp = personService.insertPerson(person);
			break;
		case "Q":
			person = dealJson(req.getPerson(),person);
			resp = personService.queryPerson(person);
			break;
		case "A":
			resp = personService.queryPersonAll();
			break;
		default:
			resp = "invalid request";
			//这里是随便写的，这样是没办法正常返回的
			break;
		}
		return resp;
	}
}

最后通过postman调用，查看结果

request

response

追加，mybatis的用法有几种，我用的是xml文件的形式，还可以用用mybatis结合tk.mybatis,通过封装的方法直接完成数据库操作，看自己怎么选择。

resultMap的用法，参考了以下两篇博客，受益匪浅

https://www.cnblogs.com/kenhome/p/7764398.html

https://www.cnblogs.com/liuchuanfeng/p/7002031.html