珠海公司网站制作公,wordpress的底部版权,网站 签约,有哪些网站可以免费看电影Java GUI——资产管理系统
前言#xff1a;为了做java课设#xff0c;学了一手Java GUI。感觉蛮有意思的#xff0c;写写文章#xff0c;做个视频记录一下。欢迎大家友善指出我的不足
资产管理系统录制视频#xff0c;从头敲到尾
模块划分
资产信息管理 资产信息查询 …Java GUI——资产管理系统
前言为了做java课设学了一手Java GUI。感觉蛮有意思的写写文章做个视频记录一下。欢迎大家友善指出我的不足
资产管理系统录制视频从头敲到尾
模块划分
资产信息管理 资产信息查询 【各种条件查询】资产信息修改不能对资产进行领用、归还、报废资产信息增加资产信息删除 人员信息管理 人员信息查询 【各种条件查询】人员信息修改人员信息增加人员信息删除 资产设备领用、归还、报废 资产设备操作仅限于领用、归还、报废资产设备查询 【各种条件】
数据库创建
资产表
DROP TABLE IF EXISTS asset_information;
CREATE TABLE asset_information (asset_number int NOT NULL AUTO_INCREMENT COMMENT 资产编号,asset_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 资产名称,price varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 价格,purchase_date varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 购买日期,status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 状态 0-默认 1-领用 2-归还 3-报废,remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 备注,PRIMARY KEY (asset_number) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 1007 CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci ROW_FORMAT Dynamic;-- ----------------------------
-- Records of asset_information
-- ----------------------------
INSERT INTO asset_information VALUES (1000, 潇洒哥, 1000, , 1, );
INSERT INTO asset_information VALUES (1004, 潇洒哥, 10000, 2020-09-07 14:52:54, 0, 是个蛋);
资产操作流水表
DROP TABLE IF EXISTS asset_operation_log;
CREATE TABLE asset_operation_log (operation_number int NOT NULL AUTO_INCREMENT COMMENT 操作编号,operation_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 操作类型 0-默认 1-领用 2-归还 3-报废,asset_number varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 资产编号,operation_time datetime NULL DEFAULT NULL COMMENT 操作时间,recipient varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 操作人,remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 备注,PRIMARY KEY (operation_number) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci ROW_FORMAT Dynamic;-- ----------------------------
-- Records of asset_operation_log
-- ----------------------------
INSERT INTO asset_operation_log VALUES (5, 1, 1000, NULL, 1, 无);
人员信息表
DROP TABLE IF EXISTS personnel_information;
CREATE TABLE personnel_information (personnel_number int NOT NULL AUTO_INCREMENT COMMENT 人员编号,name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 姓名,gender varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 性别,department varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 部门,position varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 职位,other varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci NULL DEFAULT NULL COMMENT 其他信息,PRIMARY KEY (personnel_number) USING BTREE
) ENGINE InnoDB AUTO_INCREMENT 4 CHARACTER SET utf8mb4 COLLATE utf8mb4_croatian_ci ROW_FORMAT Dynamic;-- ----------------------------
-- Records of personnel_information
-- ----------------------------
INSERT INTO personnel_information VALUES (1, 潇洒哥, 男, 羊村, 大哥, 是个蛋白色的蛋蛋);
INSERT INTO personnel_information VALUES (2, 飞鸽, 男, 鸽子部门, 二弟, 飞哥不鸽);
INSERT INTO personnel_information VALUES (3, 老王, 女, 军乐团, 团长, 牛逼啊);
业务流程 资产被人员操作后操作记录写入资产记录表。同时根据人员的操作修改资产本身的信息。
代码编写
maven坐标 dependencies!--Servlet--dependencygroupIdjavax.servlet/groupIdartifactIdjavax.servlet-api/artifactIdversion3.1.0/versionscopeprovided/scope/dependency!-- Lombok 依赖 --dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.18.20/versionscopeprovided/scope/dependency!--MyBatis--dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.5/version/dependencydependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus/artifactIdversion3.5.2/version/dependency!--MySQL--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.27/version/dependency!--fastjson--dependencygroupIdcom.alibaba/groupIdartifactIdfastjson/artifactIdversion1.2.62/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-context/artifactIdversion5.0.6.RELEASE/version/dependencydependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.1.2.RELEASE/version/dependency/dependenciesbuildpluginsplugingroupIdorg.apache.tomcat.maven/groupIdartifactIdtomcat7-maven-plugin/artifactIdversion2.0/version/plugin/plugins/build本项目采用模块划编写。不同模块划分为不同的包每个包下维护若干类每个类表示一个UI界面。
模块一主界面
1.1创建主界面UI
用代码构建如下界面, 但不具备界面跳转等操作 package com.xhf.keshe;import com.xhf.keshe.asset.AssetQuery;import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;public class Main extends JFrame {/*** 窗体宽*/public static final int width 800;/*** 窗体高*/public static final int height 600;/*** 基本字体*/public static final Font font new Font(仿宋, Font.BOLD, 20);/*** 创建基本界面*/private JPanel workspace;public Main() {// 创建窗体setTitle(资产管理系统);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);setSize(width, height);// 创建基本界面initBasePanel();// 居中setLocationRelativeTo(null);// 初始化界面initUI();}/*** 创建基本界面*/private void initBasePanel() {this.workspace new JPanel();workspace.setLayout(null);JLabel jLabel new JLabel(欢迎使用资产管理系统, JLabel.CENTER); //创建一个标签jLabel.setBounds(140, 100, 400, 60);jLabel.setFont(Main.font);workspace.add(jLabel, BorderLayout.NORTH);add(workspace);}/*** 初始化界面*/private void initUI() {// 添加菜单栏组件JMenuBar jMenuBar new JMenuBar();// 在菜单栏(bar)中添加若干菜单(menu)String[] jMenuNameList {资产信息管理, 人员信息管理, 资产设备管理};for (int i 0; i 3; i) {// jMenu的名称String jMenuName jMenuNameList[i];JMenu jMenu new JMenu(jMenuName);// 为menu添加itemaddItemForJMenu(jMenu, jMenuName);// 设置字体jMenu.setFont(font);// 将jMenu添加到bar中jMenuBar.add(jMenu);}// 添加jMenuBarsetJMenuBar(jMenuBar);}/*** 为不同名称的jMenu添加item* param jMenu* param jMenuName*/private void addItemForJMenu(JMenu jMenu, String jMenuName) {String[] item1NameList {资产信息查询, 资产信息修改, 资产信息增加, 资产信息删除};String[] item2NameList {人员信息查询, 人员信息修改, 人员信息增加, 人员信息删除};String[] item3NameList {资产设备查询, 资产设备操作};// 判断jMenu名称, 然后添加itemswitch (jMenuName) {case 资产信息管理:for (String s : item1NameList) {addItem(s, jMenu);}break;case 人员信息管理:for (String s : item2NameList) {addItem(s, jMenu);}break;case 资产设备管理:for (String s : item3NameList) {addItem(s, jMenu);}break;}}/*** 创建jMenuItem, 同时取名name, 将item添加到menu中* param name* param jMenu*/private void addItem(String name, JMenu jMenu) {JMenuItem item new JMenuItem(name);item.setFont(font);jMenu.add(item);}public static void main(String[] args) {Main main new Main();main.setVisible(true);}
}
1.2增加主界面的界面跳转逻辑
所有的界面跳转都可以理解为以下几个操作
触发相应操作清除当前界面添加需要界面界面重新渲染
分析可知通过点击item才触发界面跳转的操作。因此我们需要给不同的item上添加相应的监听器用于执行界面跳转的逻辑 /*** 创建jMenuItem, 同时取名name, 将item添加到menu中* param name* param jMenu*/private void addItem(String name, JMenu jMenu) {JMenuItem item new JMenuItem(name);// 为不同的item添加监听操作item.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 为不同的item添加不同的界面switch (name) {case 资产信息查询:// 清空当前界面remove(workspace);// 添加想要的界面workspace new AssetQuery();add(workspace);// 重新绘制界面validate();break;}}});item.setFont(font);jMenu.add(item);}模块二 资产界面
2.1mybatis整合
学习资料
(44条消息) Mybatis基本使用教程小白向_敲代码它不香嘛的博客-CSDN博客
入门_MyBatis中文网
2.2.1) 编写mybatis-config.xml
?xml version1.0 encodingUTF-8 ?
!DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd
configurationenvironments defaultdevelopmentenvironment iddevelopmenttransactionManager typeJDBC/dataSource typePOOLEDproperty namedriver valuecom.mysql.cj.jdbc.Driver/property nameurl valuejdbc:mysql://localhost:3306/keshe1/property nameusername valueroot/property namepassword valueroot//dataSource/environment/environmentsmappers!--后续编写的mapper.xml都需要添加到这里--mapper resourcemapper/assetInformationMapper.xml/mapper resourcemapper/personnelInformationMapper.xml/mapper resourcemapper/operateMapper.xml//mappers
/configuration如下图编写mybatis-config.xml【核心配置文件】文件放置在resources根目录 2.2.2) 获取SqlSession
sqlsession是mybatis中的核心工具有了它才有后续操作。sqlsession封装jdbc的数据库连接操作
package com.xhf.keshe.utils;import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;import java.io.IOException;
import java.io.InputStream;public class GetSqlsession {private static InputStream inputStream;//这个方法生成一个生产Sqlsession的工厂即SqlSessionFactorypublic static SqlSessionFactory createfactory() {{try {inputStream Resources.getResourceAsStream(mybatis-config.xml);} catch (IOException e) {e.printStackTrace();}}SqlSessionFactory sqlSessionFactory new SqlSessionFactoryBuilder().build(inputStream);//通过把这个工厂return出来以便后续通过这个工厂获得SqlSession对象return sqlSessionFactory;}//这个方法获得SqlSession对象public static SqlSession getsqlsession(){return createfactory().openSession();}
}2.2.3编写实体类
package com.xhf.keshe.asset.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;Data
NoArgsConstructor
AllArgsConstructor
public class AssetInformation implements Serializable {private static final long serialVersionUID 1L;/*** 资产编号*/private Integer assetNumber;/*** 资产名称*/private String assetName;/*** 价格*/private String price;/*** 购买日期*/private String purchaseDate;/*** 状态 0-默认 1-领用 2-归还 3-报废*/private String status;/*** 备注*/private String remarks;
}2.2.5) 编写mapper接口
package com.xhf.keshe.asset.mapper;import com.xhf.keshe.asset.entity.AssetInformation;
import org.apache.ibatis.annotations.Param;import java.util.List;public interface AssetInformationMapper {/*** 查询全部信息* return*/ListAssetInformation list();/*** 根据id查询数据*/AssetInformation listById(Param(id) String id);/*** 修改*/void update(Param(entity) AssetInformation entity);/*** 新增数据*/void insert(Param(entity) AssetInformation entity);/*** 根据id删除数据*/void deleteById(Param(id) Integer id);
}
2.2.6编写mapper的xml文件
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.xhf.keshe.asset.mapper.AssetInformationMapperresultMap idBaseResultMap typecom.xhf.keshe.asset.entity.AssetInformation result columnasset_number propertyassetNumber /result columnasset_name propertyassetName /result columnprice propertyprice /result columnpurchase_date propertypurchaseDate /result columnstatus propertystatus /result columnremarks propertyremarks //resultMapinsert idinsert useGeneratedKeystrue keyPropertyassetNumberINSERT INTOasset_informationVALUES (null,#{entity.assetName},#{entity.price},#{entity.purchaseDate},#{entity.status},#{entity.remarks});/insertupdate idupdateUPDATE asset_informationsetif testentity.assetName ! null asset_name #{entity.assetName}, /ifif testentity.price ! null price #{entity.price}, /ifif testentity.purchaseDate ! null purchase_date #{entity.purchaseDate}, /ifif testentity.status status #{entity.status}, /ifif testentity.remarks remarks #{entity.remarks} /if/setWHEREasset_information.asset_number #{entity.assetNumber}/updatedelete iddeleteByIdDELETE FROM asset_information WHERE asset_information.asset_number #{id};/deleteselect idlist resultMapBaseResultMapSELECT * FROM asset_information;/selectselect idlistById resultMapBaseResultMapSELECT * FROM asset_information WHERE asset_number #{id};/select/mapper2.2查询界面UI
package com.xhf.keshe.asset.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.entity.AssetInformation;
import com.xhf.keshe.asset.mapper.AssetInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.*;
import java.util.List;/*** 维护资产信息查询界面*/
public class AssetQuery extends JPanel {// 表格列名public static final String[] columnNames {资产编号, 资产名称, 价格, 购买日期, 状态, 备注};/*** sqlsession*/private SqlSession sqlSession;/*** mapper*/private AssetInformationMapper mapper;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(AssetInformationMapper.class);}public AssetQuery() {// 设置界面大小setSize(Main.width, Main.height);// 设置布局setLayout(new BorderLayout());// 设置标题JLabel title new JLabel(资产查询);title.setFont(Main.TitleFont);// 设置标题为居中对其title.setHorizontalAlignment(SwingConstants.CENTER);this.add(title, BorderLayout.NORTH);// 创建表格数据Object[][] data getData();// 创建 JTableJTable table new JTable(data, columnNames);// 设置头的字体table.getTableHeader().setFont(Main.font);// 设置每行的高度table.setRowHeight(25);// 设置表内容字体table.setFont(Main.font);// 将表格添加到滚动面板并将滚动面板添加到窗口JScrollPane scrollPane new JScrollPane(table);this.add(scrollPane);}/*** 返回资产表格数据* return*/private Object[][] getData() {// 返回list数据ListAssetInformation list mapper.list();Object[][] data new Object[list.size()][columnNames.length];// 将list处理为二维数组, 赋值给datafor (int i 0; i list.size(); i) {// 将list[i] - assetInformation 变为数组Object[] res new Object[columnNames.length];AssetInformation assetInformation list.get(i);res[0] assetInformation.getAssetNumber();res[1] assetInformation.getAssetName();res[2] assetInformation.getPrice();res[3] assetInformation.getPurchaseDate();res[4] assetInformation.getStatus();res[5] assetInformation.getRemarks();data[i] res;}return data;}
}2.3添加界面UI
package com.xhf.keshe.asset.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.entity.AssetInformation;
import com.xhf.keshe.asset.mapper.AssetInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;public class AssetAdd extends JPanel {/*** title宽度*/public static final int widthTitle 200, heightTitle 40;/*** 标题x坐标*/public static final int xTitle Main.width / 2 - widthTitle / 2;/*** 标题y坐标*/public static final int yTitle Main.height / 10;/*** y轴间距*/public static final int yGap 40;/*** 存储所有的JTextField*/private final ListJTextField jTextFieldList new ArrayListJTextField();/*** 获取mapper*/private static AssetInformationMapper mapper;/*** 获取sqlSession*/private static SqlSession sqlSession;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(AssetInformationMapper.class);}/*** 提交button*/private final JButton jButton new JButton(添加);public AssetAdd() {setLayout(null);// 设置title坐标JLabel title new JLabel(添加资产信息);title.setFont(Main.TitleFont);title.setBounds(xTitle, yTitle, widthTitle, heightTitle);// 通过title坐标, 计算剩余组件坐标, 并添加int widthLabel 100, heightLabel 30, xLabel xTitle / 2, yLabel yTitle yGap heightLabel, xGap 80;int xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;for (int i 0; i AssetQuery.columnNames.length - 1; i) {// 创建JLabelJLabel jLabel new JLabel(AssetQuery.columnNames[i 1]);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 创建JTextFieldJTextField jTextField new JTextField();jTextField.setFont(Main.font);jTextField.setBounds(xText, yText, widthText, heightText);// 添加add(jLabel);add(jTextField);// 将所有jTextField存储jTextFieldList.add(jTextField);// 更新位置yLabel yGap;yText yGap;}// 添加修改buttonjButton.setFont(Main.font);jButton.setBounds(xTitle, yText yGap, widthTitle, heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 提交数据save();}});add(title);add(jButton);}/*** 提交数据*/private void save() {System.out.println(保存数据);AssetInformation entity new AssetInformation();entity.setAssetName(jTextFieldList.get(0).getText());entity.setPrice(jTextFieldList.get(1).getText());entity.setPurchaseDate(jTextFieldList.get(2).getText());entity.setStatus(jTextFieldList.get(3).getText());entity.setRemarks(jTextFieldList.get(4).getText());// 保存数据mapper.insert(entity);// 事务提交sqlSession.commit();JOptionPane.showMessageDialog(null, 添加成功);}
}
2.4修改界面UI
package com.xhf.keshe.asset.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.entity.AssetInformation;
import com.xhf.keshe.asset.mapper.AssetInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;public class AssetUpdate extends JPanel {/*** title宽度*/private static final int widthTitle 200, heightTitle 40;/*** 标题x坐标*/private static final int xTitle Main.width / 2 - widthTitle / 2;/*** 标题y坐标*/private static final int yTitle Main.height / 10;/*** y轴间距*/private static final int yGap 40;/*** 存储所有的JTextField*/private final ListJTextField jTextFieldList new ArrayListJTextField();/*** sqlsession*/private SqlSession sqlSession;/*** 获取mapper*/private AssetInformationMapper mapper;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(AssetInformationMapper.class);}/*** 提交button*/private final JButton jButton new JButton(修改);public AssetUpdate() {setLayout(null);// 设置title坐标JLabel title new JLabel(修改资产信息);title.setFont(Main.TitleFont);title.setBounds(xTitle, yTitle, widthTitle, heightTitle);// 通过title坐标, 计算剩余组件坐标, 并添加int widthLabel 100, heightLabel 30, xLabel xTitle / 2, yLabel yTitle yGap heightLabel, xGap 80;int xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;for (int i 0; i AssetQuery.columnNames.length; i) {// 创建JLabelJLabel jLabel new JLabel(AssetQuery.columnNames[i]);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 创建JTextFieldJTextField jTextField new JTextField();jTextField.setFont(Main.font);jTextField.setBounds(xText, yText, widthText, heightText);// 添加add(jLabel);add(jTextField);// 将所有jTextField存储jTextFieldList.add(jTextField);if (i 0) {System.out.println(添加button);// 添加查询按钮JButton jButton new JButton(查询);jButton.setFont(Main.font);jButton.setBounds(xText widthText 10, yText, 80, heightText);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 查询数据getData();// 重置文本框读写状态setField();}});add(jButton);} else {// 设置所有的都无法修改jTextField.setEnabled(false);}// 更新位置yLabel yGap;yText yGap;}// 添加修改buttonjButton.setEnabled(false);jButton.setFont(Main.font);jButton.setBounds(xTitle, yText yGap, widthTitle, heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 提交数据upload();}});add(title);add(jButton);}/*** 重置textField的写状态*/private void setField() {// 除了状态, 其它都可修改for (int i1 0; i1 jTextFieldList.size(); i1) {if (i1 ! 4) {jTextFieldList.get(i1).setEnabled(true);}}}/*** 根据id查询数据信息, 并进行回显*/private void getData() {// 根据jTextField中的id查询数据, 并进行数据回显String id jTextFieldList.get(0).getText();AssetInformation assetInformation mapper.listById(id);// 查不到if (assetInformation null) {JOptionPane.showMessageDialog(null, 查询失败);return;}// 修改按钮功能重新开启jButton.setEnabled(true);// 数据回显jTextFieldList.get(0).setText(String.valueOf(assetInformation.getAssetNumber()));jTextFieldList.get(1).setText(assetInformation.getAssetName());jTextFieldList.get(2).setText(assetInformation.getPrice());jTextFieldList.get(3).setText(assetInformation.getPurchaseDate());jTextFieldList.get(4).setText(assetInformation.getStatus());jTextFieldList.get(5).setText(assetInformation.getRemarks());}/*** 提交数据*/private void upload() {AssetInformation entity new AssetInformation();entity.setAssetNumber(Integer.valueOf(jTextFieldList.get(0).getText()));entity.setAssetName(jTextFieldList.get(1).getText());entity.setPrice(jTextFieldList.get(2).getText());entity.setPurchaseDate(jTextFieldList.get(3).getText());entity.setStatus(jTextFieldList.get(4).getText());entity.setRemarks(jTextFieldList.get(5).getText());// 保存数据mapper.update(entity);sqlSession.commit();JOptionPane.showMessageDialog(null, 修改成功);}
}
2.5删除界面UI
package com.xhf.keshe.asset.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.mapper.AssetInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;public class AssetDelete extends JPanel {/*** sqlsession*/private static SqlSession sqlSession;/*** mapper*/private static AssetInformationMapper assetInformationMapper;{sqlSession GetSqlsession.getsqlsession();assetInformationMapper sqlSession.getMapper(AssetInformationMapper.class);}public AssetDelete() {setLayout(null);// 设置标题JLabel title new JLabel(资产信息删除);title.setFont(Main.TitleFont);title.setBounds(AssetAdd.xTitle, AssetAdd.yTitle, AssetAdd.widthTitle, AssetAdd.heightTitle);add(title);// jLabel设置坐标int widthLabel 100, heightLabel 30, xLabel AssetAdd.xTitle / 2, yLabel AssetAdd.yTitle AssetAdd.yGap heightLabel, xGap 80;JLabel jLabel new JLabel(资产编号);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 设置JComboxint xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;JComboBox jComboBox new JComboBox();jComboBox.setFont(Main.font);jComboBox.setBounds(xText, yText, widthText, heightText);jComboBox.addItem(请选择);// 查询所有的id, 并添加到JComboBox中assetInformationMapper.list().forEach(e - {jComboBox.addItem(e.getAssetNumber());});add(jLabel);add(jComboBox);// 删除按钮JButton jButton new JButton(删除);jButton.setFont(Main.font);jButton.setBounds(AssetAdd.xTitle, AssetAdd.yTitle 120, AssetAdd.widthTitle, AssetAdd.heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {Object id jComboBox.getSelectedItem();assetInformationMapper.deleteById((Integer) id);sqlSession.commit();JOptionPane.showMessageDialog(null, 删除成功);}});add(jButton);}
}
模块三人员界面
3.1mybatis整合
3.1.1编写实体类
package com.xhf.keshe.person.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;Data
NoArgsConstructor
AllArgsConstructor
public class PersonnelInformation implements Serializable {private static final long serialVersionUID 1L;/*** 人员编号*/private Integer personnelNumber;/*** 姓名*/private String name;/*** 性别*/private String gender;/*** 部门*/private String department;/*** 职位*/private String position;/*** 其他信息*/private String other;
}3.1.2编写mapper接口
package com.xhf.keshe.person.mapper;import com.xhf.keshe.person.entity.PersonnelInformation;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;import java.util.List;Mapper
public interface PersonnelInformationMapper {/*** 查询全部信息* return*/ListPersonnelInformation list();/*** 根据id查询数据*/PersonnelInformation listById(Param(id) String id);/*** 修改*/void update(Param(entity) PersonnelInformation entity);/*** 新增数据*/void insert(Param(entity) PersonnelInformation entity);/*** 根据id删除数据*/void deleteById(Param(id) Integer id);
}
3.1.3编写mapper的xml文件
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.xhf.keshe.person.mapper.PersonnelInformationMapperresultMap idBaseResultMap typecom.xhf.keshe.person.entity.PersonnelInformation result columnpersonnel_number propertypersonnelNumber /result columnname propertyname /result columngender propertygender /result columndepartment propertydepartment /result columnposition propertyposition /result columnother propertyother //resultMapinsert idinsertINSERT INTOpersonnel_informationVALUES (null,#{entity.name},#{entity.gender},#{entity.department},#{entity.position},#{entity.other})/insertupdate idupdateUPDATE personnel_informationSETname #{entity.name},gender #{entity.gender},department #{entity.department},position #{entity.position},other #{entity.other}WHEREpersonnel_number #{entity.personnelNumber};/updatedelete iddeleteByIdDELETE FROM personnel_information WHERE personnel_number #{id};/deleteselect idlist resultMapBaseResultMapSELECT * FROM personnel_information;/selectselect idlistById resultMapBaseResultMapSELECT * FROM personnel_information WHERE personnel_number #{id};/select/mapper3.2查询界面UI
package com.xhf.keshe.person.page;import com.xhf.keshe.Main;
import com.xhf.keshe.person.entity.PersonnelInformation;
import com.xhf.keshe.person.mapper.PersonnelInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.*;
import java.util.List;/*** 维护资产信息查询界面*/
public class PersonQuery extends JPanel {/*** 获取mapper*/private static PersonnelInformationMapper mapper;/*** 获取sqlSession*/private static SqlSession sqlSession;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(PersonnelInformationMapper.class);}// 表格列名public static final String[] columnNames {人员编号, 姓名, 性别, 部门, 职位, 其它信息};public PersonQuery() {// 设置界面大小setSize(Main.width, Main.height);// 设置布局setLayout(new BorderLayout());// 设置标题JLabel title new JLabel(人员查询);title.setFont(Main.TitleFont);// 设置标题为居中对其title.setHorizontalAlignment(SwingConstants.CENTER);this.add(title, BorderLayout.NORTH);// 创建表格数据Object[][] data getData();// 创建 JTableJTable table new JTable(data, columnNames);// 设置头的字体table.getTableHeader().setFont(Main.font);// 设置每行的高度table.setRowHeight(25);// 设置表内容字体table.setFont(Main.font);// 将表格添加到滚动面板并将滚动面板添加到窗口JScrollPane scrollPane new JScrollPane(table);this.add(scrollPane);}/*** 返回资产表格数据* return*/private Object[][] getData() {// 返回list数据ListPersonnelInformation list mapper.list();System.out.println(list.toString());Object[][] data new Object[list.size()][columnNames.length];// 将list处理为二维数组, 赋值给datafor (int i 0; i list.size(); i) {// 将list[i] - assetInformation 变为数组Object[] res new Object[columnNames.length];PersonnelInformation personnelInformation list.get(i);res[0] personnelInformation.getPersonnelNumber();res[1] personnelInformation.getName();res[2] personnelInformation.getGender();res[3] personnelInformation.getDepartment();res[4] personnelInformation.getPosition();res[5] personnelInformation.getOther();data[i] res;}return data;}
}3.3添加界面UI
package com.xhf.keshe.person.page;import com.xhf.keshe.Main;
import com.xhf.keshe.person.entity.PersonnelInformation;
import com.xhf.keshe.person.mapper.PersonnelInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;public class PersonAdd extends JPanel {/*** title宽度*/public static final int widthTitle 200, heightTitle 40;/*** 标题x坐标*/public static final int xTitle Main.width / 2 - widthTitle / 2;/*** 标题y坐标*/public static final int yTitle Main.height / 10;/*** y轴间距*/public static final int yGap 40;/*** 存储所有的JTextField*/private final ListJTextField jTextFieldList new ArrayListJTextField();/*** 获取mapper*/private static PersonnelInformationMapper mapper;/*** 获取sqlSession*/private static SqlSession sqlSession;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(PersonnelInformationMapper.class);}/*** 提交button*/private final JButton jButton new JButton(添加);public PersonAdd() {setLayout(null);// 设置title坐标JLabel title new JLabel(添加人员信息);title.setFont(Main.TitleFont);title.setBounds(xTitle, yTitle, widthTitle, heightTitle);// 通过title坐标, 计算剩余组件坐标, 并添加int widthLabel 100, heightLabel 30, xLabel xTitle / 2, yLabel yTitle yGap heightLabel, xGap 80;int xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;for (int i 0; i PersonQuery.columnNames.length - 1; i) {// 创建JLabelJLabel jLabel new JLabel(PersonQuery.columnNames[i 1]);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 创建JTextFieldJTextField jTextField new JTextField();jTextField.setFont(Main.font);jTextField.setBounds(xText, yText, widthText, heightText);// 添加add(jLabel);add(jTextField);// 将所有jTextField存储jTextFieldList.add(jTextField);// 更新位置yLabel yGap;yText yGap;}// 添加修改buttonjButton.setFont(Main.font);jButton.setBounds(xTitle, yText yGap, widthTitle, heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 提交数据save();}});add(title);add(jButton);}/*** 提交数据*/private void save() {System.out.println(保存数据);PersonnelInformation entity new PersonnelInformation();entity.setName(jTextFieldList.get(0).getText());entity.setGender(jTextFieldList.get(1).getText());entity.setDepartment(jTextFieldList.get(2).getText());entity.setPosition(jTextFieldList.get(3).getText());entity.setOther(jTextFieldList.get(4).getText());// 保存数据mapper.insert(entity);// 事务提交sqlSession.commit();JOptionPane.showMessageDialog(null, 添加成功);}
}
3.4修改界面UI
package com.xhf.keshe.person.page;import com.xhf.keshe.Main;
import com.xhf.keshe.person.entity.PersonnelInformation;
import com.xhf.keshe.person.mapper.PersonnelInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.List;public class PersonUpdate extends JPanel {/*** title宽度*/private static final int widthTitle 200, heightTitle 40;/*** 标题x坐标*/private static final int xTitle Main.width / 2 - widthTitle / 2;/*** 标题y坐标*/private static final int yTitle Main.height / 10;/*** y轴间距*/private static final int yGap 40;/*** 存储所有的JTextField*/private final ListJTextField jTextFieldList new ArrayListJTextField();/*** sqlsession*/private SqlSession sqlSession;/*** 获取mapper*/private PersonnelInformationMapper mapper;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(PersonnelInformationMapper.class);}/*** 提交button*/private final JButton jButton new JButton(修改);public PersonUpdate() {setLayout(null);// 设置title坐标JLabel title new JLabel(修改人员信息);title.setFont(Main.TitleFont);title.setBounds(xTitle, yTitle, widthTitle, heightTitle);// 通过title坐标, 计算剩余组件坐标, 并添加int widthLabel 100, heightLabel 30, xLabel xTitle / 2, yLabel yTitle yGap heightLabel, xGap 80;int xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;for (int i 0; i PersonQuery.columnNames.length; i) {// 创建JLabelJLabel jLabel new JLabel(PersonQuery.columnNames[i]);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 创建JTextFieldJTextField jTextField new JTextField();jTextField.setFont(Main.font);jTextField.setBounds(xText, yText, widthText, heightText);// 添加add(jLabel);add(jTextField);// 将所有jTextField存储jTextFieldList.add(jTextField);if (i 0) {System.out.println(添加button);// 添加查询按钮JButton jButton new JButton(查询);jButton.setFont(Main.font);jButton.setBounds(xText widthText 10, yText, 80, heightText);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 查询数据getData();// 重置文本框读写状态setField();}});add(jButton);} else {// 设置所有的都无法修改jTextField.setEnabled(false);}// 更新位置yLabel yGap;yText yGap;}// 添加修改buttonjButton.setEnabled(false);jButton.setFont(Main.font);jButton.setBounds(xTitle, yText yGap, widthTitle, heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 提交数据upload();}});add(title);add(jButton);}/*** 重置textField的写状态*/private void setField() {// 除了状态, 其它都可修改for (int i1 0; i1 jTextFieldList.size(); i1) {jTextFieldList.get(i1).setEnabled(true);}}/*** 根据id查询数据信息, 并进行回显*/private void getData() {// 根据jTextField中的id查询数据, 并进行数据回显String id jTextFieldList.get(0).getText();PersonnelInformation personnelInformation mapper.listById(id);// 查不到if (personnelInformation null) {JOptionPane.showMessageDialog(null, 查询失败);return;}// 修改按钮功能重新开启jButton.setEnabled(true);// 数据回显jTextFieldList.get(0).setText(String.valueOf(personnelInformation.getPersonnelNumber()));jTextFieldList.get(1).setText(personnelInformation.getName());jTextFieldList.get(2).setText(personnelInformation.getGender());jTextFieldList.get(3).setText(personnelInformation.getDepartment());jTextFieldList.get(4).setText(personnelInformation.getPosition());jTextFieldList.get(5).setText(personnelInformation.getOther());}/*** 提交数据*/private void upload() {PersonnelInformation entity new PersonnelInformation();entity.setPersonnelNumber(Integer.valueOf(jTextFieldList.get(0).getText()));entity.setName(jTextFieldList.get(1).getText());entity.setGender(jTextFieldList.get(2).getText());entity.setDepartment(jTextFieldList.get(3).getText());entity.setPosition(jTextFieldList.get(4).getText());entity.setOther(jTextFieldList.get(5).getText());// 保存数据mapper.update(entity);sqlSession.commit();JOptionPane.showMessageDialog(null, 修改成功);}
}
3.5删除界面UI
package com.xhf.keshe.person.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.page.AssetAdd;
import com.xhf.keshe.person.mapper.PersonnelInformationMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;public class PersonDelete extends JPanel {/*** sqlsession*/private static SqlSession sqlSession;/*** mapper*/private static PersonnelInformationMapper mapper;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(PersonnelInformationMapper.class);}public PersonDelete() {setLayout(null);// 设置标题JLabel title new JLabel(人员信息删除);title.setFont(Main.TitleFont);title.setBounds(AssetAdd.xTitle, AssetAdd.yTitle, AssetAdd.widthTitle, AssetAdd.heightTitle);add(title);// jLabel设置坐标int widthLabel 100, heightLabel 30, xLabel AssetAdd.xTitle / 2, yLabel AssetAdd.yTitle AssetAdd.yGap heightLabel, xGap 80;JLabel jLabel new JLabel(人员id);jLabel.setFont(Main.font);jLabel.setBounds(xLabel, yLabel, widthLabel, heightLabel);// 设置JComboxint xText xLabel widthLabel xGap, yText yLabel, widthText 300, heightText 30;JComboBox jComboBox new JComboBox();jComboBox.setFont(Main.font);jComboBox.setBounds(xText, yText, widthText, heightText);jComboBox.addItem(请选择);// 查询所有的id, 并添加到JComboBox中mapper.list().forEach(e - {jComboBox.addItem(e.getPersonnelNumber());});add(jLabel);add(jComboBox);// 删除按钮JButton jButton new JButton(删除);jButton.setFont(Main.font);jButton.setBounds(AssetAdd.xTitle, AssetAdd.yTitle 120, AssetAdd.widthTitle, AssetAdd.heightTitle);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {Object id jComboBox.getSelectedItem();mapper.deleteById((Integer) id);sqlSession.commit();JOptionPane.showMessageDialog(null, 删除成功);}});add(jButton);}
}
模块四资产操作
4.1mybatis整合
4.1.1编写实体类
package com.xhf.keshe.operate.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.io.Serializable;
import java.util.Date;Data
NoArgsConstructor
AllArgsConstructor
public class AssetOperationLog implements Serializable {private static final long serialVersionUID 1L;/*** 操作编号*/private Integer operationNumber;/*** 操作类型*/private String operationType;/*** 资产编号*/private String assetNumber;/*** 操作时间*/private Date operationTime;/*** 领用人*/private String recipient;/*** 备注*/private String remarks;
}4.1.2编写mapper接口
package com.xhf.keshe.operate.mapper;import com.xhf.keshe.operate.entity.AssetOperationLog;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;import java.util.List;Mapper
public interface OperateMapper {/*** 查询所有数据* return*/ListAssetOperationLog list();/*** 保存*/void insert(Param(entity) AssetOperationLog entity);
}
4.1.3编写mapper的xml文件
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.xhf.keshe.operate.mapper.OperateMapperresultMap idBaseResultMap typecom.xhf.keshe.operate.entity.AssetOperationLog result columnoperation_number propertyoperationNumber /result columnoperation_type propertyoperationType /result columnasset_number propertyassetNumber /result columnoperation_time propertyoperationTime /result columnrecipient propertyrecipient /result columnremarks propertyremarks //resultMapinsert idinsertINSERT INTOasset_operation_logVALUES (null,#{entity.operationType},#{entity.assetNumber},#{entity.operationTime},#{entity.recipient},#{entity.remarks});/insertselect idlist resultMapBaseResultMapSELECT * FROM asset_operation_log;/select/mapper4.2资产查询界面
package com.xhf.keshe.operate.page;import com.xhf.keshe.Main;
import com.xhf.keshe.operate.entity.AssetOperationLog;
import com.xhf.keshe.operate.mapper.OperateMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.*;
import java.util.List;public class OperateQuery extends JPanel {/*** 列名*/public static final String[] columnNames {操作编号, 操作类型, 资产编号, 操作时间, 操作人, 备注};/*** sqlsession*/private SqlSession sqlSession;/*** mapper*/private OperateMapper mapper;{sqlSession GetSqlsession.getsqlsession();mapper sqlSession.getMapper(OperateMapper.class);}public OperateQuery() {// 设置界面大小setSize(Main.width, Main.height);// 设置布局setLayout(new BorderLayout());// 设置标题JLabel title new JLabel(操作查询);title.setFont(Main.TitleFont);// 设置标题为居中对其title.setHorizontalAlignment(SwingConstants.CENTER);this.add(title, BorderLayout.NORTH);// 创建表格数据Object[][] data getData();// 创建 JTableJTable table new JTable(data, columnNames);// 设置头的字体table.getTableHeader().setFont(Main.font);// 设置每行的高度table.setRowHeight(25);// 设置表内容字体table.setFont(Main.font);// 将表格添加到滚动面板并将滚动面板添加到窗口JScrollPane scrollPane new JScrollPane(table);this.add(scrollPane);}/*** 返回资产表格数据* return*/private Object[][] getData() {// 返回list数据ListAssetOperationLog list mapper.list();Object[][] data new Object[list.size()][columnNames.length];// 将list处理为二维数组, 赋值给datafor (int i 0; i list.size(); i) {// 将list[i] - assetInformation 变为数组Object[] res new Object[columnNames.length];AssetOperationLog operationLog list.get(i);res[0] operationLog.getOperationNumber();res[1] operationLog.getOperationType();res[2] operationLog.getAssetNumber();res[3] operationLog.getOperationTime();res[4] operationLog.getRecipient();res[5] operationLog.getRemarks();data[i] res;}return data;}
}
4.3资产操作界面
package com.xhf.keshe.operate.page;import com.xhf.keshe.Main;
import com.xhf.keshe.asset.entity.AssetInformation;
import com.xhf.keshe.asset.mapper.AssetInformationMapper;
import com.xhf.keshe.asset.page.AssetQuery;
import com.xhf.keshe.operate.entity.AssetOperationLog;
import com.xhf.keshe.operate.mapper.OperateMapper;
import com.xhf.keshe.utils.GetSqlsession;
import org.apache.ibatis.session.SqlSession;import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.List;public class Operate extends JPanel {/*** sqlsession*/private SqlSession sqlsession;/*** mapper*/private OperateMapper mapper;/*** mapper*/private AssetInformationMapper mapper2;/*** 资产编号*/private JTextField jTextField1;/*** 操作人员编号*/private JTextField jTextField2;/*** 备注*/private JTextField jTextField3;/*** 操作类型*/private JComboBox comboBox;{sqlsession GetSqlsession.getsqlsession();mapper sqlsession.getMapper(OperateMapper.class);mapper2 sqlsession.getMapper(AssetInformationMapper.class);}public Operate() {// 设置布局setLayout(new BorderLayout());JLabel title new JLabel(资产设备操作);title.setFont(Main.TitleFont);title.setHorizontalAlignment(SwingConstants.CENTER);add(title, BorderLayout.NORTH);// 设置tableObject[][] data getData();JTable table new JTable(data, AssetQuery.columnNames);table.setFont(Main.font);table.setRowHeight(30);table.getTableHeader().setFont(Main.font);// 添加到滚轴JScrollPane jScrollPane new JScrollPane(table);add(jScrollPane, BorderLayout.CENTER);// 添加底栏int hgap 30, vgap 5;JPanel bottomBar new JPanel();bottomBar.setLayout(new GridLayout(3, 1, hgap, vgap));// 上栏JPanel upper new JPanel();upper.setLayout(new GridLayout(1, 4, hgap, vgap));initUpper(upper);// 中栏JPanel middle new JPanel();middle.setLayout(new GridLayout(1, 4, hgap, vgap));initMiddle(middle);// 下栏JPanel down new JPanel();down.setLayout(new GridLayout(1, 1));JButton jButton new JButton(确定);jButton.addActionListener(new ActionListener() {Overridepublic void actionPerformed(ActionEvent e) {// 保存日志saveLog();// 修改资产updateAsset();JOptionPane.showMessageDialog(null, 操作成功);}});jButton.setFont(Main.font);down.add(jButton);bottomBar.add(upper);bottomBar.add(middle);bottomBar.add(down);add(bottomBar, BorderLayout.SOUTH);}/*** 修改资产*/private void updateAsset() {AssetInformation assetInformation new AssetInformation();assetInformation.setAssetNumber(Integer.valueOf(jTextField1.getText()));assetInformation.setStatus(getNumber((String) comboBox.getSelectedItem()));mapper2.update(assetInformation);sqlsession.commit();}/*** 修改日志*/private void saveLog() {AssetOperationLog operationLog new AssetOperationLog();// 设置资产idoperationLog.setAssetNumber(String.valueOf(jTextField1.getText()));// 设置操作人operationLog.setRecipient(jTextField2.getText());// 设置操作operationLog.setOperationType(getNumber((String) comboBox.getSelectedItem()));// 设置备注operationLog.setRemarks(jTextField3.getText());// 保存操作日志mapper.insert(operationLog);sqlsession.commit();}/*** 根据操作目的, 返回对应数值* param selectedItem* return*/private String getNumber(String selectedItem) {if (selectedItem.equals(领用)) {return 1;}else if (selectedItem.equals(归还)) {return 2;}else {return 3;}}/*** 初始化middle栏界面* param middle*/private void initMiddle(JPanel middle) {JLabel jLabel new JLabel(操作);jLabel.setFont(Main.font);middle.add(jLabel);comboBox new JComboBox();comboBox.setFont(Main.font);comboBox.addItem(领用);comboBox.addItem(归还);comboBox.addItem(报废);middle.add(comboBox);JLabel jLabel1 new JLabel(备注);jLabel1.setFont(Main.font);middle.add(jLabel1);jTextField3 new JTextField();middle.add(jTextField3);}/*** 初始化upper栏界面* param upper*/private void initUpper(JPanel upper) {JLabel jLabel new JLabel(资产编号);jLabel.setFont(Main.font);upper.add(jLabel);jTextField1 new JTextField();upper.add(jTextField1);JLabel jLabel1 new JLabel(操作人员编号);jLabel1.setFont(Main.font);upper.add(jLabel1);jTextField2 new JTextField();upper.add(jTextField2);}/*** 获取数据* return*/private Object[][] getData() {// 返回list数据ListAssetInformation list mapper2.list();Object[][] data new Object[list.size()][AssetQuery.columnNames.length];// 将list处理为二维数组, 赋值给datafor (int i 0; i list.size(); i) {// 将list[i] - assetInformation 变为数组Object[] res new Object[AssetQuery.columnNames.length];AssetInformation assetInformation list.get(i);res[0] assetInformation.getAssetNumber();res[1] assetInformation.getAssetName();res[2] assetInformation.getPrice();res[3] assetInformation.getPurchaseDate();res[4] assetInformation.getStatus();res[5] assetInformation.getRemarks();data[i] res;}return data;}
}
