Azeem Rathore

This is how i am handling 5 text field search

first it checks if all the textbox contain values then just get the values and make sql
string sql = select * from table where Employee Name = Textbox1 value and Employee mobile no= 2nd textbox value and so on

2: Rule of thumb is atleast one textfield value should be given if there is empty textfield leave those textfields and those who contain values pick up those values and make sql statement

After this programming my next task is to do full internal site search , i have checked Lucene and download it documentation from apache lucene website i will consider it this

Thanks alot for the help .

ok thanks i am some how able to manage this as it is only one table now

i have one other functionality to perform which is whole software internal search if a user just enter any text in text box . and it search it from whole application?

hello my first language is German so bear with my English
I am new to java language , and working on Human resource Management system , current i cant make logic of search programming , actually i want to search the employees by their personal info
so i have 5 text box
Employee Name:
Employee mobile no:
Employee Father Name:
Employee Social Security Number
Employee Address:

these are the text boxes now i want to search from employee table. All information of employees are in one table which is called Tbl_Employees.
now i am confused how to do it ? Requirement is Any field can be empty it is not necessary all 5 boxes should contain values
so kindly tell me how to handle this if a user only give social security number and rest all fields are empty then what to do ? if user fill two or more textbox then what should i do ?
any tutorial/article related to this will be helpful please

Ulf Dittmer Thanks for the reply
but i also have heard if i start work in framework it will also cover servlets and jsp isnt it true?

Hi my first Language is German so bear my English
I am 4th Semester student i worked in Java desktop application i made Human resource Management System but it was Desktop Application now i want to make it as web based application . I study in difference forums about java frameworks hibernate struts spring etc i have GOOD understanding of HTML and basic understanding of CSS and javascript now i am confuse which i should learn first i consider myself as beginner in web application
now please guide me which framework is easily start from scratch? i hope i make you understand what i want basically i want something easier to learn in initial level to have solid grip on how to make web applications then i will move to advanced level
so please tell me how to start ?

Hi Ranganathan
thanks for the help i have changed all the variables from int to Integer now when i press add record button it giives me error message ORA-01722: invalid number
i have search internet about this issue they say this errors occurs when we convert strings into Integer so i assume i have same old issue i am passing null to integer this is why error occurs i am assuming this may be i am wrong
please help and thanks again

Regards

i am just beginner may be i am handling this thing wrong so guide me please

Actually i have columns in database table which can be empty if insert data and types are varchar and integers
I have made employee class and defines few integer variables an make setters getters
Reason i am using integer.parseint is
When i take values from textfield and send to integer setter it gives error like required int found string
So i use im using integer.parseInt function
Example is
employee d = new employee(); // employee is class and Empcode is variable and it type is int d.setEmpCode(jtextfield1.getText()); // it does not work because textfield give string so it gives me error require int found string so i use Integer.parseInt d.setEmpCode(Integer.ParseInt(jtextfield1.getTex()) // this does not gives error
So what i want is when adding new record if i left any field empty and press add new record button it should set values to null or empty and add record
this is whati am doing to handle this
if (jtextField.getText().isEmpty()) { d.setEmpCode(Integer.ParseInt(null));// if i use d.setEmpCode(null) then still it gives error so i use Integer.parseInt }
Hope i make you understand
Please help
Regards

hi I AM NEW to programming
i have form which contains 103 textfields and it is filled from database values
now i want to insert the new record when user press new button all field become empty
when i enter data in the textfields and press save button it gives me this exception

Aug 01, 2013 11:42:14 PM hr.forms.df jButton7ActionPerformed
SEVERE: null
java.lang.NumberFormatException: null
at java.lang.Integer.parseInt(Integer.java:454)
at java.lang.Integer.parseInt(Integer.java:527)
at hr.forms.df.NewEmployees(df.java:2846)
at hr.forms.df.jButton7ActionPerformed(df.java:2768)
at hr.forms.df.access$600(df.java:25)
at hr.forms.df$7.actionPerformed(df.java:2296)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3321)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:729)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:688)
at java.awt.EventQueue$3.run(EventQueue.java:686)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:702)
at java.awt.EventQueue$4.run(EventQueue.java:700)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:699)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

the text field could be pempty i have made check if textfield.gettext is empty the set null and insert null
please tell me how to cope with this and tell me what is actual issue how to solve it
regards

Hi my first language is German so bear with my English
i am new to programming and i have form which display Employee tables values in the text field from database. it has a colum date of birth of type Date.
When load program form display all values successfully in the textfield now i have made function update using update query . all other values updated successfully but date objects arent updated when i try to update date objects from the text field and hit save button it give" exception java sql Exception non numeric value appeared where numeric expected" message i do not know how to handle it
i get the date value from textfield from employee form and set this value to employees class

here is the code from employee formemployee d=new employee(); // instance of employee class SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy"); Date convertedDate = dateFormat.parse(jTextField9.getText());// retrieve value form employee form class and convert it to date because textfield does not save date value it is not compatible d.setDateOfBirth(convertedDate);

then i have made the update_employee function code is this

query = "UPDATE hr_employees SET" + " EMP_CODE="+ "'" +getEmpCode() + "',OLD_EMP_CODE= '" + getOldEmpCode() + "'," + " CARD_NO="+ "'" +getCardNo() + "',EMP_NAME= '" + getEmpName() + "'," + " FATHER_NAME="+ "'" +getFatherName() + "',GENDER= '" + getGender() + "'," + " EMAIL="+ "'" +getEmail() + "',EXTENSION= '" + getExtension() + "'," [color=red] + "[b] DATE_OF_BIRTH="+ "'" +getDateOfBirth()[/b][/color] + "',MARITAL_STATUS= '" + getMaritalStatus() + "'," + " HUSBAND_NAME="+ "'" +getHusbandName() + "',NEW_NIC_NO= '" + getNewNicNo() + "'," + " FAMILY_CODE="+ "'" +getFamilyCode() + "',OLD_NIC_NO= '" + getOldNicNo() + "'," + " hight="+ "'" +getHight() + "',BLOOD_GROUP= '" + getBloodGroup() + "'," + " ID_MARK="+ "'" +getIdMark() + "',PRESENT_ADDRESS= '" + getPresentAddress() + "'," + " PHONE_RES="+ "'" +getPhoneRes() + "',MOBILE= '" + getMobileNumber() + "'," + " OTHER_PHONES="+ "'" +getOtherPhones() + "',PERMANENT_ADDRESS= '" + getPermanentAddress() + "'" +" WHERE EMP_CODE= '" + getEmpCode() + "'";

how to update date of birth? kindly help please

Thanks alot ramesh , it is working as i want thanks alot

Hi ramesh thanks for the reply but i do not know how to Override windowClosing(...) method in Department form can you please tell me this? i have done everything except lnserting parent.setVisible(true);
can you tell me where i do this ? and how to do this?
thanks

Yes , menu screen is jframe and in the jframe i am using menu bar when i run the program And click on departments from menu new department form open
One approach is add exit button in all forms so when click on exit i show menu screen but this is not my teacher want he said on exit department form menu screen appear
Netbeans. Generated code which is uneditAble and i know from properties panel i can change on exit property but
It it for departments form how to display menu screen? When exit the department form?

hi i am new to programming and learning java and my first language is not English to hope you can understand my problem
i am working on human resource Management system
i have 6 forms which contain different information from database now i am making menu screen i have added menu bar and in the menu bar items are Departments, hr Units , Employees and so on
now i want is when user select departments it hide the menu screen and display display form i am able to do this successfully now i want to go back to previous menu screen when user close the department window
i am using netbeans so it is not allowing me to change the INITCOmponents function used in the forms constructor to change it
so please help me how to do this .

Thanks alot brother it is solved now you saved meeeeeeeeeeeee
many many thanks