关于org.mybatis.spring.MyBatisSystemException:Parameter ‘userId’ not found. 错误调试详解编程语言


关于org.mybatis.spring.MyBatisSystemException:Parameter 'userId' not found. 错误调试详解编程语言 

我一个项目用到了ssm框架。然后数据库生成字段之后,写好实体类



private static final long serialVersionUID = 1826023156097338963L; 
	private String userId; //用户ID 
	private String id;	//帖子ID 
	private String ggTitle; // 公告标题 
	private String ggBody; //公告内容 
	private String ggIconCls; // 公告样式 
	private String createTime; //创建时间 
	private String corpName; //部门名称 
	private String state; //状态 
	private String remark; // 审核备注 
	private String typeId; //类型ID 
	private String Pthird; //扩展备用 
	public Announcement() { 
	} 
	public Announcement(String userId, String id, String ggTitle, 
			String ggBody, String ggIconCls, String createTime, 
			String corpName, String state, String remark, String typeId, 
			String pthird) { 
		super(); 
		this.userId = userId; 
		this.id = id; 
		this.ggTitle = ggTitle; 
		this.ggBody = ggBody; 
		this.ggIconCls = ggIconCls; 
		this.createTime = createTime; 
		this.corpName = corpName; 
		this.state = state; 
		this.remark = remark; 
		this.typeId = typeId; 
		Pthird = pthird; 
	} 
	public String getUserId() { 
		return userId; 
	} 
	public void setUserId(String userId) { 
		this.userId = userId; 
	} 
	public String getId() { 
		return id; 
	} 
	public void setId(String id) { 
		this.id = id; 
	} 
	public String getGgTitle() { 
		return ggTitle; 
	} 
	public void setGgTitle(String ggTitle) { 
		this.ggTitle = ggTitle; 
	} 
	public String getGgBody() { 
		return ggBody; 
	} 
	public void setGgBody(String ggBody) { 
		this.ggBody = ggBody; 
	} 
	public String getGgIconCls() { 
		return ggIconCls; 
	} 
	public void setGgIconCls(String ggIconCls) { 
		this.ggIconCls = ggIconCls; 
	} 
	public String getCreateTime() { 
		return createTime; 
	} 
	public void setCreateTime(String createTime) { 
		this.createTime = createTime; 
	} 
	public String getCorpName() { 
		return corpName; 
	} 
	public void setCorpName(String corpName) { 
		this.corpName = corpName; 
	} 
	public String getState() { 
		return state; 
	} 
	public void setState(String state) { 
		this.state = state; 
	} 
	public String getRemark() { 
		return remark; 
	} 
	public void setRemark(String remark) { 
		this.remark = remark; 
	} 
	public String getTypeId() { 
		return typeId; 
	} 
	public void setTypeId(String typeId) { 
		this.typeId = typeId; 
	} 
	public String getPthird() { 
		return Pthird; 
	} 
	public void setPthird(String pthird) { 
		Pthird = pthird; 
	} 
	@Override 
	public String toString() { 
		return "Announcement [userId=" + userId + ", id=" + id + ", ggTitle=" 
				+ ggTitle + ", ggBody=" + ggBody + ", ggIconCls=" + ggIconCls 
				+ ", createTime=" + createTime + ", corpName=" + corpName 
				+ ", state=" + state + ", remark=" + remark + ", typeId=" 
				+ typeId + ", Pthird=" + Pthird + "]"; 
	} 
	@Override 
	public int hashCode() { 
		final int prime = 31; 
		int result = 1; 
		result = prime * result + ((id == null) ? 0 : id.hashCode()); 
		return result; 
	} 
	@Override 
	public boolean equals(Object obj) { 
		if (this == obj) 
			return true; 
		if (obj == null) 
			return false; 
		if (getClass() != obj.getClass()) 
			return false; 
		Announcement other = (Announcement) obj; 
		if (id == null) { 
			if (other.id != null) 
				return false; 
		} else if (!id.equals(other.id)) 
			return false; 
		return true; 
	} 
	

写好mapper 文件映射,写好

<mapper namespace="com.tgb.mapper.information.AnnouncementMapper"> 
	 
	 <!-- mybsits_config中配置的alias类别名,也可直接配置resultType为类路径 -->   
	<insert id="saveTitle" parameterType="Announcement"> 
		insert into SYS_Information(UserID,ID,Title,CreateTime)values(#{userId},#{id},#{ggTitle},#{createTime}); 
	 
	</insert> 
</mapper>

做类型测试一直报错

@RunWith(SpringJUnit4ClassRunner.class) 
@ContextConfiguration("/config/spring-common.xml") 
public class InformationTest { 
	@Autowired 
	private AnnouncementMapper announcementMapper; 
	@Test 
	public void testSave(){ 
		announcementMapper.saveTitle(CommonUtil.getUUID(),CommonUtil.getUUID(),"今晚打老虎","2016-12-14"); 
	} 
}

 之后钻研书籍,[email protected]

void saveTitle(@Param("userId")String userId,@Param("id")String id,@Param("ggTitle")String ggTitle,@Param("createTime")String createTime);

加入之后错误消失,以此作为笔记。


原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/industrynews/13158.html

(0)
上一篇 2021年7月19日 15:29
下一篇 2021年7月19日 15:29

相关推荐

发表回复

登录后才能评论