Enterprise Personnel Management System project collecting gold

Well, today finally took 3 weeks to finish the personnel Management system, and then also completed the reply, the tutor for my work should be more satisfactory, I think he might still be a little surprised me, because I added a lot of his expected features (although there is no ghost use). Thank my teammates for their support and trust, this is my first complete development of a Java project, the feeling is still relatively deep. This way came to really have a sad laugh, is really appreciate the feeling of doing the project.

When I first picked up the project, I felt that I was very arrogant, and then the tutor a sneer, because in my eyes, I think this is not a personnel management system, small case! Until later I found that, God, it's so hard! Ah, some features really look simple to do or is quite complex, first of all their own logical thinking to clear, the beginning of that Cho is not know how to start, I do for the project leader, bear the responsibility of the whole group, the pressure is suddenly big, this feeling is and I was a person self-study time is completely different.

Project Hand, I arrange division of labor in fact is committed a lot of misunderstanding, such as a person to do database, a person to write interface, there is I write the whole structure, because I have not done similar things ah, architecture this thing is what ghost Oh, we all the way down really is stones, on the one hand, the database did not finish, Interface nature is not good to write, and then do the database part of the words do not know what to write, so the whole process is basically messy, I admit this place is really not arranged properly, so that 3 days later, the database is not written out, the interface can not be drawn out. This time my mind suddenly floated out of the word "All night long", I just want to say, I only work overtime to 2 o'clock in the morning, resolutely not overnight oh, because our project is not so urgent, so to ensure a good rest to better play a role.

Later, I finished the project structure, this is the primary version, there are still a lot of problems, and I am directly using SVN to do code management, in the interim project delivery of 3 days, I every afternoon and the project team of a girl to the computer room overtime to do projects, it seems a little tired, really, When the implementation of a function is really very happy, until the mid-term review, my whole project is almost all of the function of adding and removing, there is the project integration of the time there are some problems, such as the team to change my entire framework, so annoyed you know, the main reason is that there are 3 hours to review, I am very excited. Of course, we finally found that the added usefulness is quite large, and later on I have done a lot of this kind of processing.

I think my main code is the following paragraph, tangled up for a long time to write, maybe you will look relatively simple, really for me this small white, the inside added 6 loops is very difficult, our entire project is basically in and SQL deal with, is always 5, 6 table connection query, I think that through this project my connection query is still good, there are some data analysis part. Tutors recommend our group is able to do the data analysis direction.

<span style= "FONT-SIZE:14PX;" >//Comprehensive Query Btnnewbutton.addselectionlistener (new Selectionadapter () {@Overridepublic void widgetselected ( Selectionevent e) {String year = Combo.gettext (). toString (). Trim (); String season = Combo_2.gettext (). toString (). Trim (); String month = Combo_3.gettext (). toString (). Trim (); String dname = Combo_1.gettext (). toString (). Trim (); list<object> params = new arraylist<object> (); String sql = "Select E.eid,e.name as ename,e.sex,d.name as dname,j.name as Jname,w.wmoney," + "extract (year from Gaintime)    Year, ' + ' extract (month from gaintime) month ' + ' from EMP e-Join Dept D on E.did=d.did join job J on J.jid=e.jid Join Welfare W on W.eid=e.eid "+" LEFT join RM on Rm.eid=e.eid "+" GROUP by E.eid,e.name, E.sex,d.name, J.name, W.WM  Oney, "+" extract (year from Gaintime), extract (month from gaintime) have 1=1 "; if (Year.equals (" All ")) {SQL + =" ";} else if (year! = NULL &&! "". Equals (year)) {SQL + = "and extract (year from gaintime) =? ";p Arams.add (year);} if (Month.equals ("All")) {SQL + = "";} else if (month! = NULL &&! "". Equals (month)) {SQL + = "and extract (month from gaintime) =?"; Params.add (month);} if (Season.equals ("All")) {SQL + = "";} else if (season.equals ("first")) {SQL + = "and extract (month from gaintime) between 1 and 3";} else if (season.equals ("second")) {SQL + = "and extract (month from gaintime) between 4 and 6";} else if (Season.equals ("third")) {SQL + = "and extract (month from gaintime) between 7 and 9";} else if (season.equals ("IV")) {SQL + = "and extract (month from gaintime) between and 12";} if (Dname.equals ("All")) {SQL + = "";} else if (dname! = NULL &&! "". Equals (dname)) {SQL + = "and d.name=?"; Params.add (dname);} DBHelper db = new DBHelper (); Table.removeall (); list<map<string, object>> list = Db.find (sql.tostring (), params); int Summoney = 0;   The total wage number for the query is int tol = 0; Total personal wage Tableitem ti = null; string[] str = null;if (list! = null && list.size () > 0) {foR (map<string, object> data:list) {ti = new Tableitem (table, SWT. None); String eid2 = (string) data.get ("EID"); String ename2 = (string) data.get ("ename"); String sex2 = (string) data.get ("SEX"); String dname2 = (string) data.get ("Dname"); String wmoney2 = (string) data.get ("Wmoney"), int month2 = Integer.parseint ((string) data.get ("MONTH")); String gaintime = (string) data.get ("year") + "Years" + Data.get ("month") + "moon"; int rmoney = 0, rmoney1 = 0;  Reward, Penalty int smoney2 = 0;     base salary int month3=0; The month of the loop string jname2=null; String sql4= "Select Extract (month from ajtime) as Month3 from adjust where eid= '" +eid2+ "'"; list<map<string, object>> list5 = Db.find (SQL4, null); for (map<string, object> map:list5) {Month3=int Eger.parseint (String) map.get ("MONTH3");} if (month2>=month3) {String sql5= "select Smoney,j.name from emp E, salary S, adjust a, job J where E.jid=s.jid and A. Eid=e.eid and E.jid=j.jid and e.eid= ' "+eid2+" ' "; List<map<string, object>> List6 = Db.find (SQL5, null); for (map<string, object> map:list6) {Smoney2 = Integer.parseint ((String) map.get ("Smoney")) ; jname2= (String) map.get ("NAME");}} Else{string sql6= "Select Smoney,j.name from Job J, salary s where J.jid=s.jid and j.name= ' intern '"; list<map<string, object>> list7 = Db.find (sql6, null); for (map<string, object> map:list7) {Smoney2 = I Nteger.parseint (String) map.get ("Smoney"); jname2= (String) map.get ("NAME");}} String sql3 = "Select Type,rmoney from RM where eid= '" + eid2+ "" + "and extract (month from gaintime) = '" + month2 + "'"; String type = null; list<map<string, object>> list3 = Db.find (SQL3, null); for (map<string, object> map:list3) {type = (Str ing) map.get ("TYPE"), if (Type.equals ("reward")) {Rmoney + = Integer.parseint ((String) map.get ("Rmoney"));} else {rmoney1-= Integer.parseint (String) map.get ("Rmoney");}} Tol = Rmoney + rmoney1 + smoney2+ integer.parseint ((String) data.get ("Wmoney")); str = new string[] {eid2, ename2,Sex2, Dname2,jname2, string.valueof (Smoney2), wmoney2,string.valueof (Rmoney), string.valueof (Rmoney1), Gaintime, String.valueof (TOL)};ti.settext (str); Summoney + = tol;}} Text.settext (Summoney + "");}); </span>

other words, I just added a feature of the mail, generated dynamic QR code tag, Excel data import and export, chat (group chat + robot), histogram function.

The whole project down, there are tangled melancholy, and even there is some functional modules do not come out I want to cancel, of course, I did not give up, or do out, really thank myself! Team members sometimes throw a lot of strange code, and then also to take over the changes, the system problem has to check the bug, a variety of debug, but the whole project group learning atmosphere, every time will go to study, to solve, although the final part of my solution, but thank you all the way to have you, Without you I guess I am not confident to finish this project, the whole process tired and happy, thank you when I want to give up when you say to me, "did so long things suddenly canceled, I do not," and then I want to do all kinds of ways to make, I have served myself. My biggest feeling is "there is nothing in the world can not be done", initially found it difficult to do something that is actually very simple. I hope that in the future I can improve management methods, comprehensive analysis, comprehensive grasp, coordination division, in-depth study! Progress together!

Thank you all the way to have you, the future hope to grow together! May the great gods of the road also work smoothly!

Enterprise Personnel Management System project collecting gold