java: DDD using oracle 21c

项目结构：

domain:

/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 17:51* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : domain.entities/School.java* explain   : 学习  类**/package domain.entities;
import java.util.Objects;/****/
public class School {private String schoolId;private String schoolName;private String schoolTelNo;public School(String schoolId, String schoolName, String schoolTelNo) {this.schoolId = schoolId;this.schoolName = schoolName;this.schoolTelNo = schoolTelNo;}// Getters and Setterspublic String getSchoolId() { return schoolId; }public String getSchoolName() { return schoolName; }public String getSchoolTelNo() { return schoolTelNo; }public void setSchoolName(String schoolName) { this.schoolName = schoolName; }public void setSchoolTelNo(String schoolTelNo) { this.schoolTelNo = schoolTelNo; }// 领域行为public void updateContactInfo(String newName, String newTelNo) {if (newName != null && !newName.isEmpty()) {this.schoolName = newName;}if (newTelNo != null && !newTelNo.isEmpty()) {this.schoolTelNo = newTelNo;}}@Overridepublic boolean equals(Object o) {if (this == o) return true;if (o == null || getClass() != o.getClass()) return false;School school = (School) o;return schoolId.equals(school.schoolId);}@Overridepublic int hashCode() {return Objects.hash(schoolId);}
}/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:47* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : domain.entities/QueryParams.java* explain   : 学习  类**/package domain.entities;/****/
public class QueryParams {private String searchTerm;  // 搜索关键词private int pageNumber;     // 当前页码private int pageSize;       // 每页大小/**** @param searchTerm* @param pageNumber* @param pageSize*/public QueryParams(String searchTerm, int pageNumber, int pageSize) {this.searchTerm = searchTerm;this.pageNumber = pageNumber;this.pageSize = pageSize;}// Getterspublic String getSearchTerm() { return searchTerm; }public int getPageNumber() { return pageNumber; }public int getPageSize() { return pageSize; }public int getOffset() { return (pageNumber - 1) * pageSize; }
}/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 17:53* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : domain/repositories/SchoolRepository.java* explain   : 学习  类**/package domain.repositories;import domain.entities.School;
import domain.entities.QueryParams;import java.util.List;/****/
public interface SchoolRepository {List<School> findAll(int page, int pageSize);// 新增支持查询条件的方法List<School> findByParams(QueryParams params);int countByParams(QueryParams params);int countAll();School findById(String schoolId);void save(School school);void delete(String schoolId);}

infrastructure:

/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:03* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : SchoolRepositoryImpl.java* explain   : 学习  类**/package infrastructure.repositories;import domain.entities.School;
import domain.entities.QueryParams;
import domain.repositories.SchoolRepository;
import infrastructure.database.DuOracleHelper;import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;public class SchoolRepositoryImpl implements SchoolRepository {@Overridepublic List<School> findAll(int page, int pageSize) {System.out.println("开始分页查询，页码: " + page + "，每页大小: " + pageSize);List<School> schools = new ArrayList<>();String sql = "SELECT * FROM School ORDER BY SchoolId " +"OFFSET ? ROWS FETCH NEXT ? ROWS ONLY";try (Connection conn = DuOracleHelper.getConnection()) {System.out.println("成功获取数据库连接");try (PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setInt(1, (page - 1) * pageSize);pstmt.setInt(2, pageSize);System.out.println("执行SQL: " + sql);System.out.println("参数1: " + (page - 1) * pageSize);System.out.println("参数2: " + pageSize);try (ResultSet rs = pstmt.executeQuery()) {while (rs.next()) {schools.add(mapToDomain(rs));}System.out.println("查询成功，返回 " + schools.size() + " 条记录");}}} catch (SQLException | IOException e) {System.err.println("数据库操作异常: " + e.getMessage());e.printStackTrace(); // 打印完整堆栈信息throw new RuntimeException("查询学校列表失败", e);}return schools;}@Overridepublic int countAll() {String sql = "SELECT COUNT(*) FROM School";try (Connection conn = DuOracleHelper.getConnection();Statement stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql)) {if (rs.next()) {return rs.getInt(1);}} catch (SQLException | IOException e) {throw new RuntimeException("统计学校数量失败", e);}return 0;}@Overridepublic List<School> findByParams(QueryParams params) {List<School> schools = new ArrayList<>();StringBuilder sql = new StringBuilder("SELECT * FROM School WHERE 1=1 ");// 构建查询条件if (params.getSearchTerm() != null && !params.getSearchTerm().isEmpty()) {sql.append("AND (SchoolId LIKE ? OR SchoolName LIKE ?) ");}// 添加排序和分页sql.append("ORDER BY SchoolId OFFSET ? ROWS FETCH NEXT ? ROWS ONLY");try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql.toString())) {int paramIndex = 1;// 设置查询参数if (params.getSearchTerm() != null && !params.getSearchTerm().isEmpty()) {String searchTerm = "%" + params.getSearchTerm() + "%";pstmt.setString(paramIndex++, searchTerm);pstmt.setString(paramIndex++, searchTerm);}// 设置分页参数pstmt.setInt(paramIndex++, params.getOffset());pstmt.setInt(paramIndex, params.getPageSize());try (ResultSet rs = pstmt.executeQuery()) {while (rs.next()) {schools.add(mapToDomain(rs));}}} catch (SQLException | IOException e) {throw new RuntimeException("按条件查询学校失败", e);}return schools;}@Overridepublic int countByParams(QueryParams params) {StringBuilder sql = new StringBuilder("SELECT COUNT(*) FROM School WHERE 1=1 ");// 构建查询条件if (params.getSearchTerm() != null && !params.getSearchTerm().isEmpty()) {sql.append("AND (SchoolId LIKE ? OR SchoolName LIKE ?)");}try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql.toString())) {int paramIndex = 1;// 设置查询参数if (params.getSearchTerm() != null && !params.getSearchTerm().isEmpty()) {String searchTerm = "%" + params.getSearchTerm() + "%";pstmt.setString(paramIndex++, searchTerm);pstmt.setString(paramIndex, searchTerm);}try (ResultSet rs = pstmt.executeQuery()) {if (rs.next()) {return rs.getInt(1);}}} catch (SQLException | IOException e) {throw new RuntimeException("统计符合条件的学校数量失败", e);}return 0;}// 其他方法实现...@Overridepublic School findById(String schoolId) {String sql = "SELECT * FROM School WHERE SchoolId = ?";try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, schoolId);try (ResultSet rs = pstmt.executeQuery()) {if (rs.next()) {return mapToDomain(rs);}}} catch (SQLException | IOException e) {throw new RuntimeException("查找学校失败", e);}return null;}@Overridepublic void save(School school) {// 检查是插入还是更新if (findById(school.getSchoolId()) == null) {insertSchool(school);} else {updateSchool(school);}}private void insertSchool(School school) {String sql = "INSERT INTO School (SchoolId, SchoolName, SchoolTelNo) VALUES (?, ?, ?)";try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, school.getSchoolId());pstmt.setString(2, school.getSchoolName());pstmt.setString(3, school.getSchoolTelNo());pstmt.executeUpdate();} catch (SQLException | IOException e) {throw new RuntimeException("添加学校失败", e);}}private void updateSchool(School school) {String sql = "UPDATE School SET SchoolName = ?, SchoolTelNo = ? WHERE SchoolId = ?";try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, school.getSchoolName());pstmt.setString(2, school.getSchoolTelNo());pstmt.setString(3, school.getSchoolId());pstmt.executeUpdate();} catch (SQLException | IOException e) {throw new RuntimeException("更新学校失败", e);}}@Overridepublic void delete(String schoolId) {String sql = "DELETE FROM School WHERE SchoolId = ?";try (Connection conn = DuOracleHelper.getConnection();PreparedStatement pstmt = conn.prepareStatement(sql)) {pstmt.setString(1, schoolId);pstmt.executeUpdate();} catch (SQLException | IOException e) {throw new RuntimeException("删除学校失败", e);}}private School mapToDomain(ResultSet rs) throws SQLException {return new School(rs.getString("SchoolId"),rs.getString("SchoolName"),rs.getString("SchoolTelNo"));}
}/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:02* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : SchoolDto.java* explain   : 学习  类**/package infrastructure.model;/****/
public class SchoolDto {private String schoolId;private String schoolName;private String schoolTelNo;// Getters and Setterspublic String getSchoolId() { return schoolId; }public void setSchoolId(String schoolId) { this.schoolId = schoolId; }public String getSchoolName() { return schoolName; }public void setSchoolName(String schoolName) { this.schoolName = schoolName; }public String getSchoolTelNo() { return schoolTelNo; }public void setSchoolTelNo(String schoolTelNo) { this.schoolTelNo = schoolTelNo; }
}

application:

/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:08* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : application/server/SchoolService.java* explain   : 学习  类**/package application.server;import domain.entities.QueryParams;
import domain.entities.School;
import domain.repositories.SchoolRepository;
import infrastructure.repositories.SchoolRepositoryImpl;
import java.util.List;public class SchoolService {private final SchoolRepository repository;public SchoolService() {this.repository = new SchoolRepositoryImpl();}// 分页查询public PagedResult<School> getSchoolsByPage(int page, int pageSize) {List<School> schools = repository.findAll(page, pageSize);int totalCount = repository.countAll();return new PagedResult<>(schools,page,pageSize,(int) Math.ceil((double) totalCount / pageSize),totalCount);}/*** 新增支持搜索的分页查询方法* @param searchTerm* @param page* @param pageSize* @return*/public PagedResult<School> getSchoolsByPageAndSearch(String searchTerm, int page, int pageSize) {QueryParams params = new QueryParams(searchTerm, page, pageSize);List<School> schools = repository.findByParams(params);int totalCount = repository.countByParams(params);return new PagedResult<>(schools,page,pageSize,(int) Math.ceil((double) totalCount / pageSize),totalCount);}// 其他业务方法...public void saveSchool(School school) {if (school.getSchoolId() == null || school.getSchoolId().isEmpty()) {// 生成新ID的逻辑String newId = generateSchoolId();school = new School(newId, school.getSchoolName(), school.getSchoolTelNo());}repository.save(school);}public void updateSchool(School school) {repository.save(school); // 假设save方法可以处理更新}public void deleteSchool(String schoolId) {repository.delete(schoolId);}public int getTotalSchoolCount() {return repository.countAll();}// 生成学校ID的辅助方法private String generateSchoolId() {// 简单实现，实际应用中可能需要更复杂的ID生成策略return "S" + System.currentTimeMillis();}public int getTotalSchoolCount(String searchTerm) {QueryParams params = new QueryParams(searchTerm, 1, 10);return repository.countByParams(params);}// 分页结果类public static class PagedResult<T> {private final List<T> items;private final int currentPage;private final int pageSize;private final int totalPages;private final int totalItems;public PagedResult(List<T> items, int currentPage, int pageSize, int totalPages, int totalItems) {this.items = items;this.currentPage = currentPage;this.pageSize = pageSize;this.totalPages = totalPages;this.totalItems = totalItems;}// Getterspublic List<T> getItems() { return items; }public int getCurrentPage() { return currentPage; }public int getPageSize() { return pageSize; }public int getTotalPages() { return totalPages; }public int getTotalItems() { return totalItems; }public boolean hasNextPage() { return currentPage < totalPages; }public boolean hasPreviousPage() { return currentPage > 1; }}
}

presentation:

/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:10* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : SchoolController.java* explain   : 学习  类**/package presentation.controllers;import application.server.SchoolService;
import application.server.SchoolService.PagedResult;
import domain.entities.School;
import presentation.views.SchoolView;public class SchoolController {private final SchoolService service;private final SchoolView view;/**** @param view*/public SchoolController(SchoolView view) {this.service = new SchoolService();this.view = view;}/**** @param searchTerm* @param page* @param pageSize*/public void loadSchools(String searchTerm, int page, int pageSize) {PagedResult<School> result = service.getSchoolsByPageAndSearch(searchTerm, page, pageSize);view.displaySchools(result);}/**** @param school*/public void addSchool(School school) {service.saveSchool(school);// 重新加载数据，保持当前搜索条件和分页loadSchools(view.getCurrentSearchTerm(), 1, view.getPageSize());}/**** @param school*/public void updateSchool(School school) {service.updateSchool(school);// 重新加载当前页loadSchools(view.getCurrentSearchTerm(), view.getCurrentPage(), view.getPageSize());}/**** @param schoolId*/public void deleteSchool(String schoolId) {// 获取当前分页信息String searchTerm = view.getCurrentSearchTerm();int currentPage = view.getCurrentPage();int pageSize = view.getPageSize();// 执行删除service.deleteSchool(schoolId);// 获取删除后的总记录数int totalRecords = service.getTotalSchoolCount(searchTerm);// 计算删除后应该显示的页码int totalPages = Math.max(1, (int) Math.ceil((double) totalRecords / pageSize));int newPage = Math.min(currentPage, totalPages);// 加载正确的页loadSchools(searchTerm, newPage, pageSize);}/*public void deleteSchool(String schoolId) {// 获取当前分页信息String searchTerm = view.getCurrentSearchTerm();int currentPage = view.getCurrentPage();int pageSize = view.getPageSize();// 执行删除service.deleteSchool(schoolId);// 获取删除后的总记录数int totalRecords = service.getTotalSchoolCount(searchTerm);// 计算删除后应该显示的页码int totalPages = Math.max(1, (int) Math.ceil((double) totalRecords / pageSize));int newPage = Math.min(currentPage, totalPages);// 加载正确的页loadSchools(searchTerm, newPage, pageSize);}*/}/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 18:12* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : SchoolView.java* explain   : 学习  类**/package presentation.views;import application.server.SchoolService.PagedResult;
import domain.entities.School;
import presentation.controllers.SchoolController;
import javax.swing.*;
import javax.swing.table.AbstractTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;
import javax.swing.GroupLayout.Alignment;
import javax.swing.LayoutStyle.ComponentPlacement;public class SchoolView extends JFrame {private final SchoolController controller;private JTable schoolTable;private SchoolTableModel tableModel;private JButton firstPageBtn, prevPageBtn, nextPageBtn, lastPageBtn;private JButton addButton,editButton,deleteButton,refreshButton;private JLabel pageInfoLabel;private int currentPage = 1;private int pageSize = 10;private String currentSearchTerm = null;  // 新增：当前搜索关键词private JTextField searchField;           // 新增：搜索输入框public SchoolView() {this.controller = new SchoolController(this);initComponents();loadInitialData();// 添加按钮事件addButton.addActionListener(e -> showAddSchoolDialog());editButton.addActionListener(e -> showEditSchoolDialog());deleteButton.addActionListener(e -> performDeleteSchool());}private void initComponents() {setTitle("学校管理系统");setSize(800, 600);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);// 创建工具栏和按钮JToolBar toolBar = new JToolBar();refreshButton = new JButton("刷新");addButton = new JButton("添加");editButton = new JButton("编辑");deleteButton = new JButton("删除");toolBar.add(refreshButton);toolBar.add(addButton);toolBar.add(editButton);toolBar.add(deleteButton);// 创建搜索面板JPanel searchPanel = new JPanel(new FlowLayout(FlowLayout.LEFT));JLabel searchLabel = new JLabel("搜索:");searchField = new JTextField(20);JButton searchButton = new JButton("搜索");searchButton.addActionListener(e -> performSearch());searchPanel.add(searchLabel);searchPanel.add(searchField);searchPanel.add(searchButton);// 初始化表格tableModel = new SchoolTableModel();schoolTable = new JTable(tableModel);JScrollPane scrollPane = new JScrollPane(schoolTable);// 添加按钮事件refreshButton.addActionListener(e -> loadInitialData());addButton.addActionListener(e -> showAddSchoolDialog());editButton.addActionListener(e -> showEditSchoolDialog());deleteButton.addActionListener(e -> performDeleteSchool());// 初始化分页控件initPaginationControls();// 布局setLayout(new BorderLayout());add(toolBar, BorderLayout.NORTH);add(searchPanel, BorderLayout.SOUTH);add(scrollPane, BorderLayout.CENTER);add(createPaginationPanel(), BorderLayout.SOUTH);}/*** 添加*/private void showAddSchoolDialog() {JDialog dialog = new JDialog(this, "添加学校", true);dialog.setSize(400, 300);dialog.setLocationRelativeTo(this);// 创建表单组件JLabel idLabel = new JLabel("学校ID:");JTextField idField = new JTextField(20);JLabel nameLabel = new JLabel("学校名称:");JTextField nameField = new JTextField(20);JLabel telLabel = new JLabel("联系电话:");JTextField telField = new JTextField(20);JButton saveButton = new JButton("保存");JButton cancelButton = new JButton("取消");// 设置布局GroupLayout layout = new GroupLayout(dialog.getContentPane());dialog.getContentPane().setLayout(layout);layout.setAutoCreateGaps(true);layout.setAutoCreateContainerGaps(true);layout.setHorizontalGroup(layout.createParallelGroup(Alignment.LEADING).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(Alignment.LEADING).addComponent(idLabel).addComponent(nameLabel).addComponent(telLabel)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.LEADING).addComponent(idField).addComponent(nameField).addComponent(telField))).addGroup(Alignment.TRAILING, layout.createSequentialGroup().addPreferredGap(ComponentPlacement.RELATED, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE).addComponent(cancelButton).addPreferredGap(ComponentPlacement.RELATED).addComponent(saveButton)));layout.setVerticalGroup(layout.createParallelGroup(Alignment.LEADING).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(idLabel).addComponent(idField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(nameLabel).addComponent(nameField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(telLabel).addComponent(telField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED, 40, Short.MAX_VALUE).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(saveButton).addComponent(cancelButton))));// 添加按钮事件saveButton.addActionListener(e -> {String id = idField.getText().trim();String name = nameField.getText().trim();String tel = telField.getText().trim();if (id.isEmpty() || name.isEmpty()) {JOptionPane.showMessageDialog(dialog, "学校ID和学校名称不能为空", "输入错误", JOptionPane.ERROR_MESSAGE);return;}controller.addSchool(new School(id, name, tel));dialog.dispose();});cancelButton.addActionListener(e -> dialog.dispose());dialog.setVisible(true);}/*** 修改*/private void showEditSchoolDialog() {int selectedRow = schoolTable.getSelectedRow();if (selectedRow == -1) {JOptionPane.showMessageDialog(this, "请先选择要修改的学校", "提示", JOptionPane.INFORMATION_MESSAGE);return;}// 获取选中的学校数据String schoolId = (String) schoolTable.getValueAt(selectedRow, 0);String schoolName = (String) schoolTable.getValueAt(selectedRow, 1);String schoolTel = (String) schoolTable.getValueAt(selectedRow, 2);JDialog dialog = new JDialog(this, "修改学校", true);dialog.setSize(400, 300);dialog.setLocationRelativeTo(this);// 创建表单组件JLabel idLabel = new JLabel("学校ID:");JTextField idField = new JTextField(schoolId, 20);idField.setEditable(false); // ID不可编辑JLabel nameLabel = new JLabel("学校名称:");JTextField nameField = new JTextField(schoolName, 20);JLabel telLabel = new JLabel("联系电话:");JTextField telField = new JTextField(schoolTel, 20);JButton saveButton = new JButton("保存");JButton cancelButton = new JButton("取消");// 设置布局（与添加对话框类似）GroupLayout layout = new GroupLayout(dialog.getContentPane());dialog.getContentPane().setLayout(layout);layout.setAutoCreateGaps(true);layout.setAutoCreateContainerGaps(true);layout.setHorizontalGroup(layout.createParallelGroup(Alignment.LEADING).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(Alignment.LEADING).addComponent(idLabel).addComponent(nameLabel).addComponent(telLabel)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.LEADING).addComponent(idField).addComponent(nameField).addComponent(telField))).addGroup(Alignment.TRAILING, layout.createSequentialGroup().addPreferredGap(ComponentPlacement.RELATED, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE).addComponent(cancelButton).addPreferredGap(ComponentPlacement.RELATED).addComponent(saveButton)));layout.setVerticalGroup(layout.createParallelGroup(Alignment.LEADING).addGroup(layout.createSequentialGroup().addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(idLabel).addComponent(idField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(nameLabel).addComponent(nameField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(telLabel).addComponent(telField, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)).addPreferredGap(ComponentPlacement.RELATED, 40, Short.MAX_VALUE).addGroup(layout.createParallelGroup(Alignment.BASELINE).addComponent(saveButton).addComponent(cancelButton))));// 添加按钮事件saveButton.addActionListener(e -> {String id = idField.getText().trim();String name = nameField.getText().trim();String tel = telField.getText().trim();if (name.isEmpty()) {JOptionPane.showMessageDialog(dialog, "学校名称不能为空", "输入错误", JOptionPane.ERROR_MESSAGE);return;}controller.updateSchool(new School(id, name, tel));dialog.dispose();});cancelButton.addActionListener(e -> dialog.dispose());dialog.setVisible(true);}/*** 删除*/private void performDeleteSchool() {int selectedRow = schoolTable.getSelectedRow();if (selectedRow == -1) {JOptionPane.showMessageDialog(this, "请先选择要删除的学校", "提示", JOptionPane.INFORMATION_MESSAGE);return;}// 获取选中的学校IDString schoolId = (String) schoolTable.getValueAt(selectedRow, 0);String schoolName = (String) schoolTable.getValueAt(selectedRow, 1);// 确认对话框int confirm = JOptionPane.showConfirmDialog(this,"确定要删除学校 [" + schoolName + "] 吗？","确认删除",JOptionPane.YES_NO_OPTION,JOptionPane.WARNING_MESSAGE);if (confirm == JOptionPane.YES_OPTION) {controller.deleteSchool(schoolId);}}private void loadInitialData() {controller.loadSchools(currentSearchTerm, currentPage, pageSize);}private void performSearch() {currentSearchTerm = searchField.getText();currentPage = 1;  // 搜索时重置到第一页controller.loadSchools(currentSearchTerm, currentPage, pageSize);}private void initPaginationControls() {firstPageBtn = new JButton("首页");prevPageBtn = new JButton("上一页");nextPageBtn = new JButton("下一页");lastPageBtn = new JButton("末页");pageInfoLabel = new JLabel("第 1 页，共 0 页");firstPageBtn.addActionListener(e -> goToFirstPage());prevPageBtn.addActionListener(e -> goToPreviousPage());nextPageBtn.addActionListener(e -> goToNextPage());lastPageBtn.addActionListener(e -> goToLastPage());}private JPanel createPaginationPanel() {JPanel panel = new JPanel(new FlowLayout(FlowLayout.CENTER));panel.add(firstPageBtn);panel.add(prevPageBtn);panel.add(pageInfoLabel);panel.add(nextPageBtn);panel.add(lastPageBtn);return panel;}public void displaySchools(PagedResult<School> result) {tableModel.setSchools(result.getItems());tableModel.fireTableDataChanged();currentPage = result.getCurrentPage();updatePageInfo(result);}private void updatePageInfo(PagedResult<School> result) {pageInfoLabel.setText(String.format("第 %d 页，共 %d 页，总计 %d 条记录",result.getCurrentPage(),result.getTotalPages(),result.getTotalItems()));// 启用/禁用按钮firstPageBtn.setEnabled(result.hasPreviousPage());prevPageBtn.setEnabled(result.hasPreviousPage());nextPageBtn.setEnabled(result.hasNextPage());lastPageBtn.setEnabled(result.hasNextPage());}// 获取总页数的辅助方法private int getTotalPages() {String text = pageInfoLabel.getText();try {// 从"第 X 页，共 Y 页，总计 Z 条记录"中提取YString[] parts = text.split("，");if (parts.length >= 2) {String totalPagesPart = parts[1].trim();// 提取"共 Y 页"中的YString totalPagesStr = totalPagesPart.substring(totalPagesPart.indexOf("共") + 1,totalPagesPart.indexOf("页")).trim(); // 去除可能的空格// 增加调试输出System.out.println("提取的总页数字符串: '" + totalPagesStr + "'");return Integer.parseInt(totalPagesStr);}} catch (Exception e) {System.err.println("解析总页数失败: " + e.getMessage());e.printStackTrace();}return 1; // 默认返回1页}// 添加获取当前搜索词的方法public String getCurrentSearchTerm() {return currentSearchTerm;}// 修复导航方法，传递搜索参数private void goToPreviousPage() {if (currentPage > 1) {controller.loadSchools(currentSearchTerm, currentPage - 1, pageSize);}}// 其他导航方法也需要类似修改private void goToNextPage() {if (currentPage < getTotalPages()) {controller.loadSchools(currentSearchTerm, currentPage + 1, pageSize);}}private void goToFirstPage() {controller.loadSchools(currentSearchTerm, 1, pageSize);}private void goToLastPage() {int totalPages = getTotalPages();if (totalPages > 0) {controller.loadSchools(currentSearchTerm, totalPages, pageSize);}}// Getters for pagination statepublic int getCurrentPage() { return currentPage; }public int getPageSize() { return pageSize; }// 表格模型private static class SchoolTableModel extends AbstractTableModel {private List<School> schools = new ArrayList<>();private final String[] columnNames = {"学校ID", "学校名称", "联系电话"};public void setSchools(List<School> schools) {this.schools = schools;}@Overridepublic int getRowCount() {return schools.size();}@Overridepublic int getColumnCount() {return columnNames.length;}@Overridepublic String getColumnName(int column) {return columnNames[column];}@Overridepublic Object getValueAt(int rowIndex, int columnIndex) {School school = schools.get(rowIndex);switch (columnIndex) {case 0: return school.getSchoolId();case 1: return school.getSchoolName();case 2: return school.getSchoolTelNo();default: return null;}}}
}

调用：

/*** encoding: utf-8* 版权所有 2025 ©涂聚文有限公司 ®* 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎* 描述：* Author    : geovindu,Geovin Du 涂聚文.* IDE       : IntelliJ IDEA 2024.3.6 Java 17* # database  : Oracle21c,MySQL 9.0,SQL Server 2019,PostgreSQL 17.1 Neo4j* # OS        : window10* Datetime  : 2025 - 2025/7/13 - 17:51* User      : geovindu* Product   : IntelliJ IDEA* Project   : oracleDDDDemo* File      : main.java* explain   : 学习  类**/import presentation.views.SchoolView;public class Main {public static void main(String[] args) {// 使用SwingUtilites确保在事件调度线程上创建和操作GUIjavax.swing.SwingUtilities.invokeLater(new Runnable() {public void run() {SchoolView view = new SchoolView();view.setVisible(true);}});System.out.println("Hello, Geovin Du!");}
}

输出：

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如若转载，请注明出处：http://www.pswp.cn/news/914383.shtml
繁体地址，请注明出处：http://hk.pswp.cn/news/914383.shtml

如若内容造成侵权/违法违规/事实不符，请联系多彩编程网进行投诉反馈email:809451989@qq.com，一经查实，立即删除！

相关文章

两张图片对比clip功能

两张图片对比clip功能

<!DOCTYPE html> <html lang"zh-CN"> <head><meta charset"UTF-8"><meta name"viewport" content"widthdevice-width, initial-scale1.0"><title>图片拖动Clip对比功能</title><style&g…
阅读更多...
7.11 dp 图

7.11 dp 图

lcr148.栈按放入顺序推栈&#xff0c;能弹出的就及时弹出&#xff0c;最后栈空则符合要求。判断 takeOut 序列是否符合栈的操作逻辑&#xff0c;因为题目中“特殊的数据结构”其实就是栈&#xff08;先进后出&#xff09;。思路如下&#xff1a;1. 用一个栈来模拟图书放入的过程…
阅读更多...
react16-react19都更新哪些内容？

react16-react19都更新哪些内容？

React 16 到 React 19 是 React 发展非常关键的阶段&#xff0c;每个版本都带来了深远影响。以下是 React 16 → 19 的重要更新列表&#xff0c;按版本详细说明每一代的核心特性、重要变化、对开发者的意义&#xff0c;并附简评&#xff1a;✅ React 16&#xff08;2017 年&…
阅读更多...
【AI大模型】RAG系统组件：向量数据库（ChromaDB）

【AI大模型】RAG系统组件：向量数据库（ChromaDB）

RAG 系统中的关键组件&#xff1a;向量数据库&#xff08;Vector Database&#xff09;&#xff0c;并以 ChromaDB 为例进行说明。什么是向量数据库&#xff1f;核心概念&#xff1a; 向量数据库是一种专门设计用于高效存储、索引和检索高维向量的数据库。向量是什么&#xff1…
阅读更多...
006_测试评估与安全实践

006_测试评估与安全实践

测试评估与安全实践 目录 建立成功标准评估方法测试策略安全最佳实践隐私保护性能监控 建立成功标准 定义原则 1. 具体明确 清晰定义精确目标避免模糊表述如"良好性能"制定可操作的标准 不好的标准&#xff1a; 模型应该表现良好好的标准&#xff1a; 情感分…
阅读更多...
时序预测 | Pytorch实现CNN-KAN电力负荷时间序列预测模型

时序预测 | Pytorch实现CNN-KAN电力负荷时间序列预测模型

预测效果 代码功能 该代码实现了一个结合卷积神经网络&#xff08;CNN&#xff09;和Kolmogorov–Arnold网络&#xff08;KAN&#xff09;的混合模型&#xff08;CNN-KAN&#xff09;&#xff0c;用于时间序列预测任务。核心功能包括&#xff1a; 数据加载与预处理&#xff1…
阅读更多...
UI前端与数字孪生结合实践探索：智慧物流的仓储优化与管理系统

UI前端与数字孪生结合实践探索：智慧物流的仓储优化与管理系统

hello宝子们...我们是艾斯视觉擅长ui设计和前端数字孪生、大数据、三维建模、三维动画10年经验!希望我的分享能帮助到您!如需帮助可以评论关注私信我们一起探讨!致敬感谢感恩!一、引言&#xff1a;仓储管理的 “数字孪生革命”传统物流仓储正面临 “效率瓶颈、可视化差、响应滞…
阅读更多...
【Android】在平板上实现Rs485的数据通讯

【Android】在平板上实现Rs485的数据通讯

前言 在工业控制领域&#xff0c;Android 设备通过 RS485 接口与 PLC&#xff08;可编程逻辑控制器&#xff09;通信是一种常见的技术方案。最近在实现一个项目需要和plc使用485进行通讯&#xff0c;记录下实现的方式。 我这边使用的从平的Android平板&#xff0c;从平里面已经…
阅读更多...
MySQL技术笔记-备份与恢复完全指南

MySQL技术笔记-备份与恢复完全指南

目录 前言 一、备份概述 &#xff08;一&#xff09;备份方式 &#xff08;二&#xff09;备份策略 二、物理备份及恢复 &#xff08;一&#xff09;备份操作 &#xff08;二&#xff09;恢复操作 三、逻辑备份及恢复 &#xff08;一&#xff09;逻辑备份 &#xff0…
阅读更多...
SpringBoot或OpenFeign中 Jackson 配置参数名蛇形、小驼峰、大驼峰、自定义命名

SpringBoot或OpenFeign中 Jackson 配置参数名蛇形、小驼峰、大驼峰、自定义命名

SpringBoot或OpenFeign中 Jackson 配置参数名蛇形、小驼峰、大驼峰、自定义命名 前言 在调用外部接口时&#xff0c;对方给出的接口文档中&#xff0c;入参参数名一会大写加下划线&#xff0c;一会又是驼峰命名。 示例如下&#xff1a; {"MOF_DIV_CODE": "xx…
阅读更多...
uni-app 途径站点组件开发与实现分享

uni-app 途径站点组件开发与实现分享

在移动应用开发中&#xff0c;涉及到出行、物流等场景时&#xff0c;途径站点的展示是一个常见的需求。本文将为大家分享一个基于 uni-app 开发的途径站点组件&#xff0c;该组件能够清晰展示路线中的各个站点信息&#xff0c;包括站点名称、到达时间、是否已到达等状态&#x…
阅读更多...
kotlin中集合的用法

kotlin中集合的用法

从一个实际应用看起以下kotlin中代码语法正确吗 var testBeanAIP0200()var testList:List<AIP0200> ArrayList()testList.add(testBean)这段Kotlin代码存在语法错误&#xff0c;主要问题在于&#xff1a;List<AIP0200> 是Kotlin中的不可变集合接口&#xff0c;不能…
阅读更多...
深入理解 Java Map 与 Set

深入理解 Java Map 与 Set

文章目录前言1. 搜索树1.1 什么是搜索树1.2 查找1.3 插入1.4 删除情况一&#xff1a;cur 没有子节点&#xff08;即为叶子节点&#xff09;情况二&#xff1a;cur 只有一个子节点&#xff08;只有左子树或右子树&#xff09;情况三&#xff1a;cur 有两个子节点&#xff08;左右…
阅读更多...
excel如何只保留前几行

excel如何只保留前几行

方法一&#xff1a;手动删除多余行 选中你想保留的最后一行的下一行&#xff08;比如你只保留前10行&#xff0c;那选第11行&#xff09;。按住 Shift Ctrl ↓&#xff08;Windows&#xff09;或 Shift Command ↓&#xff08;Mac&#xff09;&#xff0c;选中从第11行到最…
阅读更多...
实时连接，精准监控：风丘科技数据远程显示方案提升试验车队管理效率

实时连接，精准监控：风丘科技数据远程显示方案提升试验车队管理效率

风丘科技推出的数据远程实时显示方案更好地满足了客户对于试验车队远程实时监控的需求&#xff0c;并真正实现了试验车队的远程管理。随着新的数据记录仪软件IPEmotion RT和相应的跨平台显示解决方案的引入&#xff0c;让我们的客户端不仅可在线访问记录器系统状态&#xff0c;…
阅读更多...
灰盒级SOA测试工具Parasoft SOAtest重新定义端到端测试

灰盒级SOA测试工具Parasoft SOAtest重新定义端到端测试

还在为脆弱的测试环境、强外部依赖和低效的测试复用拖慢交付而头疼&#xff1f;尤其在银行、医疗、制造等关键领域&#xff0c;传统的端到端测试常因环境不稳、接口难模拟、用例难共享而举步维艰。 灰盒级SOA测试工具Parasoft SOAtest以可视化编排简化复杂测试流程&#xff0c…
阅读更多...
OKHttp 核心知识点详解

OKHttp 核心知识点详解

OKHttp 核心知识点详解 一、基本概念与架构 1. OKHttp 简介 类型&#xff1a;高效的HTTP客户端特点&#xff1a; 支持HTTP/2和SPDY&#xff08;多路复用&#xff09;连接池减少请求延迟透明的GZIP压缩响应缓存自动恢复网络故障2. 核心组件组件功能OkHttpClient客户端入口&#…
阅读更多...
从“被动巡检”到“主动预警”：塔能物联运维平台重构路灯管理模式

从“被动巡检”到“主动预警”：塔能物联运维平台重构路灯管理模式

从以往的‘被动巡检’转变至如今的‘主动预警’&#xff0c;塔能物联运维平台对路灯管理模式展开了重新构建。城市路灯属于极为重要的市政基础设施范畴&#xff0c;它的实际运行状态和市民出行安全以及城市形象有着直接且紧密的关联。不过呢&#xff0c;传统的路灯管理模式当下…
阅读更多...
10. 常见的 http 状态码有哪些

10. 常见的 http 状态码有哪些

总结 1xx: 正在处理2xx: 成功3xx: 重定向&#xff0c;302 重定向&#xff0c;304 协商缓存4xx: 客户端错误&#xff0c;401 未登录&#xff0c;403 没权限&#xff0c;404 资源不存在5xx: 服务器错误常见的 HTTP 状态码详解 HTTP 状态码&#xff08;HTTP Status Code&#xff0…
阅读更多...
springBoot对接第三方系统

springBoot对接第三方系统

yml文件 yun:ip: port: username: password: controller package com.ruoyi.web.controller.materials;import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.materials.service.IYunService; import o…
阅读更多...
最新文章

Copyright @ 2022~2023