公交系统数据库和前后端代码

/** * @Title: MainView.java * @Package com.bus.view * @author yuqingming * @date 2020年6月8日 * @version V1.0 */ package com.bus.view; import java.awt.BorderLayout; import java.awt.Color; import java.awt.Cursor; import java.awt.Dimension; import java.awt.Font; import java.awt.GridLayout; import java.awt.Toolkit; import java.awt.event.*; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Vector; import javax.swing.Icon; import javax.swing.ImageIcon; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTabbedPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.UIManager; import javax.swing.event.ChangeEvent; import javax.swing.event.ChangeListener; import javax.swing.table.DefaultTableModel; import com.bus.constants.Constants; import com.bus.dao.model.Bus; import com.bus.dao.model.Line; import com.bus.dao.model.Scheduling; import com.bus.dao.model.Station; import com.bus.dao.model.User; import com.bus.enums.BtnEnum; import com.bus.enums.ColorEnum; import com.bus.enums.ImageEnum; import com.bus.enums.ModuleEnum; import com.bus.enums.TextEnum; import com.bus.service.LineService; import com.bus.service.StationService; import com.bus.service.impl.ServiceFactory; import com.bus.utils.TableModelUtil; import com.bus.view.dto.ComboBoxDto; import com.bus.view.listener.TabClickListener; /** * @ClassName: Main * @Description: 主页面 * @author yuqingming * @date 2020年6月8日 * @since JDK 1.8 */ public class MainView extends JFrame { /** * @Fields serialVersionUID */ private static final long serialVersionUID = 1L; /** * @Fields currentModule : 当前所在的功能模块 */ private ModuleEnum currentModule; /** * @Fields table : 业务数据表格 */ private JTable table; /** * @Fields actionListener : 按钮动作监听 */ private ActionListener actionListener; /** * @Fields SCREEN_WIDTH : 屏幕宽度 */ private final static int SCREEN_WIDTH = Toolkit.getDefaultToolkit().getScreenSize().width; /** * @Fields SCREEN_HEIGHT : 屏幕高度 */ private final static int SCREEN_HEIGHT = Toolkit.getDefaultToolkit().getScreenSize().height; /** * @Fields topPanel : 顶部面板 */ private JPanel topPanel; /** * @Fields topMenu : 顶部菜单 */ private JPanel topMenu; /** * @Fields topPrompt : 顶部欢迎面板 */ private JPanel topPrompt; /** * @Fields backgroundPanel : 背景面板 */ private JPanel backgroundPanel; /** * @Fields centerPanel : 中间内容面板 */ private JPanel centerPanel; /** * @Fields menuHome : 主页菜单 */ private JLabel menuHome; /** * @Fields menuBaseData : 基础数据菜单 */ private JLabel menuBaseData; /** * @Fields menuScheduling : 排班菜单 */ private JLabel menuScheduling; /** * @Fields menuUserManager : 用户菜单 */ private JLabel menuUserManager; /** * @Fields currentMenuLabel : 当前选择菜单 */ private JLabel currentMenuLabel; /** * @Fields currentTabbedPane : 当前页选项卡 */ private JTabbedPane currentTabbedPane; /** * @Fields currentScrollPane : 当前页滚动面板 */ private JScrollPane currentScrollPane; /** * @Fields tabClickListener : 选项卡点击监听 */ private TabClickListener tabClickListener; /** * @Fields conditionUserName : 用户查询条件-用户名 */ private SearchConditionPanel conditionUserName; /** * @Fields conditionUserRole : 用户查询条件-角色 */ private SearchConditionPanel conditionUserRole; /** * @Fields conditionUserStatus : 用户查询条件-状态 */ private SearchConditionPanel conditionUserStatus; /** * @Fields conditionBusLicense : 车辆查询条件-车牌号 */ private SearchConditionPanel conditionBusLicense; /** * @Fields conditionBusStatus : 车辆查询条件-车辆状态 */ private SearchConditionPanel conditionBusStatus; /** * @Fields conditionLineName : 线路查询条件-线路名称 */ private SearchConditionPanel conditionLineName; /** * @Fields conditionLineDirection : 线路查询条件-线路方向 */ private SearchConditionPanel conditionLineDirection; /** * @Fields conditionLineStatus : 线路查询条件-线路状态 */ private SearchConditionPanel conditionLineStatus; /** * @Fields conditionStationName : 站点查询条件-站点名称 */ private SearchConditionPanel conditionStationName; /** * @Fields conditionStationRegion : 站点查询条件-所在区域 */ private SearchConditionPanel conditionStationRegion; /** * @Fields conditionStationStreet : 站点查询条件-所在街道 */ private SearchConditionPanel conditionStationStreet; /** * @Fields conditionSchedulingBusCode : 排班查询条件-车牌号 */ private SearchConditionPanel conditionSchedulingBusCode; /** * @Fields conditionSchedulingLineName : 排班查询条件-线路名称 */ private SearchConditionPanel conditionSchedulingLineName; /** * @Fields conditionSchedulingStartStation : 排班查询条件-始发站 */ private SearchConditionPanel conditionSchedulingStartStation; /** * @Fields conditionSchedulingEndStation : 排班查询条件-终点站 */ private SearchConditionPanel conditionSchedulingEndStation; /** * @Fields lineStationsDialog : 选择线路包含车站窗口 */ private LineStationsDialog lineStationsDialog; /** * @Fields containStations : 当前编辑的包含车站 */ private JTextField containStations; /** * @Fields changePassDialog : 更改密码窗口 */ private ChangePassDialog changePassDialog; /** * @Fields userName : 登陆后显示的用户名 */ private String userName = ""; /** * @Fields userName : 密码 */ private String passWord = ""; private String userCode = ""; /** * @Fields authorityList : 登陆用户所具有的权限列表 */ private List<String> authorityList = null; /** * @Fields roleDtos : 系统中的角色列表 */ private List<ComboBoxDto> roleDtos; /** * 创建一个新的实例 MainView. * * @param actionListener */ public MainView(ActionListener actionListener) { new WindowOpacity(this); this.actionListener = actionListener; } /** * @Title: initialize * @Description: 初始化窗体 */ public void initialize() { // 设置tab面板缩进 UIManager.put("TabbedPane.tabAreaInsets", new javax.swing.plaf.InsetsUIResource(0, 0, 0, 0)); initBackgroundPanel(); this.setSize((int) (SCREEN_WIDTH * 0.6f), (int) (SCREEN_HEIGHT * 0.6f)); this.setMinimumSize(new Dimension((int) (SCREEN_WIDTH * 0.4f), (int) (SCREEN_HEIGHT * 0.4f))); this.setLocationRelativeTo(null); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setTitle(TextEnum.TITLE_MAIN.getName()); this.setIconImage(ImageEnum.ICON_TITLE.getIcon().getImage()); //用户查询条件 conditionUserName = new SearchConditionPanel(TextEnum.LABEL_USERNAME.getName()); List<ComboBoxDto> datas_user = new ArrayList<>(); datas_user.add(new ComboBoxDto("2", "全部")); datas_user.add(new ComboBoxDto("1", "启用")); datas_user.add(new ComboBoxDto("0", "禁用")); conditionUserStatus = new SearchConditionPanel(TextE