第一次springboot连接数据库，查询功能

一共需要六个文件，controller，ReadData（方法接口），ReadDataImpl（实现接口），TestTable（实体类），TestTableMybatis（规范），TestTableDao.xml（配置Mabatis），TestTableDao.java（接口）

controller：接受用户请求，例如查询中的输入参数

service（ReadDataImpl和ReadData）：负责调用数据访问，写一些功能

DAO（TestTableDao.java和TestTableDao.xml）：负责操作数据库

实体类（TestTable）：数据库的实体

@Controller
public class ReadDataController {
	
	@Autowired
	private ReadData rd;
	
	
	@RequestMapping("查询")
	@ResponseBody
    public TestTable query(String w){
		
		TestTable findUserById = rd.findUserById(w);
        return findUserById;
    }

@PostMapping("添加")
    @ResponseBody
    public int insert(@RequestParam String b,@RequestParam String c){
		String uuid = null;
		int InsertUserById = rd.InsertUserById(uuid,b,c);
        return InsertUserById;
    }

@PostMapping("更新")
    @ResponseBody
    public int update(@RequestParam String a,@RequestParam String b){
		
		int updateUserById = rd.updateUserById(a,b);
        return updateUserById;
    }

	@PostMapping("添加2")
    @ResponseBody
    public int insert2(@RequestBody TestTable tt){		
		int InsertUserById2 = rd.InsertUserById2(tt);
        return InsertUserById2;
    }
}









@Service("readData")
public class ReadDataImpl implements ReadData{
	@Autowired
	private TestTableDao testTableDao ;
	
	@Override
	public TestTable findUserById(String uuid) {	
		return testTableDao.findUserById(uuid);
	}


	@Override
	public void query() {
		
	}

	@Override
	public int InsertUserById(String uuid,String b,String c){
		// TODO Auto-generated method stub
		uuid = UUID.randomUUID().toString().replaceAll("-", "");
	
		return testTableDao.InsertUserById(uuid,b,c);
	}
	@Override
	public int updateUserById(String uu,String dd){
		// TODO Auto-generated method stub
		return testTableDao.updateUserById(uu,dd);
	}
	
	@Override
	public int InsertUserById2(TestTable tt){
		// TODO Auto-generated method stub
		String uuid1 = UUID.randomUUID().toString().replaceAll("-", "");
	    tt.setUuid(uuid1);
		return testTableDao.InsertUserById2(tt);
	}
		
}



public interface ReadData {
	void query();
	TestTable findUserById(String uuid);
	int InsertUserById(String uuid,String b,String c);
	int updateUserById(String a,String b);
	int InsertUserById2(TestTable tt);
	
}




@Repository
public interface TestTableDao {
	
	public TestTable findUserById(@Param("id") String uuid);
	
	public int InsertUserById(@Param("uuid")String a,@Param("creatorID")String b,@Param("companyName")String c);
	
	public int updateUserById(@Param("uuid")String a,@Param("companyName")String c);
	
	public int InsertUserById2(TestTable tt);

}




public class TestTable {
	
	private String creatorID;
	private String companyName ;
	private String uuid;
	public String getUuid() {
		return uuid;
	}

	public void setUuid(String uuid) {
		this.uuid = uuid;
	}
	
	public String getCreatorID() {
		return creatorID;
	}
	public void setCreatorID(String creatorID) {
		this.creatorID = creatorID;
	}
	public String getCompanyName() {
		return companyName;
	}
	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}
	
	
}




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="com.software.infrastructure.persistence.mybatis.TestTableDaoMybatis">
	<!-- 实体和表映射 -->
	<resultMap id="BaseMap" type="com.domain.model.TestTable">
		<result column="CREATOR_ID" property="creatorID" jdbcType="VARCHAR" />
		<result column="company_name" property="companyName" jdbcType="VARCHAR" />
		
	</resultMap>


	<select id="findUserById" parameterType="String" resultMap="BaseMap">
		SELECT * from t_software_dic_test where uuid=#{id}

	</select>
	<select id="findAll"  resultMap="BaseMap">
		SELECT * from t_software_dic_test

	</select>
	  <insert id="InsertUserById" >
       insert into t_software_dic_test 
       (UUID, CREATOR_ID,company_name)
        values 
        (#{uuid,jdbcType=VARCHAR},#{creatorID,jdbcType=VARCHAR},#{companyName,jdbcType=VARCHAR}
       )
    </insert>
    
     <update id="updateUserById" >
       update t_software_dic_test set company_name = #{companyName,jdbcType=VARCHAR} where uuid=#{uuid,jdbcType=VARCHAR}
    </update>
    
     <insert id="InsertUserById2" parameterType="com.software.domain.model.TestTable">
       insert into t_software_dic_test 
       (UUID, CREATOR_ID,company_name)
        values 
        ( #{uuid,jdbcType=VARCHAR},
          #{creatorID,jdbcType=VARCHAR},#{companyName,jdbcType=VARCHAR}
       )
    </insert>
</mapper>