Project Report of E-Governance System
Page - 67
Project Report of E-Governance System
Page - 68
Coding for Bill.java
package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Bill extends Connect
{
/////Function for connect to the MySQL Server Database////////////
public Bill()
{
Connect.connect_mysql();
}
Project Report of E-Governance System
Page - 69
//////////Save the Bill Details /////
public String saveBill(HashMap billData)
{
String SQL = "INSERT INTO bill (bill_type, bill_title, bill_bill_no, bill_provider, bill_mobile_no, bill_email, bill_by, bill_amount, bill_emp_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);";
int record=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL, Statement.RETURN_GENERATED_KEYS);
pstmt.setString(1,(String) billData.get("bill_type"));
pstmt.setString(2,(String) billData.get("bill_title"));
pstmt.setString(3,(String) billData.get("bill_bill_no"));
pstmt.setString(4,(String) billData.get("bill_provider"));
pstmt.setString(5,(String) billData.get("bill_mobile_no"));
Project Report of E-Governance System
Page - 70
pstmt.setString(6,(String) billData.get("bill_email"));
pstmt.setString(7,(String) billData.get("bill_by"));
pstmt.setString(8,(String) billData.get("bill_amount"));
pstmt.setString(9,(String) billData.get("bill_emp_id"));
record = pstmt.executeUpdate();
ResultSet rs = pstmt.getGeneratedKeys();
if(rs.next())
{
int last_inserted_id = rs.getInt(1);
error = Integer.toString(last_inserted_id);
}
pstmt.close();
connection.close();
}
Project Report of E-Governance System
Page - 71
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 Bill Details//////////
public HashMap getBillDetails(int bill_id)
{
HashMap results = new HashMap();
Project Report of E-Governance System
Page - 72
int count=0;
try
{
String SQL = "SELECT * FROM bill WHERE bill_id = "+bill_id ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
results.put("bill_id",rs.getString("bill_id"));
results.put("bill_type",Integer.parseInt(rs.getString("bill_type")));
results.put("bill_title",rs.getString("bill_title"));
results.put("bill_bill_no",rs.getString("bill_bill_no"));
results.put("bill_provider",Integer.parseInt(rs.getString("bill_provider")));
results.put("bill_mobile_no",rs.getString("bill_mobile_no"));
results.put("bill_email",rs.getString("bill_email"));
results.put("bill_by",Integer.parseInt(rs.getString("bill_by")));
Project Report of E-Governance System
Page - 73
results.put("bill_amount",rs.getString("bill_amount"));
count++;
}
if(count==0)
{
results.put("bill_id","");
results.put("bill_type",0);
results.put("bill_title","");
results.put("bill_bill_no","");
results.put("bill_provider",0);
results.put("bill_mobile_no","");
results.put("bill_email","");
results.put("bill_by",0);
results.put("bill_amount","");
}
Project Report of E-Governance System
Page - 74
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return results;
}
////// Function for updating bill details ////
public String updateBill(HashMap billData)
{
String SQL = "UPDATE bill SET bill_type = ?, bill_title = ?, bill_bill_no = ?, bill_provider = ?, bill_mobile_no = ?, bill_email = ?, bill_by = ?, bill_amount = ? WHERE bill_id = ?;";
String error = "";
int record=0;
Project Report of E-Governance System
Page - 75
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) billData.get("bill_type"));
pstmt.setString(2,(String) billData.get("bill_title"));
pstmt.setString(3,(String) billData.get("bill_bill_no"));
pstmt.setString(4,(String) billData.get("bill_provider"));
pstmt.setString(5,(String) billData.get("bill_mobile_no"));
pstmt.setString(6,(String) billData.get("bill_email"));
pstmt.setString(7,(String) billData.get("bill_by"));
pstmt.setString(8,(String) billData.get("bill_amount"));
pstmt.setString(9,(String) billData.get("bill_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
Project Report of E-Governance System
Page - 76
}
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 bills details listing////////////////////
public ArrayList getAllBill(String emp_id)
Project Report of E-Governance System
Page - 77
{
String SQL = "SELECT * FROM bill";
int count=0;
ArrayList resultArray = new ArrayList();
try
{
if(!emp_id.equals("0"))
{
SQL = "SELECT * FROM bill WHERE bill_emp_id = "+emp_id;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
HashMap results = new HashMap();
results.put("bill_id",rs.getString("bill_id"));
Project Report of E-Governance System
Page - 78
results.put("bill_type",Integer.parseInt(rs.getString("bill_type")));
results.put("bill_title",rs.getString("bill_title"));
results.put("bill_bill_no",rs.getString("bill_bill_no"));
results.put("bill_provider",Integer.parseInt(rs.getString("bill_provider")));
results.put("bill_mobile_no",rs.getString("bill_mobile_no"));
results.put("bill_email",rs.getString("bill_email"));
results.put("bill_by",Integer.parseInt(rs.getString("bill_by")));
results.put("bill_amount",rs.getString("bill_amount"));
count++;
resultArray.add(results);
}
}
catch(Exception e)
{
Project Report of E-Governance System
Page - 79
System.out.println("Error is: "+ e);
}
return resultArray;
}
/////Function for Getting the List////////////
public String getProviderOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("providers","provider_id","provider_name","provider_id,provider_name",selecte dID,"1");
}
/////Function for Getting the List////////////
public String getBillTypeOption(Integer SelID)
{
Project Report of E-Governance System
Page - 80
int selectedID = SelID.intValue();
return Connect.getOptionList("bill_type","bt_id","bt_name","bt_id,bt_name",selectedID,"1");
}
/////Function for Getting the List////////////
public String getPaymentOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("payment_option","po_id","po_name","po_id,po_name",selectedID,"1");
}
}
Project Report of E-Governance System
Page - 81
Coding for Customer.java
package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Customer extends Connect
{
/////Function for connect to the MySQL Server Database////////////
public Customer()
{
Connect.connect_mysql();
}
Project Report of E-Governance System
Page - 82
//////////Save User Details /////
public String saveCustomer(HashMap customerData)
{
String SQL = "INSERT INTO `customer` (`customer_name`, `customer_mobile`,
`customer_email`, `customer_password`, `customer_address`, `customer_city`, `customer_state`,
`customer_pincode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?);";
int record=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) customerData.get("customer_name"));
pstmt.setString(2,(String) customerData.get("customer_mobile"));
pstmt.setString(3,(String) customerData.get("customer_email"));
pstmt.setString(4,(String) customerData.get("customer_password"));
pstmt.setString(5,(String) customerData.get("customer_address"));
Project Report of E-Governance System
Page - 83
pstmt.setString(6,(String) customerData.get("customer_city"));
pstmt.setString(7,(String) customerData.get("customer_state"));
pstmt.setString(8,(String) customerData.get("customer_pincode"));
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;
Project Report of E-Governance System
Page - 84
System.out.println(" Error : "+ e.toString());
}
return error;
}
//////////////////Function for getting Users Details//////////
public HashMap getCustomerDetails(int customer_id)
{
HashMap results = new HashMap();
int count=0;
try
{
String SQL = "SELECT * FROM `customer` WHERE customer_id = "+customer_id ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
Project Report of E-Governance System
Page - 85
results.put("customer_name",rs.getString("customer_name"));
results.put("customer_mobile",rs.getString("customer_mobile"));
results.put("customer_email",rs.getString("customer_email"));
results.put("customer_password",rs.getString("customer_password"));
results.put("customer_address",rs.getString("customer_address"));
results.put("customer_city",rs.getString("customer_city"));
results.put("customer_state",Integer.parseInt(rs.getString("customer_state")));
results.put("customer_pincode",rs.getString("customer_pincode"));
results.put("customer_id",rs.getString("customer_id"));
count++;
}
if(count==0)
{
results.put("customer_name","");
results.put("customer_mobile","");
Project Report of E-Governance System
Page - 86
results.put("customer_email","");
results.put("customer_password","");
results.put("customer_address","");
results.put("customer_city","");
results.put("customer_state",0);
results.put("customer_pincode","");
results.put("customer_id","");
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return results;
}
/// Update the Customer ////
Project Report of E-Governance System
Page - 87
public String updateCustomer(HashMap customerData)
{
String SQL = "UPDATE `customer` SET `customer_name` = ?, `customer_mobile` = ?,
`customer_email` = ?, `customer_password` = ?, `customer_address` = ?, `customer_city` = ?,
`customer_state` = ?, `customer_pincode` = ? WHERE `customer_id` = ?;";
String error = "";
int record=0;
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) customerData.get("customer_name"));
pstmt.setString(2,(String) customerData.get("customer_mobile"));
pstmt.setString(3,(String) customerData.get("customer_email"));
pstmt.setString(4,(String) customerData.get("customer_password"));
pstmt.setString(5,(String) customerData.get("customer_address"));
Project Report of E-Governance System
Page - 88
pstmt.setString(6,(String) customerData.get("customer_city"));
pstmt.setString(7,(String) customerData.get("customer_state"));
pstmt.setString(8,(String) customerData.get("customer_pincode"));
pstmt.setString(9,(String) customerData.get("customer_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;
Project Report of E-Governance System
Page - 89
System.out.println(" Error : "+ e.toString());
}
return error;
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllCustomer()
{
String SQL = "SELECT * FROM `customer`";
int count=0;
ArrayList resultArray = new ArrayList();
try
{
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of E-Governance System
Page - 90
{
HashMap results = new HashMap();
results.put("customer_name",rs.getString("customer_name"));
results.put("customer_mobile",rs.getString("customer_mobile"));
results.put("customer_email",rs.getString("customer_email"));
results.put("customer_password",rs.getString("customer_password"));
results.put("customer_address",rs.getString("customer_address"));
results.put("customer_city",rs.getString("customer_city"));
results.put("customer_state",Integer.parseInt(rs.getString("customer_state")));
results.put("customer_pincode",rs.getString("customer_pincode"));
results.put("customer_id",rs.getString("customer_id"));
count++;
resultArray.add(results);
}
}
Project Report of E-Governance System
Page - 91
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return resultArray;
}
/////Function for Getting the List////////////
public String getStateOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("state","state_id","state_name","state_id,state_name",selectedID,"1");
}
//////////////////Function for getting Login Details//////////
public HashMap getLoginDetails(String login_user,String login_password)
{
Project Report of E-Governance System
Page - 92
HashMap resultsArray = new HashMap();
int count=0;
try
{
String SQL = "SELECT * FROM customer WHERE customer_email = '"+login_user+"' AND customer_password = '"+login_password+"'" ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
resultsArray.put("customer_id",rs.getString("customer_id"));
resultsArray.put("customer_name",rs.getString("customer_name"));
resultsArray.put("login_level",4);
count++;
}
if(count==0)
Project Report of E-Governance System
Page - 93
{
resultsArray.put("customer_id","");
resultsArray.put("customer_name","");
resultsArray.put("login_level",0);
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return resultsArray;
}
//////////////////Function for checking the existing username//////////
public int checkUsernameExits(String login_user, int type)
{
HashMap resultsArray = new HashMap();
Project Report of E-Governance System
Page - 94
int exits=0;
try
{
String SQL = "";
if(type == 1) {
SQL = "SELECT * FROM customer WHERE customer_email = '"+login_user+"'" ;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
exits++;
}
}
catch(Exception e)
Project Report of E-Governance System
Page - 95
{
System.out.println("Error is: "+ e);
}
return exits;
}
//////////////////Function for geting the Single Airport Details//////////
public boolean checkLogin(String login_user,String login_password)
{
int count=0;
try
{
String SQL = "SELECT * FROM customer WHERE customer_email = '"+login_user+"' AND customer_password = '"+login_password+"'" ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next()) count++;
Project Report of E-Governance System
Page - 96
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
if(count==0)
return false;
return true;
}
}
Project Report of E-Governance System
Page - 97
Coding for Employee.java
package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Employee extends Connect
{
/////Function for connect to the MySQL Server Database////////////
public Employee()
{
Connect.connect_mysql();
}
Project Report of E-Governance System
Page - 98
//////////Save User Details /////
public String saveEmployee(HashMap employeeData)
{
String SQL = "INSERT INTO employee (employee_sal, employee_first_name, employee_middle_name, employee_last_name, employee_gender, employee_address, employee_village, employee_state, employee_country, employee_landline, employee_mobile, employee_email, employee_status, employee_deparment, employee_dob, employee_nationalty, employee_manager_id, employee_role) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);";
int record=0,last_inserted_id=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL, Statement.RETURN_GENERATED_KEYS);
pstmt.setString(1,(String) employeeData.get("employee_sal"));
pstmt.setString(2,(String) employeeData.get("employee_first_name"));
pstmt.setString(3,(String) employeeData.get("employee_middle_name"));
Project Report of E-Governance System
Page - 99
pstmt.setString(4,(String) employeeData.get("employee_last_name"));
pstmt.setString(5,(String) employeeData.get("employee_gender"));
pstmt.setString(6,(String) employeeData.get("employee_address"));
pstmt.setString(7,(String) employeeData.get("employee_village"));
pstmt.setString(8,(String) employeeData.get("employee_state"));
pstmt.setString(9,(String) employeeData.get("employee_country"));
pstmt.setString(10,(String) employeeData.get("employee_landline"));
pstmt.setString(11,(String) employeeData.get("employee_mobile"));
pstmt.setString(12,(String) employeeData.get("employee_email"));
pstmt.setString(13,(String) employeeData.get("employee_status"));
pstmt.setString(14,(String) employeeData.get("employee_deparment"));
pstmt.setString(15,(String) employeeData.get("employee_dob"));
pstmt.setString(16,(String) employeeData.get("employee_nationalty"));
pstmt.setString(17,(String) employeeData.get("employee_manager_id"));
pstmt.setString(18,(String) employeeData.get("employee_role"));
Project Report of E-Governance System
Page - 100
record = pstmt.executeUpdate();
/// Get the Last Insert ID ///
rs = pstmt.getGeneratedKeys();
if(rs.next())
{
last_inserted_id = rs.getInt(1);
}
pstmt.close();
}
catch(Exception e)
{
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
e.printStackTrace( printWriter );
printWriter.flush();
Project Report of E-Governance System
Page - 101
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
/// Save Credentials to Login ////
SQL = "INSERT INTO login (login_emp_id, login_user, login_password, login_email, login_level) VALUES (?, ?, ?, ?, ?);";
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setInt(1,last_inserted_id);
pstmt.setString(2,(String) employeeData.get("employee_user"));
pstmt.setString(3,(String) employeeData.get("employee_password"));
pstmt.setString(4,(String) employeeData.get("employee_email"));
pstmt.setString(5,(String) employeeData.get("employee_role"));
Project Report of E-Governance System
Page - 102
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;
Project Report of E-Governance System
Page - 103
}
//////////////////Function for getting Users Details//////////
public HashMap getEmployeeDetails(int employee_id)
{
HashMap resultsArray = new HashMap();
int count=0;
try
{
String SQL = "SELECT * FROM employee WHERE employee_id = "+employee_id ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
resultsArray.put("employee_id",rs.getString("employee_id"));
resultsArray.put("employee_manager_id",Integer.parseInt(rs.getString("employee_manager_id
Project Report of E-Governance System
Page - 104
")));
resultsArray.put("employee_role",Integer.parseInt(rs.getString("employee_role")));
resultsArray.put("employee_sal",Integer.parseInt(rs.getString("employee_sal")));
resultsArray.put("employee_first_name",rs.getString("employee_first_name"));
resultsArray.put("employee_middle_name",rs.getString("employee_middle_name"));
resultsArray.put("employee_last_name",rs.getString("employee_last_name"));
resultsArray.put("employee_gender",rs.getString("employee_gender"));
resultsArray.put("employee_address",rs.getString("employee_address"));
resultsArray.put("employee_village",rs.getString("employee_village"));
resultsArray.put("employee_state",Integer.parseInt(rs.getString("employee_state")));
resultsArray.put("employee_country",Integer.parseInt(rs.getString("employee_country")));
resultsArray.put("employee_landline",rs.getString("employee_landline"));
Project Report of E-Governance System
Page - 105
resultsArray.put("employee_mobile",rs.getString("employee_mobile"));
resultsArray.put("employee_email",rs.getString("employee_email"));
resultsArray.put("employee_status",Integer.parseInt(rs.getString("employee_status")));
resultsArray.put("employee_deparment",Integer.parseInt(rs.getString("employee_deparment")) );
resultsArray.put("employee_dob",rs.getString("employee_dob"));
resultsArray.put("employee_nationalty",rs.getString("employee_nationalty"));
count++;
}
if(count==0)
{
resultsArray.put("employee_id","");
resultsArray.put("employee_manager_id",0);
resultsArray.put("employee_role",0);
resultsArray.put("employee_user","");
Project Report of E-Governance System
Page - 106
resultsArray.put("employee_sal",0);
resultsArray.put("employee_first_name","");
resultsArray.put("employee_middle_name","");
resultsArray.put("employee_last_name","");
resultsArray.put("employee_gender","");
resultsArray.put("employee_address","");
resultsArray.put("employee_village","");
resultsArray.put("employee_state",0);
resultsArray.put("employee_country",0);
resultsArray.put("employee_landline","");
resultsArray.put("employee_mobile","");
resultsArray.put("employee_email","");
resultsArray.put("employee_status",0);
resultsArray.put("employee_deparment",0);
resultsArray.put("employee_dob","");
resultsArray.put("employee_nationalty","");
Project Report of E-Governance System
Page - 107
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return resultsArray;
}
public String updateEmployee(HashMap employeeData)
{
String SQL = "UPDATE employee SET employee_sal = ?, employee_first_name = ?, employee_middle_name = ?, employee_last_name = ?, employee_gender = ?, employee_address = ?, employee_village = ?, employee_state = ?, employee_country = ?, employee_landline = ?,
employee_mobile = ?, employee_email = ?, employee_status = ?, employee_deparment = ?,
employee_dob = ?, employee_nationalty = ?, employee_manager_id = ?, employee_role = ? WHERE employee_id = ?";
String error = "";
Project Report of E-Governance System
Page - 108
int record=0;
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) employeeData.get("employee_sal"));
pstmt.setString(2,(String) employeeData.get("employee_first_name"));
pstmt.setString(3,(String) employeeData.get("employee_middle_name"));
pstmt.setString(4,(String) employeeData.get("employee_last_name"));
pstmt.setString(5,(String) employeeData.get("employee_gender"));
pstmt.setString(6,(String) employeeData.get("employee_address"));
pstmt.setString(7,(String) employeeData.get("employee_village"));
pstmt.setString(8,(String) employeeData.get("employee_state"));
pstmt.setString(9,(String) employeeData.get("employee_country"));
pstmt.setString(10,(String) employeeData.get("employee_landline"));
pstmt.setString(11,(String) employeeData.get("employee_mobile"));
Project Report of E-Governance System
Page - 109
pstmt.setString(12,(String) employeeData.get("employee_email"));
pstmt.setString(13,(String) employeeData.get("employee_status"));
pstmt.setString(14,(String) employeeData.get("employee_deparment"));
pstmt.setString(15,(String) employeeData.get("employee_dob"));
pstmt.setString(16,(String) employeeData.get("employee_nationalty"));
pstmt.setString(17,(String) employeeData.get("employee_manager_id"));
pstmt.setString(18,(String) employeeData.get("employee_role"));
pstmt.setString(19,(String) employeeData.get("employee_id"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
catch(Exception e)
{
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
Project Report of E-Governance System
Page - 110
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return error;
}
public boolean deleteEmployee(int employee_id)
{
return true;
}
/////Function for Getting the List////////////
public String getStateOption(Integer SelID)
{
Project Report of E-Governance System
Page - 111
int selectedID = SelID.intValue();
return
Connect.getOptionList("state","state_id","state_name","state_id,state_name",selectedID,"1");
}
/////Function for Getting the List////////////
public String getEmployeeOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("employee","employee_id","employee_id","employee_id,employee_id",selected ID,"1");
}
/////Function for Getting the List////////////
public String getRoleOption(Integer SelID)
{
int selectedID = SelID.intValue();
return Connect.getOptionList("roles","role_id","role_title","role_id,role_title",selectedID,"1");
}
Project Report of E-Governance System
Page - 112
/////Function for Getting the List////////////
public String getCountryOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("country","country_id","country_name","country_id,country_name",selectedID,
"1");
}
/////Function for Getting the List////////////
public String getSalutionOption(Integer SelID)
{
int selectedID = SelID.intValue();
return Connect.getOptionList("salutions","sl_id","sl_name","sl_id,sl_name",selectedID,"1");
}
/////Function for Getting the List////////////
Project Report of E-Governance System
Page - 113
public String getStatusOption(Integer SelID)
{
int selectedID = SelID.intValue();
return
Connect.getOptionList("status","status_id","status_name","status_id,status_name",selectedID,"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",selectedID,"1");
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllEmployee(String managerID)
Project Report of E-Governance System
Page - 114
{
int count=0;
String error = "";
String SQL = "SELECT * FROM employee";
ArrayList resultArray = new ArrayList();
try
{
if(!managerID.equals("0"))
{
SQL = "SELECT * FROM employee WHERE employee_manager_id =
"+managerID;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
Project Report of E-Governance System
Page - 115
{
HashMap results = new HashMap();
results.put("employee_id",rs.getString("employee_id"));
results.put("employee_role",rs.getString("employee_role"));
results.put("employee_sal",rs.getString("employee_sal"));
results.put("employee_first_name",rs.getString("employee_first_name"));
results.put("employee_middle_name",rs.getString("employee_middle_name"));
results.put("employee_last_name",rs.getString("employee_last_name"));
results.put("employee_gender",rs.getString("employee_gender"));
results.put("employee_address",rs.getString("employee_address"));
results.put("employee_village",rs.getString("employee_village"));
results.put("employee_state",rs.getString("employee_state"));
results.put("employee_country",rs.getString("employee_country"));
results.put("employee_landline",rs.getString("employee_landline"));
results.put("employee_mobile",rs.getString("employee_mobile"));
Project Report of E-Governance System
Page - 116
results.put("employee_email",rs.getString("employee_email"));
results.put("employee_status",Integer.parseInt(rs.getString("employee_status")));
results.put("employee_deparment",Integer.parseInt(rs.getString("employee_deparment")));
results.put("employee_dob",rs.getString("employee_dob"));
results.put("employee_nationalty",rs.getString("employee_nationalty"));
results.put("employee_manager_id",Integer.parseInt(rs.getString("employee_manager_id")));
count++;
resultArray.add(results);
}
}
catch(Exception e)
{
StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer );
Project Report of E-Governance System
Page - 117
e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString();
error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString());
}
return resultArray;
}
public String getDepartment(int dept_id)
{
HashMap results = new HashMap();
String SQL = "";
String value = "";
int count=0;
try
Project Report of E-Governance System
Page - 118
{
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);
}
return value;
}
Project Report of E-Governance System
Page - 119
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");
}
}
Project Report of E-Governance System
Page - 120
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return value;
}
}
Project Report of E-Governance System
Page - 121
Coding for Login.java
package 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();
}
Project Report of E-Governance System
Page - 122
//////////////////Function for Update the airport////////////////////////
public boolean changePassword(String old_password,String new_password, int login_id)
{
String SQL;
int count = 0;
try
{
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;
Project Report of E-Governance System
Page - 123
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,new_password);
pstmt.setInt(2,login_id);
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
}
}
catch(Exception e)
{
System.out.println(" Error : "+ e.toString());
}
if(count==0)
return false;
return true;
}
Project Report of E-Governance System
Page - 124
//////////////////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 E-Governance System
Page - 125
if(count==0)
return false;
return true;
}
//////////////////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 E-Governance System
Page - 126
{
resultsArray.put("login_id",rs.getString("login_id"));
resultsArray.put("login_emp_id",rs.getString("login_emp_id"));
resultsArray.put("login_user",rs.getString("login_user"));
resultsArray.put("login_level",rs.getString("login_level"));
count++;
}
if(count==0)
{
resultsArray.put("login_id","");
resultsArray.put("login_emp_id","");
resultsArray.put("login_user","");
resultsArray.put("login_level","");
}
}
catch(Exception e)
Project Report of E-Governance System
Page - 127
{
System.out.println("Error is: "+ e);
}
return resultsArray;
}
//////////////////Function for getting Login Details//////////
public int checkUsernameExits(String login_user, int type)
{
HashMap resultsArray = new HashMap();
int exits=0;
try
{
String SQL = "";
if(type == 1) {
SQL = "SELECT * FROM login WHERE login_user = '"+login_user+"'" ;
}
Project Report of E-Governance System
Page - 128
if(type == 2) {
SQL = "SELECT * FROM login WHERE login_email = '"+login_user+"'" ;
}
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
exits++;
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return exits;
}
Project Report of E-Governance System
Page - 129
}
Project Report of E-Governance System
Page - 130
Coding for Pettion.java
package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class Petition extends Connect
{
/////Function for connect to the MySQL Server Database////////////
public Petition()
{
Connect.connect_mysql();
}
Project Report of E-Governance System
Page - 131
//////////Save User Details /////
public String savePetition(HashMap petitionData)
{
String SQL = "INSERT INTO petition (petition_title,
petition_decision,petition_description,petition_user_id) VALUES (?, ?, ?, ?);";
int record=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) petitionData.get("petition_title"));
pstmt.setString(2,(String) petitionData.get("petition_decision"));
pstmt.setString(3,(String) petitionData.get("petition_description"));
pstmt.setString(4,(String) petitionData.get("petition_user_id"));
Project Report of E-Governance System
Page - 132
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;
}
Project Report of E-Governance System
Page - 133
//////////////////Function for getting Users Details//////////
public HashMap getPetitionDetails(int petition_id)
{
HashMap results = new HashMap();
int count=0;
try
{
String SQL = "SELECT * FROM petition WHERE petition_id = "+petition_id ;
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
results.put("petition_id",rs.getString("petition_id"));
results.put("petition_title",rs.getString("petition_title"));
results.put("petition_decision",rs.getString("petition_decision"));
results.put("petition_description",rs.getString("petition_description"));
Project Report of E-Governance System
Page - 134
count++;
}
if(count==0)
{
results.put("petition_id","");
results.put("petition_title","");
results.put("petition_decision","");
results.put("petition_description","");
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return results;
Project Report of E-Governance System
Page - 135
}
public String updatePetition(HashMap petitionData)
{
String SQL = "UPDATE petition SET petition_title = ?,petition_decision = ?, petition_description = ? WHERE petition_id = ?";
String error = "";
int record=0;
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) petitionData.get("petition_title"));
pstmt.setString(2,(String) petitionData.get("petition_decision"));
pstmt.setString(3,(String) petitionData.get("petition_description"));
Project Report of E-Governance System
Page - 136
pstmt.setString(4,(String) petitionData.get("petition_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;
Project Report of E-Governance System
Page - 137
}
////////////////Function for getting all the Airport Details////////////////////
public ArrayList getAllPetition(String customer_id)
{
String SQL = "SELECT * FROM petition";
if(customer_id != null)
{
SQL = "SELECT * FROM petition WHERE petition_user_id = "+customer_id;
}
int count=0;
ArrayList resultArray = new ArrayList();
try
{
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
Project Report of E-Governance System
Page - 138
while(rs.next())
{
HashMap results = new HashMap();
results.put("petition_id",rs.getString("petition_id"));
results.put("petition_title",rs.getString("petition_title"));
results.put("petition_decision",rs.getString("petition_decision"));
results.put("petition_description",rs.getString("petition_description"));
count++;
resultArray.add(results);
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
Project Report of E-Governance System
Page - 139
return resultArray;
}
}
Project Report of E-Governance System
Page - 140
Coding for Pettion-Review.java
package Model;
import java.util.*;
import java.sql.*;
import com.*;
import java.io.*;
public class PetitionReview extends Connect
{
/////Function for connect to the MySQL Server Database////////////
public PetitionReview()
{
Connect.connect_mysql();
}
Project Report of E-Governance System
Page - 141
////// Save user sign petition /////
public String savePetitionSign(HashMap petitionData)
{
String SQL = "INSERT INTO `petition_sign` (`ps_user_id`, `ps_petition_id`) VALUES (?,
?);";
int record=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) petitionData.get("pr_user_id"));
pstmt.setString(2,(String) petitionData.get("pr_petition_id"));
record = pstmt.executeUpdate();
pstmt.close();
Project Report of E-Governance System
Page - 142
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;
}
//////////Save User Details /////
public String savePetitionReview(HashMap petitionData)
Project Report of E-Governance System
Page - 143
{
String SQL = "INSERT INTO `petition_review` (`pr_user_id`, `pr_petition_id`,
`pr_description`) VALUES (?, ?, ?);";
int record=0;
String error = "";
try
{
pstmt = connection.prepareStatement(SQL);
pstmt.setString(1,(String) petitionData.get("pr_user_id"));
pstmt.setString(2,(String) petitionData.get("pr_petition_id"));
pstmt.setString(3,(String) petitionData.get("pr_description"));
record = pstmt.executeUpdate();
pstmt.close();
connection.close();
Project Report of E-Governance System
Page - 144
}
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 getAllPetitionReview(String petition_id)
Project Report of E-Governance System
Page - 145
{
String SQL = "SELECT * FROM `petition_review`,`customer` WHERE pr_user_id = customer_id AND pr_petition_id = "+petition_id+" ORDER BY pr_id ASC";
int count=0;
ArrayList resultArray = new ArrayList();
try
{
statement = connection.createStatement();
rs = statement.executeQuery(SQL);
while(rs.next())
{
HashMap results = new HashMap();
results.put("pr_description",rs.getString("pr_description"));
results.put("user_name",rs.getString("customer_name"));
count++;
resultArray.add(results);
Project Report of E-Governance System
Page - 146
}
}
catch(Exception e)
{
System.out.println("Error is: "+ e);
}
return resultArray;
}
////////////////Function for getting sign petition////////////////////
////////////////Function for getting sign petition////////////////////