Скачать или смотреть Employee Payroll Management System Using Java Netbeans-Part 16- Search Data from SQLite Database

In this tutorial you will learn how to search data from database and display int into JTextfields. This search is advanced and can be customized. Also you can search using the id, name etc.



Project Scope

This is an introduction of a simple Java Employee Payroll Management System (Payroll System) using SQLITE database that was developed using Java Netbeans. Furthermore the use of GUI components to achieve this project are as follows:

JButton,JTable,IText,JComboBox, JLabel,JRadioButton, JFrame,JPanel,Image Icons, JTextField.

Functions used
Add Record
Deleted Record
Update Record
Clear Fields
Login
Logout
Date & Time
PDF

Objective of Java Payroll Project Employee Management System.

The main objective of the Java Project on Payroll Management System is to manage the details of Employees, Payments, Salary. It also manages all information about the Employee, Payroll and Salary Slips. The project is totally built at administrator end of things. Only the administrator is guaranteed the access. The purpose of the project is to build an application that reduces the manual work and it can be used as a school project.

Functionalists provided by the Java Project on Employee Payroll Management System.

1- Provides search facility such as searching for Employees, Salaries and reports.
2- Tracks all salaries and employee payments.
3- Stores all information about employees to a secure Sql database.
4- Generates reports using iText.
5- Manages all information of Employees.
6- Simple GUI.
7- Editing, adding, deleting and updating records couldn't be easier.
8- Manages all information of employees salaries.
9- Uploading Pictures of Employees.
10- Audit Trail to monitor activities.
11- Manages all information of employee payslips.
12- Manages all information of employee allowance.
13- Manages all information of employee deduction.

Report generation.

1- It generates reports of all employees, Payments and salary slips.
2- You can easily export PDF for employee , Payroll, Payslips ,
Allowance and deduction records.
3. Save PDF to any location.


try{

String sql ="select * from Staff_information where id=? ";

pst=conn.prepareStatement(sql);
pst.setString(1,txt_search.getText());
rs=pst.executeQuery();

String add1 =rs.getString("id");
txt_id.setText(add1);

String add2 =rs.getString("first_name");
txt_firstname.setText(add2);

String add3 =rs.getString("surname");
txt_surname.setText(add3);

String add4 =rs.getString("Dob");
txt_dob.setText(add4);

String add5 =rs.getString("Email");
txt_email.setText(add5);

String add6 =rs.getString("Telephone");
txt_tel.setText(add6);

String add7 =rs.getString("Address");
txt_address.setText(add7);

String add8 =rs.getString("Department");
txt_dep.setText(add8);

String add10 =rs.getString("Salary");
txt_salary.setText(add10);

String add11 =rs.getString("Address2");
txt_add2.setText(add11);

String add12 =rs.getString("Apartment");
txt_apt.setText(add12);

String add13 =rs.getString("Post_code");
txt_pc.setText(add13);

String add14 =rs.getString("Status");
txt_status.setText(add14);

String add15 =rs.getString("Date_hired");
txt_doj.setText(add15);

String add16 =rs.getString("job_title");
txt_job.setText(add16);

String add17 =rs.getString("Designation");
txt_design.setText(add17);




byte[] image = rs.getBytes("Image");
ImageIcon imageIcon = new ImageIcon(new ImageIcon(image).getImage().getScaledInstance(img.getWidth(), img.getHeight(), Image.SCALE_SMOOTH));
img.setIcon(imageIcon);

}catch(Exception e){

}
finally {

try{

rs.close();
pst.close();

}
catch(Exception e){

}
}

How to search data java netbeans
Netbeans tutorials
search data from database netbeans

Download Files here: https://www.dropbox.com/s/ps6zvfz158y...

#java tutorial for beginners
#java tutorial
Thanks for watching.