Employee Payroll Management System Using Java Netbeans-Part 18-Update Data In SQLite Database смотреть онлайн

In this tutorial you will learn how to update or edit records in SQLite database.


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 value1 = txt_firstname.getText();
String value2 = txt_surname.getText();
String value3 = txt_dob.getText();
String value4 = txt_id.getText();
String value5 = txt_email.getText();
String value6 = txt_tel.getText();
String value7 = txt_address.getText();
String value8 = txt_dep.getText();
String value9 = txt_add2.getText();
String value10 = txt_apt.getText();
String value11 = txt_pc.getText();
String value12 = txt_design.getText();
String value13 = txt_status.getText();
String value14 = txt_salary.getText();
String value15 = txt_job.getText();
String value16 = txt_doj.getText();

String sql= "update Staff_information set id='"+value4+"',first_name='"+value1+"', surname='"+value2+"', "
+ "Dob='"+value3+"',Email='"+value5+"',Telephone='"+value6+"',"
+ "Address='"+value7+"',Department='"+value8+"', Address2 = '"+value9+"', "
+ "Apartment = '"+value10+"', Post_code ='"+value11+"', "
+ "Designation ='"+value12+"', Status ='"+value13+"', Salary ='"+value14+"', job_title ='"+value15+"', Date_Hired ='"+value16+"' "
+ " where id='"+value4+"' ";

pst=conn.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(null, "Record Updated");

}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}finally {

try{
rs.close();
pst.close();

}
catch(Exception e){

}
}



Download Files here: https://www.dropbox.com/s/ps6zvfz158yqtvp/Employee%20Payroll.rar?dl=0

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