Notes and references
3. RESULTS
}
/////Function for Getting the List////////////
public String getStatusOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("status","status_id","status_name","status_id,status_name",sel ectedID,"1");
}
/////Function for Getting the List////////////
public String getDepartmentOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("department","dept_id","dept_name","dept_id,dept_name",sel ectedID,"1");
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllEmployee() {
(64)
Project Report of Computer Shop Management System
int count=0;
String error = "";
ArrayList resultArray = new ArrayList();
try {
String SQL = "SELECT * FROM employee" ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
HashMap results = new HashMap();
results.put("employee_id",rs.getString("employee_id"));
Project Report of Computer Shop Management System
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
(66)
Project Report of Computer Shop Management System
return resultArray;
}
public String getDepartment(int dept_id) {
HashMap results = new HashMap();
String SQL = "";
String value = "";
int count=0;
try {
SQL = "SELECT dept_name FROM department WHERE dept_id = "+dept_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
value = rs.getString("dept_name");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
(67)
Project Report of Computer Shop Management System
return value;
}
public String getStatus(int status_id) {
HashMap results = new HashMap();
String SQL = "";
String value = "";
int count=0;
try {
SQL = "SELECT status_name FROM status WHERE status_id = "+status_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
value = rs.getString("status_name");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
(68)
Project Report of Computer Shop Management System
return value;
} }
(69)
Project Report of Computer Shop Management System
Code for Login.javapackage Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Login extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Login() {
Connect.connect_mysql();
}
//////////////////Function for Update the airport////////////////////////
public boolean changePassword(String old_password,String new_password, int login_id)
{
String SQL;
int count = 0;
try
(70)
Project Report of Computer Shop Management System
{
SQL = "SELECT * FROM login WHERE login_password = '"+old_password+"' AND login_id = "+login_id ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) count++;
if(count==1) {
SQL = "UPDATE login SET login_password=? WHERE login_id=?";
int record=0;
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,new_password);
pstmt.setInt(2,1);
record = pstmt.executeUpdate();
pstmt.close();
System.out.println(" Error : "+ e.toString());
}
if(count==0)
(71)
Project Report of Computer Shop Management System
return false;
return true;
}
//////////////////Function for geting the Single Airport Details//////////
public boolean checkLogin(String login_user,String login_password) {
int count=0;
try {
String SQL = "SELECT * FROM login WHERE login_user = '"+login_user+"' AND login_password = '"+login_password+"'" ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) count++;
}
catch(Exception e) {
System.out.println("Error is: "+ e);
}
Project Report of Computer Shop Management System
//////////////////Function for getting Login Details//////////
public HashMap getLoginDetails(String login_user,String login_password) {
HashMap resultsArray = new HashMap();
int count=0;
try {
String SQL = "SELECT * FROM login WHERE login_user = '"+login_user+"' AND login_password = '"+login_password+"'" ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of Computer Shop Management System
resultsArray.put("login_user","");
resultsArray.put("login_level","");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return resultsArray;
} }
(74)
Project Report of Computer Shop Management System
Code for Products.java package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Products extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Products() {
Connect.connect_mysql();
}
//////////Save User Details /////
public String savePart(HashMap partData) {
String SQL = "INSERT INTO parts (part_company_id, part_type, part_name, part_modal, part_serial_number, part_price, part_warranty, part_ram, part_motherboard, part_monitor, part_processor, part_description) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?);";
int record=0;
(75)
Project Report of Computer Shop Management System
String error = "";try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) partData.get("part_company_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e)
(76)
Project Report of Computer Shop Management System
{
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
//////////////////Function for getting Users Details//////////
public HashMap getPartDetails(int part_id) {
HashMap results = new HashMap();
int count=0;
try {
String SQL = "SELECT * FROM parts WHERE part_id = "+part_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
(77)
Project Report of Computer Shop Management System
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return results;
}
public String updatePart(HashMap partData) {
String SQL = "UPDATE parts SET part_company_id = ?, part_type = ?, part_name
= ?, part_modal = ?, part_serial_number = ?, part_price = ?, part_warranty = ?, part_ram = ?, part_motherboard = ?, part_monitor = ?, part_processor = ?, part_description = ? WHERE part_id = ?;";
(79)
Project Report of Computer Shop Management System
String error = "";int record=0;
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) partData.get("part_company_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
(80)
Project Report of Computer Shop Management System
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
public boolean delete_login(int airline_id) {
return true;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllPart() {
String SQL = "SELECT * FROM parts";
int count=0;
(81)
Project Report of Computer Shop Management System
ArrayList resultArray = new ArrayList();
try {
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
HashMap results = new HashMap();
results.put("part_company_id",Integer.parseInt(rs.getString("part_company_id")));
Project Report of Computer Shop Management System
resultArray.add(results);
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return resultArray;
}
/////Function for Getting the List////////////
public String getCompanyOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("company","company_id","company_name","company_id,co mpany_name",selectedID,"1");
}
}
(83)
Project Report of Computer Shop Management System
Code for Salary.java package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Salary extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Salary() {
Connect.connect_mysql();
}
//////////Save User Details /////
public String saveSalary(HashMap salaryData) {
String SQL = "INSERT INTO salary (sal_employe_id, sal_month, sal_year, sal_amount) VALUES (?, ?, ?, ?);";
int record=0;
String error = "";
(84)
Project Report of Computer Shop Management System
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salaryData.get("sal_employe_id"));
pstmt.setString(2,(String) salaryData.get("sal_month"));
pstmt.setString(3,(String) salaryData.get("sal_year"));
pstmt.setString(4,(String) salaryData.get("sal_amount"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
(85)
Project Report of Computer Shop Management System
}
//////////////////Function for getting Users Details//////////
public HashMap getSalaryDetails(int sal_id) {
HashMap results = new HashMap();
int count=0;
try {
String SQL = "SELECT * FROM salary WHERE sal_id = "+sal_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return results;
}
//////////////////Function for getting Users Details//////////
public String getMonth(int mon_id) {
HashMap results = new HashMap();
String SQL = "";
String value = "";
int count=0;
try {
SQL = "SELECT month_name FROM month WHERE month_id = "+mon_id ;
(87)
Project Report of Computer Shop Management System
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
value = rs.getString("month_name");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return value;
}
public String updateSalary(HashMap salaryData) {
String SQL = "UPDATE salary SET sal_employe_id = ?,sal_year = ?,sal_month
= ?,sal_amount = ? WHERE sal_id = ?";
String error = "";
int record=0;
try
(88)
Project Report of Computer Shop Management System
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salaryData.get("sal_employe_id"));
pstmt.setString(2,(String) salaryData.get("sal_year"));
pstmt.setString(3,(String) salaryData.get("sal_month"));
pstmt.setString(4,(String) salaryData.get("sal_amount"));
pstmt.setString(5,(String) salaryData.get("sal_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
(89)
Project Report of Computer Shop Management System
public boolean delete_login(int airline_id) {
return true;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllSalary(String emp_id) {
String SQL = "SELECT * FROM salary";
int count=0;
ArrayList resultArray = new ArrayList();
try {
if(!emp_id.equals("0")) {
SQL = "SELECT * FROM salary WHERE sal_employe_id = "+emp_id;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
HashMap results = new HashMap();
results.put("sal_id",rs.getString("sal_id"));
(90)
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return resultArray;
}
/////Function for Getting the List////////////
public String getMonthOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("month","month_id","month_name","month_id,month_name", selectedID,"1");
}
(91)
Project Report of Computer Shop Management System
/////Function for Getting the List////////////
public String getEmployeeOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("employee","employee_id","employee_id","employee_id,empl oyee_id",selectedID,"1");
} }
(92)
Project Report of Computer Shop Management System
Code for Salary.java package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Salary extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Salary() {
Connect.connect_mysql();
}
//////////Save User Details /////
public String saveSalary(HashMap salaryData) {
String SQL = "INSERT INTO salary (sal_employe_id, sal_month, sal_year, sal_amount) VALUES (?, ?, ?, ?);";
int record=0;
String error = "";
(93)
Project Report of Computer Shop Management System
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salaryData.get("sal_employe_id"));
pstmt.setString(2,(String) salaryData.get("sal_month"));
pstmt.setString(3,(String) salaryData.get("sal_year"));
pstmt.setString(4,(String) salaryData.get("sal_amount"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
(94)
Project Report of Computer Shop Management System
}
//////////////////Function for getting Users Details//////////
public HashMap getSalaryDetails(int sal_id) {
HashMap results = new HashMap();
int count=0;
try {
String SQL = "SELECT * FROM salary WHERE sal_id = "+sal_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return results;
}
//////////////////Function for getting Users Details//////////
public String getMonth(int mon_id) {
HashMap results = new HashMap();
String SQL = "";
String value = "";
int count=0;
try {
SQL = "SELECT month_name FROM month WHERE month_id = "+mon_id ;
(96)
Project Report of Computer Shop Management System
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
value = rs.getString("month_name");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return value;
}
public String updateSalary(HashMap salaryData) {
String SQL = "UPDATE salary SET sal_employe_id = ?,sal_year = ?,sal_month
= ?,sal_amount = ? WHERE sal_id = ?";
String error = "";
int record=0;
try
(97)
Project Report of Computer Shop Management System
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salaryData.get("sal_employe_id"));
pstmt.setString(2,(String) salaryData.get("sal_year"));
pstmt.setString(3,(String) salaryData.get("sal_month"));
pstmt.setString(4,(String) salaryData.get("sal_amount"));
pstmt.setString(5,(String) salaryData.get("sal_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
(98)
Project Report of Computer Shop Management System
public boolean delete_login(int airline_id) {
return true;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllSalary(String emp_id) {
String SQL = "SELECT * FROM salary";
int count=0;
ArrayList resultArray = new ArrayList();
try {
if(!emp_id.equals("0")) {
SQL = "SELECT * FROM salary WHERE sal_employe_id = "+emp_id;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
HashMap results = new HashMap();
results.put("sal_id",rs.getString("sal_id"));
(99)
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return resultArray;
}
/////Function for Getting the List////////////
public String getMonthOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("month","month_id","month_name","month_id,month_name", selectedID,"1");
}
(100)
Project Report of Computer Shop Management System
/////Function for Getting the List////////////
public String getEmployeeOption(Integer SelID) {
int selectedID = SelID.intValue();
return
Connect.getOptionList("employee","employee_id","employee_id","employee_id,empl oyee_id",selectedID,"1");
} }
Code for Sales.java package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Sales extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Sales()
(101)
Project Report of Computer Shop Management System
{
Connect.connect_mysql();
}
//////////Save User Details /////
public String saveSales(HashMap salesData) {
String SQL = "INSERT INTO sales (sales_cust_name, sales_cust_address, sales_cust_phone, sales_partname, sales_paidamount, sales_totalamount, sales_date) VALUES (?, ?, ?, ?, ?, ?, ?);";
int record=0;
String error = "";
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salesData.get("sales_cust_name"));
Project Report of Computer Shop Management System
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
//////////////////Function for getting Users Details//////////
public HashMap getSalesDetails(int sales_id) {
HashMap results = new HashMap();
int count=0;
try {
(103)
Project Report of Computer Shop Management System
String SQL = "SELECT * FROM sales WHERE sales_id = "+sales_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of Computer Shop Management System
results.put("sales_totalamount","");
results.put("sales_date","");
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return results;
}
public String updateSales(HashMap salesData) {
String SQL = "UPDATE sales SET sales_cust_name = ?, sales_cust_address = ?, sales_cust_phone = ?, sales_partname = ?, sales_paidamount = ?, sales_totalamount
= ?, sales_date = ? WHERE sales_id = ?;";
String error = "";
int record=0;
try {
(105)
Project Report of Computer Shop Management System
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) salesData.get("sales_cust_name"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
(106)
Project Report of Computer Shop Management System
return error;
}
public boolean delete_login(int airline_id) {
return true;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllSales() {
String SQL = "SELECT * FROM sales";
int count=0;
ArrayList resultArray = new ArrayList();
try {
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) {
HashMap results = new HashMap();
results.put("sales_id",rs.getString("sales_id"));
results.put("sales_cust_name",rs.getString("sales_cust_name"));
results.put("sales_cust_address",rs.getString("sales_cust_address"));
(107)
Project Report of Computer Shop Management System
results.put("sales_cust_phone",rs.getString("sales_cust_phone"));
results.put("sales_partname",rs.getString("sales_partname"));
results.put("sales_paidamount",rs.getString("sales_paidamount"));
results.put("sales_totalamount",rs.getString("sales_totalamount"));
results.put("sales_date",rs.getString("sales_date"));
count++;
resultArray.add(results);
} }
catch(Exception e) {
System.out.println("Error is: "+ e);
}
return resultArray;
} }
(108)
Project Report of Computer Shop Management System
Code for Waranty.java package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Waranty extends Connect {
/////Function for connect to the MySQL Server Database////////////
public Waranty() {
Connect.connect_mysql();
}
//////////Save User Details /////
public String saveWaranty(HashMap warantyData) {
String SQL = "INSERT INTO waranty (waranty_Invoice_no, waranty_Serial_no, waranty_Bill_no, waranty_New_Serial_no, waranty_Problem, waranty_Service_date, waranty_Delivery_date) VALUES (?, ?, ?, ?, ?, ?, ?);";
int record=0;
String error = "";
(109)
Project Report of Computer Shop Management System
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) warantyData.get("waranty_Invoice_no"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
(110)
Project Report of Computer Shop Management System
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
//////////////////Function for getting Users Details//////////
public HashMap getWarantyDetails(int waranty_id) {
HashMap results = new HashMap();
int count=0;
try {
String SQL = "SELECT * FROM waranty WHERE waranty_id = "+waranty_id ; statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of Computer Shop Management System
System.out.println("Error is: "+ e);
}
return results;
}
(112)
Project Report of Computer Shop Management System
public String updateWaranty(HashMap warantyData) {
String SQL = "UPDATE waranty SET waranty_Invoice_no = ?, waranty_Serial_no
= ?, waranty_Bill_no = ?, waranty_New_Serial_no = ?, waranty_Problem = ?, waranty_Service_date = ?, waranty_Delivery_date = ? WHERE waranty_id = ?;";
String error = "";
int record=0;
try {
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) warantyData.get("waranty_Invoice_no"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
(113)
Project Report of Computer Shop Management System
catch(Exception e) {
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllWaranty() {
String SQL = "SELECT * FROM waranty";
int count=0;
ArrayList resultArray = new ArrayList();
try {
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
(114)
Project Report of Computer Shop Management System
{
HashMap results = new HashMap();
results.put("waranty_id",rs.getString("waranty_id"));
System.out.println("Error is: "+ e);
}
return resultArray;
} }
(115)