Java Personnel Management System source code---Graduation Internship (database file added)

Original:Java Personnel Management System source code---Graduation Internship (database file added)

Source code: Http://www.zuidaima.com/share/1550463722998784.htm

Using the MVC pattern to write Personnel Management system, my graduation internship, today check, open source today

Project

Java Build Path

Project Facets

Hr.sql

/*mysql Data transfersource host:localhostsource database:hrtarget host:localhosttarget DATABASE:HRDATE:2013/9/9 Monday 9:20:54*/set foreign_key_checks=0;--------------------------------Table structure for administrator--------------- ---------------CREATE TABLE ' Administrator ' (' admin_id ' int () not NULL auto_increment, ' admin_password ' varchar () d  Efault null, ' admin_username ' varchar (default NULL, PRIMARY KEY (' admin_id ')) Engine=innodb default charset=utf8;-- ------------------------------table structure for staff------------------------------CREATE table ' staff ' (' p_id ' int (one) not null auto_increment, ' p_name ' varchar () default null, ' Sex ' varchar (5) default NULL, ' degree ' varchar (a) de Fault null, ' Department ' varchar (default null), ' position ' varchar default NULL, ' state ' varchar default NUL  L, ' user_name ' varchar default NULL, ' user_password ' varchar (default NULL, PRIMARY KEY (' p_id ')) Engine=innodb DEFAULT Charset=utf8;--------------------------------table structure for staffagreement------------------------------CREATE table ' Staffagreement ' (' agreement_id ' int (one) not null auto_increment, ' p_id ' int (one) default NULL, ' Agreement_btime ' varcha R () default NULL, ' agreement_etime ' varchar (default null, ' position ' varchar) default NULL, ' Agreement_content ' varchar ' default NULL, PRIMARY key (' agreement_id '), key ' Fk_relationship_4 ' (' p_id '), CONSTRAINT ' Fk_relationsh Ip_4 ' FOREIGN KEY (' p_id ') REFERENCES ' staff ' (' p_id ')) Engine=innodb DEFAULT Charset=utf8;----------------------------  ----table structure for staffalter------------------------------CREATE table ' staffalter ' (' alter_id ' int (one-by-one) not NULL   Auto_increment, ' p_id ' int (one) default null, ' p_name ' varchar (default null), ' alter_time ' varchar (default null), ' alter_bstate ' varchar default NULL, ' alter_estate ' varchar default NULL, ' alter_type ' varchar ' default NUL L, ' alter_content ' varchar (+) Default NULL, PRIMARY key (' alter_id '), key ' Fk_relationship_5 ' (' p_id '), CONSTRAINT ' Fk_relationship_5 ' FOREIGN key (' p_id ') R Eferences ' staff ' (' p_id ')) Engine=innodb DEFAULT Charset=utf8,--------------------------------Table structure for Staffcert------------------------------CREATE TABLE ' Staffcert ' (' cer_id ' int (one) not NULL auto_increment, ' grade_id ' int (one) default null, ' cer_name ' varchar (default null, ' cer_date ' varchar) default NULL, PRIMARY KEY (' cer_id ') , Key ' fk_relationship_10 ' (' grade_id '), CONSTRAINT ' fk_relationship_10 ' FOREIGN KEY (' grade_id ') REFERENCES ' Traingrade ' (' grade_id ') engine=innodb DEFAULT Charset=utf8;--------------------------------Table structure for stafffile----- -------------------------CREATE TABLE ' stafffile ' (' file_id ' int (one) not NULL auto_increment, ' p_id ' int (one) ' Default NU  LL, ' file_name ' varchar default NULL, ' file_abstract ' varchar (+) default NULL, ' Reward_note ' varchar ($) Default NULL, ' experience ' varchar (500) Default NULL, PRIMARY key (' file_id '), key ' Fk_relationship_6 ' (' p_id '), CONSTRAINT ' fk_relationship_6 ' FOREIGN key (' p_id ') REFERENCES ' staff ' (' p_id ')) Engine=innodb DEFAULT Charset=utf8,--------------------------------Table structure for  Train------------------------------CREATE TABLE ' train ' (' train_name ' varchar) default NULL, ' train_id ' int (one) not Null auto_increment, ' type_code ' varchar (default null, ' train_btime ' varchar) default NULL, ' Train_etime ' Varch AR () default null, ' train_expense ' varchar (default null, ' train_location ' varchar) default NULL, ' Train_host ' varchar () default NULL, ' train_master ' varchar (default null), PRIMARY key (' train_id '), key ' Fk_relationship_9 ' ( ' Type_code '), CONSTRAINT ' Fk_relationship_9 ' FOREIGN KEY (' Type_code ') REFERENCES ' traintype ' (' Type_code ')) engine= InnoDB DEFAULT Charset=utf8;--------------------------------Table structure for Traingrade------------------------- -----CREATE TABLE ' TraingraDe ' (' grade_id ' int (one) not null auto_increment, ' train_id ' int (one) not null, ' p_id ' int (one) not NULL, ' Grade ' Int (11  Default NULL, ' subject ' varchar (default null, ' get_cer ' varchar) default NULL, PRIMARY key (' grade_id '), key  ' Fk_relationship_7 ' (' p_id '), key ' Fk_relationship_8 ' (' train_id '), CONSTRAINT ' fk_relationship_7 ' FOREIGN KEY (' p_id ') REFERENCES ' staff ' (' p_id '), CONSTRAINT ' Fk_relationship_8 ' FOREIGN KEY (' train_id ') REFERENCES ' train ' (' train_id ')) EN Gine=innodb DEFAULT Charset=utf8;--------------------------------Table structure for traintype---------------------  ---------CREATE TABLE ' traintype ' (' type_name ' varchar) default NULL, ' Type_code ' varchar (not NULL, ' Type_info ') varchar ($) Default NULL, PRIMARY KEY (' Type_code ')) engine=innodb default Charset=utf8;----------------------------- ---Records------------------------------insert INTO ' Administrator ' VALUES (' 1 ', ' 1234 ', ' James '); Insert to ' staff ' V Alues (' 1 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO ' staff ' VALUES (' 2 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);  To ' staff ' values (' 3 ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, nulls), INSERT into ' staff ' values (' + ', ' sdas ', ' Dsada ',  ' Dsadas ', ' dasda ', ' dasda ', ' dasd ', ' dsadasd ', ' dasdasd '); INSERT into ' staff ' VALUES (' ", ' qq ', ', ', ', ', ', ', ', ', INSERT INTO ' staff ' values (' + ', ' ', ' ', ', ', ', ', ', ', ', '), insert INTO ' staff ' values (' 19 ', ', ', ', ', ')  ', ', ', ', '), insert INTO ' staff ' values (' a ', ' ', ' ', ' ', ' ', ' ', ', ', ', '), insert INTO ' staff ' values (' 21 ', ', ', ', ', ', ', ', ', ', '), insert INTO ' staff ' values (' ", ', ', ', ', ', ', ', ', '); insert into ' staff ' values (' 23 ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ', ' and ' ' Staff ' VALUES (' + ', ' ', ' ', ' ', ' ', ' ', ', ', '); insert INTO ' staff ' V Alues (' A ', ' ', ' ', ', ', ', ', ', ', ', ', '), insert INTO ' staff ' VALUES (' A ', ' ', ' ', ' a ', ' ', ' x ', ' ', ' a ', '); Insert I NTO ' Staff ' VALUES (' 48 ', ' A ', ' abc ', ' abc ', ' abc ', ' Xbc ', ' abc ', ' abc ', ' A '); INSERT into ' staff ' VALUES (' zhaoxin ', ' Male ', ' asd ', ' DASD ',  ' Dada ', ' Dad ', ' Dad ', ' Dada '), insert INTO ' staffagreement ' VALUES (' 1 ', ' + ', ' dsadas ', ' Dasds ', ' dasda ', ' Dasdad '); insert Into ' staffalter ' values (' + ', ' + ', ' 1 ', ' SDA ', ' DSA ', ' DSA ', ' Dsad ', ' Dsad '); INSERT into ' staffalter ' values (' 22 ', ' 1 4 ', ' SDAs ', ' SD ', ', ', ', ', ', ', ' insert INTO ' staffalter ' VALUES (' ' ', ' ' ', ' ', ' ', ' ', ' ', ', '); insert INTO ' Staffa Lter ' VALUES (' + ', ' + ', ' ', ' ', ', ', ', ', ', ', '), INSERT into ' staffalter ' values (' + ', ' + ', ', ', ', ', ', '); INS ERT into ' staffalter ' VALUES (' + ', ' + ', ' SW ', ' AAAAAQQQQQZZZZZDDDDX ', ' SW ', ' DSW ', ' SW ', ' SW '); INSERT into ' staffalter ' VALUES (' + ', ' + ', ' ', ' ', ' ', ' ', ', ', ', ', ', '); INSERT into ' staffalter ' values (' + ', ' + ', ', ' sa ', ' ', ', ' sa ', '); inser T into ' staffalter ' values (' + ', ' + ', ' ', ' sa ', ' ', ' ', ' sa ', ') '; INSERT into ' staffalter ' values (' 32 ', ' 14 ', ', ', ') ', ', ', '); INSERT inTo ' Staffalter ' values (' + ', ' + ', ' ', ' ', ' ', ' ', ' ', ', ', ', '), INSERT into ' staffalter ' values (' + ', ' + ', ' sa ', ' sa ', ' sa ', ' sa ', ' sa ', ' sa '); insert INTO ' staffalter ' values (' + ', ' + ', ' + ', ' ', ' ', ' ', ', '); insert INTO ' staffalter ' values (' + ', ' + ', ' sasa ', ' sa ', ' sa ', ' sa ', ' sa ', ' sa '); INSERT into ' Staffalter ' VALUES (' PNs ', ' ' ', ' wq ', ' Wq ', ' Wq ', ' Wq ', ' W Q ', '); insert INTO ' staffalter ' values (' + ', ' + ', ' sa ', ' sa ', ' sa ', ' sa ', ' sa ', ' sa '); insert INTO ' staffalter ' values ( ' n ', ' + ', ', ', ', ', ', ', ', ', ', ' insert INTO ' staffalter ' VALUES (' + ', ' + ', ' 2 ', ', ', ', '); INSERT INTO ' sta Ffalter ' VALUES (' + ', ' + ', ' ', ' ', ' ', ' ', ', ', ', ') ', ' INSERT into ' staffalter ' values (' ' ' ', ' ' ' sa ', ' Sasa ', ' sa ', ' sa ') , ' sa ', ' sa '); insert INTO ' Staffalter ' VALUES (' + ', ' + ', ' a ', ' fdsfsfsdf ', ' fdsfdsf ', ' fsdfd ', ' fsdf ', ' fdsf '); Insert in To ' Staffalter ' values (' + ', ' + ', ' a ', ' fdsfsfsdf ', ' fdsfdsf ', ' fsdfd ', ' fsdf ', ' fdsf '); INSERT into ' staffalter ' values (' A ', ' + ', ' a ', ' sa ',' sa ', ' sa ', ' sa ', ' sa '); insert INTO ' Staffalter ' VALUES (' + ', ' + ', ' a ', ' Dazui ', ' dz ', ' dz ', ' dzd ', ' dz '); insert INTO ' s Taffcert ' VALUES (' 4 ', ' 3 ', ' + ', ' 333 '); insert INTO ' Staffcert ' values (' 5 ', ' 6 ', ' 6 ', ' 20136 '); insert INTO ' Staffcert ' V Alues (' 6 ', ' 1 ', ' 1 ', ' 1 '); insert INTO ' Staffcert ' values (' 7 ', ' 3 ', ' 3 ', ' 3 '); insert INTO ' Staffcert ' values (' 8 ', ' 3 ', ' 4 ', ' 3 '); insert INTO ' stafffile ' values (' 1 ', ' + ', ' da ', ' dasdd ', ' dada ', ' saddasd '); insert into ' train ' values (' 0.0 ', ' 2 ', ' 444 ', ' 0.0 ', ' 0.0 ', ' 0.0 ', ' 0.0 ', ' 0.0 ', ' 0.0 '); INSERT into ' Train ' VALUES (' James ', ' 3 ', ' 233 ', ' James ', ' James ', ' J Ames ', ' James ', ' James ', null); INSERT into ' Train ' VALUES (' name ', ' 7 ', ' 233 ', ' btime ', ' etime ', ' expense ', ' location ', ' H OST ', null); INSERT INTO ' traingrade ' values (' 1 ', ' 2 ', ' 1 ', NULL, NULL, ' Yes ') and insert INTO ' traingrade ' values (' 3 ', ' 2 ', ' 1 ', NULL, NULL, ' yes '), insert INTO ' traingrade ' values (' 6 ', ' 7 ', ' 2 ', ' 8 ', ' 8 ', ' yes ') and insert INTO ' traingrade ' values ( ' 8 ', ' 7 ', ' 1 ', ' + ', ' ZHangjiaxi ', ' No '); insert INTO ' traintype ' values (' 222 ', ' 233 ', ' 0.0.0.0 '); insert INTO ' traintype ' values (' 323 ', ' 444 ', ' 4324 '); INSERT into ' Traintype ' VALUES (' 1231 ', ' Dsada ', ' 32131 ');--------------------------------Trigger structure for Addcert------------------------------DELIMITER;; CREATE TRIGGER ' Addcert ' after INSERT on ' Staffcert ' for each ROW update traingrade set get_cer = "Yes" where traingrade.gr ade_id = new.grade_id;;D Elimiter,--------------------------------Trigger structure for deleinfo------------------------------DELIMITER; CREATE TRIGGER ' Deleinfo ' after DELETE on ' Staffcert ' for each ROW update traingrade set get_cer= "No" where Traingrade. grade_id not in (select grade_id from Staffcert);;D Elimiter;

Java Personnel Management System source code---Graduation Internship (joined database file)