我是Spring MVC的新手,正在尝试构建示例应用程序。我试图将数据保存到表名EmployeeDetails中,该表与表Users具有一对一的关系。提交表单后,我收到此错误字段'user'中对象'employeeDetails'中的字段错误:拒绝的值[Users];代码[typeMismatch.employeeDetails.user,typeMismatch.user,typeMismatch.com.sachinmukherjee.spring_hibernate.entity.Users,typeMismatch];参数[org.springframework.context.support.DefaultMessageSourceResolvable:代码[employeeDetails.user,user];参数[];默认消息[用户]];默认消息[无法将属性'user'的类型'java.lang.String'的属性值转换为必需的类型'com.sachinmukherjee.spring_hibernate.entity.Users';嵌套的异常为java.lang.IllegalStateException:无法将类型'java.lang.String'的值转换为属性'user'的必需类型'com.sachinmukherjee.spring_hibernate.entity.Users':未找到匹配的编辑器或转换策略]]
用户表结构
+--------------+--------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(20) | NO | UNI | NULL | |
| password | varchar(100) | NO | | NULL | |
| created_at | datetime | YES | | CURRENT_TIMESTAMP | |
| userfullname | varchar(50) | NO | | NULL | |
+--------------+--------------+------+-----+-------------------+----------------+
用户实体(Users.java)
@Entity
@Table(name="users")
public class Users {
@Id
@Column(name="id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@Column(name="username",unique = true)
private String username;
@Column(name="password")
private String password;
@Column(name="userfullname")
private String userfullname;
@Column(name = "created_at")
private Timestamp created_at;
@OneToOne(mappedBy = "user",
cascade = CascadeType.PERSIST
)
private EmployeeDetails employee;
public Users() {
}
public Users(String username, String password, String userfullname) {
this.username = username;
this.password = password;
this.userfullname = userfullname;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public Timestamp getCreated_at() {
return created_at;
}
public String getUserfullname() {
return userfullname;
}
public void setUserfullname(String userfullname) {
this.userfullname = userfullname;
}
public void setCreated_at(Timestamp created_at) {
this.created_at = created_at;
}
public int getId() {
return id;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public void setId(int id) {
this.id = id;
}
public EmployeeDetails getEmployee() {
return employee;
}
public void setEmployee(EmployeeDetails employee) {
this.employee = employee;
}
@Override
public String toString() {
return "Users [id=" + id + ", username=" + username + ", userfullname=" + userfullname + ", created_at="
+ created_at + "]";
}
}
EmployeeDetails表结构
+-------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+-------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| first_name | varchar(20) | NO | | NULL | |
| middle_name | varchar(20) | YES | | NULL | |
| last_name | varchar(20) | YES | | NULL | |
| mobile_no | bigint(20) | YES | | NULL | |
| email | varchar(50) | NO | | NULL | |
| created_at | datetime | YES | | CURRENT_TIMESTAMP | |
| users_id | int(11) | NO | MUL | NULL | |
+-------------+-------------+------+-----+-------------------+----------------+
EmployeeDetails实体类(EmployeeDetails.java)
@Entity
@Table(name="employee_details")
public class EmployeeDetails {
@Id
@Column(name="id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@Column(name="first_name")
private String first_name;
@Column(name="middle_name")
private String middle_name;
@Column(name="last_name")
private String last_name;
@Column(name="mobile_no")
private long mobile_no;
@Column(name="email")
private String email;
@OneToOne(fetch = FetchType.EAGER,cascade = CascadeType.PERSIST)
@JoinColumn(name = "users_id")
private Users user;
public EmployeeDetails() {
}
public EmployeeDetails(String first_name, String middle_name, String last_name, long mobile_no, String email) {
this.first_name = first_name;
this.middle_name = middle_name;
this.last_name = last_name;
this.mobile_no = mobile_no;
this.email = email;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getFirst_name() {
return first_name;
}
public void setFirst_name(String first_name) {
this.first_name = first_name;
}
public String getMiddle_name() {
return middle_name;
}
public void setMiddle_name(String middle_name) {
this.middle_name = middle_name;
}
public String getLast_name() {
return last_name;
}
public void setLast_name(String last_name) {
this.last_name = last_name;
}
public long getMobile_no() {
return mobile_no;
}
public void setMobile_no(long mobile_no) {
this.mobile_no = mobile_no;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public Users getUser() {
return user;
}
public void setUser(Users user) {
this.user = user;
}
@Override
public String toString() {
return "EmployeeDetails [id=" + id + ", first_name=" + first_name + ", middle_name=" + middle_name
+ ", last_name=" + last_name + ", mobile_no=" + mobile_no + ", email=" + email + ", user=" + user + "]";
}
}
我的EmployeeDeatails控制器(EmployeeDetailsController.java)
@Controller
@RequestMapping("/employee_details")
public class EmployeeDetailsController {
@Autowired
EmployeeDetailsDAO employeeDetailsDAO;
@Autowired
UsersDAO usersDAO;
@RequestMapping("/")
public String home(Model model) {
List<EmployeeDetails> employees = employeeDetailsDAO.getEmployees();
model.addAttribute("employees", employees);
return "employee_details/index";
}
@GetMapping("/add")
public String add(Model model) {
List<Users> users = usersDAO.getUsers();
EmployeeDetails employee = new EmployeeDetails();
model.addAttribute("userList",users);
model.addAttribute("employee", employee);
return "employee_details/add";
}
@PostMapping("/submit")
public String submit(@ModelAttribute EmployeeDetails employee) {
System.out.println(employee);
employeeDetailsDAO.saveEmployee(employee);
return "redirect:/employee_details/";
}
}
我的EmployeeDetails DAO类(EmployeeDetails DAO)
@Repository
public class EmployeeDetailsDAOImp implements EmployeeDetailsDAO {
@Autowired
SessionFactory sessionFactory;
@Transactional
public List<EmployeeDetails> getEmployees() {
Session session = sessionFactory.getCurrentSession();
Query<EmployeeDetails> query = session.createQuery("from EmployeeDetails",EmployeeDetails.class);
List<EmployeeDetails> employees = query.getResultList();
System.out.println(employees);
return employees;
}
@Transactional
public void saveEmployee(EmployeeDetails employee) {
Session session = sessionFactory.getCurrentSession();
session.saveOrUpdate(employee);
}
}
我的add.jsp页面,用于填写表单
<form action="${pageContext.request.contextPath}/employee_details/submit" method="POST" modelAttribute="employee" class="form-control">
<label>Username</label>
<select name="user" required="required">
<option>Select User</option>
<c:forEach var="user" items="${userList}">
<option value=${user}>${user.username}</option>
</c:forEach>
</select>
<br><br>
<label>First Name</label>
<input type="text" name="first_name" />
<br><br>
<label>Middle Name</label>
<input type="text" name="middle_name" />
<br><br>
<label>Last Name</label>
<input type="text" name="last_name" />
<br><br>
<label>Email</label>
<input type="text" name="email" />
<br><br>
<button type="submit" class="btn btn-success">Save</button>
</form>
我的用户
@Repository
public class UsersDAOImp implements UsersDAO {
//need to inject session factory
@Autowired
private SessionFactory sessionFactory;
@Transactional
public List<Users> getUsers() {
//get the hibernate session
Session session = sessionFactory.getCurrentSession();
//create a query
Query<Users> theQuery =
session.createQuery("from Users", Users.class);
//execute the query and get resultset
List<Users> users = theQuery.getResultList();
//return the result
return users;
}
}
我无法弄清楚为什么会出现此错误,以及应该在Submit方法的方法参数中传递什么。
最佳答案
我发现的解决方案是将HTML表单替换为Spring表单,并将select标记及其路径更改为类似的形式。
<form:label path="user.id">Username</form:label>
<form:select path="user.id" required="required">
<form:option value="${user.get(0)}">Select One</form:option>
<c:forEach var="user" items="${userList}">
<form:option value="${user.id}">${user.username}</form:option>
</c:forEach>
</form:select>