strus2 mysql实现增删查改功能

public class User {
    private int id;
    private String name;
    private int age;

    // 省略 getter 和 setter 方法
}

public class UserDao {
    private Connection conn;

    public UserDao(Connection conn) {
        this.conn = conn;
    }

    public void addUser(User user) throws SQLException {
        String sql = "INSERT INTO user (name, age) VALUES (?, ?)";
        try (PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setString(1, user.getName());
            ps.setInt(2, user.getAge());
            ps.executeUpdate();
        }
    }

    // 省略其他增删查改方法
}

public class UserService {
    private UserDao userDao;

    public UserService(UserDao userDao) {
        this.userDao = userDao;
    }

    public void addUser(User user) throws SQLException {
        userDao.addUser(user);
    }

    // 省略其他业务逻辑方法
}

public class UserAction extends ActionSupport {
    private User user;

    private UserService userService;

    public String addUser() throws SQLException {
        userService.addUser(user);
        return SUCCESS;
    }

    // 省略 getter 和 setter 方法
}

<struts>
    <package name="user" extends="struts-default">
        <action name="addUser" class="com.example.UserAction" method="addUser">
            <result name="success">/success.jsp</result>
        </action>
    </package>
</struts>