java - 检索多选列表值以在struts中插入数据库

Question

我正在用 struts 开发一个在线图书图书馆应用程序...

我有一个用户表单，用户可以在其中输入他的详细信息，如名字、姓氏等，还会有一个书籍列表，他将在其中选择一些他想要的书籍..稍后我想插入这些详细信息分为 2 个表......即 obl_users 中的用户详细信息和用户在 users_books 中选择的书籍。

我使用下面的代码来创建列表..

<% 
if(request.getAttribute("booksNameList") != null) { 
%>
    <html:select property="displayBooks" multiple="true" size="5">
    <logic:iterate id="booksNameList" name="booksNameList" scope="request"> 
        <html:option value="${booksNameList.bookId}" ><bean:write name="booksNameList" property="longTitle" /></html:option>

    </logic:iterate>
    </html:select>

<%
}
%>

最初，当用户请求表单时，表单将预先填充数据库中所有书籍名称的列表。我不确定我编写的用于在 value 部分获取书籍 id 的代码，即 value= “${booksNameList.bookId}” ..

在我的 addUser() 中，我想像这样遍历用户选择的书籍..

for (int i = 0; i < selectedBooks.length; i++) {

                //insertBooks.setInt(1, generatedKeys.getInt(1));
                //insertBooks.setInt(2, Integer.parseInt(selected[i]));

                //insertBooks.addBatch();
            }

但是对于如何让用户选择书籍..

这是我的 user.java

public class User extends ActionForm {

    private int userId;
    private String firstName;
    private String lastName;
    private String middleName;
    private String username;
    private String password;
    private String contactNumber;
    private String membershipNumber;
    private String role;
    private String email;
    private String address;
    private String comments;
    private String dateOfBirth;
    private int oblStatus;
    private String createdDate;
    private String updatedDate;
    private String createdBy;
    private String updatedBy;
    private String displayBooks;

    public int getUserId() {
        return userId;
    }
    public void setUserId(int userId) {
        this.userId = userId;
    }
    public String getFirstName() {
        return firstName;
    }
    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }
    public String getLastName() {
        return lastName;
    }
    public void setLastName(String lastName) {
        this.lastName = lastName;
    }
    public String getMiddleName() {
        return middleName;
    }
    public void setMiddleName(String middleName) {
        this.middleName = middleName;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getContactNumber() {
        return contactNumber;
    }
    public void setContactNumber(String contactNumber) {
        this.contactNumber = contactNumber;
    }
    public String getMembershipNumber() {
        return membershipNumber;
    }
    public void setMembershipNumber(String membershipNumber) {
        this.membershipNumber = membershipNumber;
    }
    public String getRole() {
        return role;
    }
    public void setRole(String role) {
        this.role = role;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public String getComments() {
        return comments;
    }
    public void setComments(String comments) {
        this.comments = comments;
    }
    public String getDateOfBirth() {
        return dateOfBirth;
    }
    public void setDateOfBirth(String dateOfBirth) {
        this.dateOfBirth = dateOfBirth;
    }
    public int getOblStatus() {
        return oblStatus;
    }
    public void setOblStatus(int oblStatus) {
        this.oblStatus = oblStatus;
    }
    public String getCreatedDate() {
        return createdDate;
    }
    public void setCreatedDate(String createdDate) {
        this.createdDate = createdDate;
    }
    public String getUpdatedDate() {
        return updatedDate;
    }
    public void setUpdatedDate(String updatedDate) {
        this.updatedDate = updatedDate;
    }
    public String getCreatedBy() {
        return createdBy;
    }
    public void setCreatedBy(String createdBy) {
        this.createdBy = createdBy;
    }
    public String getUpdatedBy() {
        return updatedBy;
    }
    public void setUpdatedBy(String updatedBy) {
        this.updatedBy = updatedBy;
    }
    public String getDisplayBooks() {
        return displayBooks;
    }
    public void setDisplayBooks(String displayBooks) {
        this.displayBooks = displayBooks;
    }



}

书 bean 类:

private String bookId;
    private String longTitle;
    private String shortTitle;
    private String isbn;
    private String dateOfPublication;
    private String noOfPages;
    private String boundType;
    private String dvdAvailability;
    private String noOfAvailableCopies;
    private int oblStatus;
    private String createdDate;
    private String updatedDate;
    private String createdBy;
    private String updatedBy;
    private String displayAuthors;
    private int[] authorIds;

请指导我...我是 struts 的新手

Answer 1

您必须将“displayBooks”属性作为字符串数组，例如；

private String[] displayBooks;

由于您想在表单上选择多个值，Array 或 ArrayList 可能是唯一更好的选择。