1、Eclipse+Java+Swing 實現企業事管理系統、系統介紹本系統實現的功能：戶登錄、員信息的增刪改查、導出Execl、計算器、記事本、信息排序。采AES加密算法，數據庫使Mysql8.0.13，界良好。、系統展登錄頁主頁添加員信息修改員信息計算器記事本導出Execl三、系統實現AccountDao.javapackage;importimportimportimportTbPerson;importimportimportDataAccessException;BeanPropertyRowMapper;JdbcTemplate;import;public class AccountD

2、ao private static JdbcTemplate template =new JdbcTemplate(.getDataSource();public static ListTbAccountfindAllAccount() try String sql =select * from tb_account;ListTbAccounta =template.query(sql, new BeanPropertyRowMapperTbAccount(TbAccount.class);return a; catch (DataAccessException e) e.printStack

3、Trace();return null;public static String findAccountMoneyById(int i) try String sql =select * from tb_account where timecard_id=? ;TbAccount tbAccount =template.queryForObject(sql, new BeanPropertyRowMapperTbAccount(TbAccount.class),i);importimportimportimportimportpublic static ListTbDeptfindAllDep

4、t() String sql =select * from tb_dept;ListTbDepttbDept =template.query(sql, new BeanPropertyRowMapperTbDept(TbDept.class);return tbDept; catch (DataAccessException e) e.printStackTrace();return null;public static int findDeptIdByName(String item) String sql =select * from tb_dept where name=? ;TbDep

5、t dept =template.queryForObject(sql, new BeanPropertyRowMapperTbDept(TbDept.class), item);public static ListTbDeptfindAllDeptExceptZero() try String sql =select * from tb_dept where id0 ;ListTbDepttbDept =template.query(sql, new BeanPropertyRowMapperTbDept(TbDept.class);return tbDept; catch (DataAcc

6、essException e) e.printStackTrace();return null;public static TbDept findDeptByName(String name) try String sql =select * from tb_dept where name=? ;public static void addDept(TbDept d2) try String sql =insert into tb_dept(name) values (?) ;template.update(sql, d2.getName(); catch (DataAccessExcepti

7、on e) e.printStackTrace();public static void deleteDeptById(int id) package;importimportList;TbPerson;importimportimportDataAccessException;BeanPropertyRowMapper;JdbcTemplate;importimport;PwEncryption;public class PersonDao private static JdbcTemplate template =new JdbcTemplate(.getDataSource();publ

8、ic static TbPerson queryRecordByNum(String num) try String sql =select * from tb_person where record_number=? ;TbPerson tbRecord =template.queryForObject(sql, new BeanPropertyRowMapperTbPerson(TbPerson.class), num);return tbRecord; catch (DataAccessException e) e.printStackTrace();public static TbPe

9、rson findPersonByRecordNumber(String recordNumber) try String sql =select * from tb_person where record_number=? ;TbPerson tbPerson =template.queryForObject(sql, new BeanPropertyRowMapperTbPerson(TbPerson.class),recordNumber);return tbPerson; catch (DataAccessException e) System.out.println(查找員為空數據

10、);e.printStackTrace();return null;public static void updatePerson(TbPerson person) try catch (Exception e) e.printStackTrace();public static void updatePersonPassword(TbPerson person) try String sql =update tb_person set password = ? where record_number= ? ;template.update(sql, person.getPassword(),

11、 person.getRecordNumber(); catch (Exception e) e.printStackTrace();public static ListTbPersonlikePersonByName(String name) try String sql =select * from tb_person where name like % ? % ;ListTbPersontbPerson =template.query(sql, new BeanPropertyRowMapperTbPerson(TbPerson.class), name);return tbPerson

12、; catch (DataAccessException e) e.printStackTrace();return null;public static void main(String args) String userName =T00001;String password =123456;TbPerson person =new TbPerson(userName, PwEncryption.encrypt(password, key);login(person);importimportimportimportimportimportimport/* Druid連接池具類,將來dao

13、層調*/private static DataSource dataSource; / 定義成員變量DataSource/ 獲取DataSource/*獲取連接*/public static Connection getConnection() throws SQLException return dataSource.getConnection();/*釋放資源*/public static void close(Statement statement, Connection connection) close(null, statement, connection);public stat

14、ic void close(ResultSet resultSet, Statement statement, Connection connection) if (resultSet != null) try resultSet.close(); catch (SQLException e) e.printStackTrace();if (statement != null) try statement.close(); catch (SQLException e) e.printStackTrace();connection.close();/ 歸還連接/*/;importimportim

15、portimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportimportJFrame;JLabel;EmptyBorder;SwingConstants;importimportTbPerson;BeautyEyeLNFHelper;importimportimportimportTxtExport;/*登陸窗體類，為戶第窗體* author 22219*/public class LoginFrame extends

16、JFrame /*串版本標識serialVersionUID*/private JPanel contentPane;public static JTextField userNameTxt;private JPasswordField passwordTxt;public static String time;/*/*/setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);lblNewLabel_2.setIcon(new ImageIcon(LoginFrame.class.getResource(/images/password.png);user

17、NameTxt =new JTextField();passwordTxt =new JPasswordField(););this.addWindowListener(new WindowAdapter() / bg-this.getContentPane().add(lbBg);/ bg-TimerTask task =new TimerTask() public void run() String sdate =(new SimpleDateFormat(yyyy-MM-dd HH:mm:ss).format(new Date();timeLabel.setText(sdate);Tim

18、er t =new Timer();/* param e*/private void loginActionPerformed(ActionEvent e) / 導出登陸志（戶id+時間）TxtExport.writeTxtFile(Id +userNameTxt.getText() +t +time);/*重置事件處理* param e*/this.passwordTxt.setText();userNameTxt.requestFocus();/*注冊事件處理* param e*/private void enrollValueActionPerformed(ActionEvent e) String str =JOptionPane.showInputDialog(this, , , 2);TbPerson p =PersonDao.fi