java - 如何解决 java.lang.ClassCastException:java.lang.String 无法在 Spring 中强制转换为 java.lang.Integer
问题描述
菜单模型
@Entity
@Table(name="M_MENU", uniqueConstraints={@UniqueConstraint(columnNames={"NAME"})})
public class MenuModel {
private Integer id;
private String code;
private String name;
private String controller;
private Integer parent_id;
@Id
@Column(name="ID")
@GeneratedValue(strategy=GenerationType.TABLE, generator="M_MENU")
@TableGenerator(name="M_MENU", table="M_SEQUENCE",
pkColumnName="SEQUENCE_NAME", pkColumnValue="M_MENU_ID",
valueColumnName="SEQUENCE_VALUE", allocationSize=1, initialValue=0
)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@Column(name="CODE")
public String getCode() {
return code;
}
public void setCode(String kode) {
this.code = kode;
}
@Column(name="NAME")
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Column(name="CONTROLLER")
public String getController() {
return controller;
}
public void setController(String controller) {
this.controller = controller;
}
@Column(name="PARENT_ID")
public Integer getParent_id() {
return parent_id;
}
public void setParent_id(Integer parent_id) {
this.parent_id = parent_id;
}
}
用户访问模型
@Entity
@Table(name="M_USER_ACCESS")
public class UserAccessModel {
private Integer id;
//join table role
private Integer idRole;
private RoleModel roleModel;
//join table menu
private Integer idMenu;
private MenuModel menuModel;
@Id
@Column(name="ID")
@GeneratedValue(strategy=GenerationType.TABLE, generator="M_USER_ACCESS")
@TableGenerator(name="M_USER_ACCESS", table="M_SEQUENCE",
pkColumnName="SEQUENCE_NAME", pkColumnValue="M_USER_ACCESS_ID",
valueColumnName="SEQUENCE_VALUE", allocationSize=1, initialValue=0
)
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@Column(name="ID_ROLE")
public Integer getIdRole() {
return idRole;
}
public void setIdRole(Integer idRole) {
this.idRole = idRole;
}
@ManyToOne
@JoinColumn(name="ID_ROLE", nullable=true, updatable=false, insertable=false)
public RoleModel getRoleModel() {
return roleModel;
}
public void setRoleModel(RoleModel roleModel) {
this.roleModel = roleModel;
}
@Column(name="ID_MENU")
public Integer getIdMenu() {
return idMenu;
}
public void setIdMenu(Integer idMenu) {
this.idMenu = idMenu;
}
@ManyToOne
@JoinColumn(name="ID_MENU", nullable=true, updatable=false, insertable=false)
public MenuModel getMenuModel() {
return menuModel;
}
public void setMenuModel(MenuModel menuModel) {
this.menuModel = menuModel;
}
}
MenuDaoImpl
@Override
public List<MenuModel> searchByRole(Integer idRole) {
// TODO Auto-generated method stub
Session session = this.sessionFactory.getCurrentSession();
List<MenuModel> menuModelListRole = new ArrayList<MenuModel>();
Criteria userAccessCriteria = session.createCriteria(UserAccessModel.class,"UA");
Criteria menuCriteria = userAccessCriteria.createCriteria("menuModel","M");
userAccessCriteria.add(Restrictions.eq("idRole", ""+idRole+""));
ProjectionList properties = Projections.projectionList();
properties.add(Projections.property("M.id"));
properties.add(Projections.property("M.name"));
properties.add(Projections.property("M.code"));
properties.add(Projections.property("M.controller"));
properties.add(Projections.property("M.parent_id"));
menuCriteria.setProjection(properties);
menuModelListRole = menuCriteria.list();
return menuModelListRole;
}
我想得到以下 sql 的结果:
选择 M.ID ID, M.NAME NAME, M.CODE CODE, M.CONTROLLER CONTROLLER, M.PARENT_ID PARENT from M_MENU M join M_USER_ACCESS UA on UA.ID_MENU = M.ID where UA.ID_ROLE="+idRole+"
我searchByRole
在menuModelListRole = menuCriteria.list();
. 我该如何解决这个问题?
解决方案
这private Integer idRole;
是 Integer 类型,但您是idRole
作为 String in传递的Restrictions.eq("idRole", ""+idRole+"")
。所以你得到java.lang.String cannot be cast to java.lang.Integer in Spring
将您的限制值从 更改Restrictions.eq("idRole", ""+idRole+"")
为Restrictions.eq("idRole", idRole)
应该可以解决您的问题。
推荐阅读
- ios - 使用 CAKeyframeAnimation 和 BezierPath 对其进行动画处理时缩放视图的正确方法是什么
- javascript - 在特定条件下返回错误而不是值
- sql - 如何将数据从连接到 Google 表格的 BigQuery 表中提取到 R 中
- python - 您如何将长度较短的列表平均分配到另一个列表?
- flutter - Flutter Web 错误 - 在调度程序回调期间引发以下 UnimplementedError
- java - 十进制除法
- performance - 调整我的 Apache Storm 序列化程序以提高性能
- c# - 使用没有 Assembly.Load 或类似的 P/invoke 调用托管 C# 库
- scala - Incorrect type inference while pattern matching in Scala
- linux - makefile:“没有规则来制作目标 'arch/x86_64/Makefile'” linux 内核 2.2.0