Java はフォームデータのマルチユーザー共同編集および同期機能を開発します

CREATE TABLE form_data (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    content TEXT NOT NULL
);

CREATE TABLE user_info (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);

CREATE TABLE user_role (
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_id INT NOT NULL,
    role VARCHAR(255) NOT NULL,
    FOREIGN KEY (user_id) REFERENCES user_info(id)
);

@Entity
@Table(name = "form_data")
public class FormData {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "content", columnDefinition = "TEXT", nullable = false)
    private String content;

    // 省略getter和setter方法
}

@RestController
@RequestMapping("/api/form-data")
public class FormDataController {

    @Autowired
    private FormDataRepository formDataRepository;

    @GetMapping("/{id}")
    public FormData getFormData(@PathVariable Long id) {
        return formDataRepository.findById(id)
                .orElseThrow(() -> new NotFoundException("Form data not found"));
    }

    @PostMapping
    public FormData createFormData(@RequestBody FormData formData) {
        return formDataRepository.save(formData);
    }

    @PutMapping("/{id}")
    public FormData updateFormData(@PathVariable Long id, @RequestBody FormData formData) {
        formData.setId(id);
        return formDataRepository.save(formData);
    }

    @DeleteMapping("/{id}")
    public void deleteFormData(@PathVariable Long id) {
        formDataRepository.deleteById(id);
    }
}

@Entity
@Table(name = "user_info")
public class UserInfo {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "username", nullable = false)
    private String username;

    @Column(name = "password", nullable = false)
    private String password;

    // 省略getter和setter方法
}

@Repository
public interface UserInfoRepository extends JpaRepository<UserInfo, Long> {
    Optional<UserInfo> findByUsername(String username);
}

@Service
public class UserDetailsServiceImpl implements UserDetailsService {

    @Autowired
    private UserInfoRepository userInfoRepository;

    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
        UserInfo userInfo = userInfoRepository.findByUsername(username)
                .orElseThrow(() -> new UsernameNotFoundException("User not found"));

        List<GrantedAuthority> authorities = new ArrayList<>();

        // 在这里可以根据用户角色设置不同的权限

        return new User(userInfo.getUsername(), userInfo.getPassword(), authorities);
    }
}

@Configuration
@EnableWebSocket
public class WebSocketConfig implements WebSocketConfigurer {

    @Override
    public void registerWebSocketHandlers(WebSocketHandlerRegistry registry) {
        registry.addHandler(webSocketHandler(), "/ws").setAllowedOrigins("*");
    }

    @Bean
    public WebSocketHandler webSocketHandler() {
        return new WebSocketHandler();
    }
}

@Component
public class WebSocketHandler extends TextWebSocketHandler {

    @Override
    protected void handleTextMessage(WebSocketSession session, TextMessage message) throws Exception {
        // 在这里处理接收到的消息，并将消息广播给其他用户
    }
}