package com.wipro.semsary.model.bao;


import com.wipro.semsary.model.SearchList;
import com.wipro.semsary.model.dao.AdminModuleClass;

import java.util.ArrayList;

public class AdminClass implements AdminInterface{
AdminModuleClass admin = new AdminModuleClass();
public AdminClass() {
}
public void addNewSearchList(SearchList list) {
admin.dbConnect();
admin.insertNewSearchList(list);
}
// edit search lists
public void editSearchList(int searchID, String searchValue) {
admin.dbConnect();
admin.editSearchList(searchID, searchValue);
}

public void deleteSearchList(int searchID) {
admin.dbConnect();
admin.deleteSearchList(searchID);
}

public ArrayList<SearchList> getSearchLists(){
admin.dbConnect();
return admin.loadSearchListsFormDatabase();
}

}


*************************************************

package com.wipro.semsary.model.dao;


import com.wipro.semsary.controller.ConnectionString;
import com.wipro.semsary.model.SearchList;

import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.ArrayList;

public class AdminModuleClass extends ConnectionString implements AdminModuleInterface{
public AdminModuleClass() {
}
// insert new admin search list into db
public void insertNewSearchList(SearchList searchlist) {
if (searchlist == null){
System.out.println("Error : Empty Search List !");
}else {
try {
int maxID;
maxID = getMaxIdFromTable("SEARCH_LIST", "SEARCH_ID");
stmnt = connection.createStatement();
String sql = "INSERT INTO SEARCH_LIST (SEARCH_ID,SEARCH_NAME,SEARCH_VALUE)\n" +
"VALUES (000 ," +
"'" + searchlist.getSearchName() + "'," +
"'" + searchlist.getSearchValue() + "')";
int value = stmnt.executeUpdate(sql);
System.out.println(value + " row affected");
} catch (SQLException se) {
System.err.println("SQLException information");
System.err.println ("Error msg: " + se.getMessage());
System.err.println ("SQLSTATE: " + se.getSQLState());
System.err.println ("Error code: " + se.getErrorCode());
se.printStackTrace();
se = se.getNextException(); // For drivers that support chained exceptions
}finally {
closeConnection(connection);
}
}
}
// update admin search list setting
public void editSearchList(int searchID, String searchValue) {
try {
stmnt = connection.createStatement();
String sql = "UPDATE SEARCH_LIST SET SEARCH_VALUE = '" +
searchValue + "' WHERE SEARCH_ID = " + searchID + "";
int val;
val = stmnt.executeUpdate(sql);
} catch (SQLException se) {
System.err.println("SQLException information");
System.err.println ("Error msg: " + se.getMessage());
System.err.println ("SQLSTATE: " + se.getSQLState());
System.err.println ("Error code: " + se.getErrorCode());
se.printStackTrace();
se = se.getNextException(); // For drivers that support chained exceptions
}finally {
try{
connection.close();
}catch (SQLException se){
se.printStackTrace();
}
}
}
// delete admin search list setting
public void deleteSearchList(int searchID) {
try {
stmnt = connection.createStatement();
String sql = "DELETE FROM SEARCH_LIST WHERE \n" +
"SEARCH_ID =" + searchID + "";
int val = stmnt.executeUpdate(sql);
System.out.println(val + " Row affected ! ");
} catch (SQLException se) {
System.err.println("SQLException information");
System.err.println ("Error msg: " + se.getMessage());
System.err.println ("SQLSTATE: " + se.getSQLState());
System.err.println ("Error code: " + se.getErrorCode());
se.printStackTrace();
se = se.getNextException(); // For drivers that support chained exceptions
}finally {
try{
connection.close();
}catch (SQLException se){
se.printStackTrace();
}
}
}
// Get all the search list form database
public ArrayList<SearchList> loadSearchListsFormDatabase() {
ArrayList<SearchList> searchList = new ArrayList<SearchList>();
SearchList list = new SearchList();
try {
stmnt = connection.createStatement();
String sql = "SELECT * FROM SEARCH_LIST";
ResultSet res = stmnt.executeQuery(sql);
while (res.next()){
list = new SearchList();
list.setId(Integer.parseInt(res.getString("SEARCH_ID")));
list.setSearchName(res.getString("SEARCH_NAME"));
list.setSearchValue(res.getString("SEARCH_VALUE"));
searchList.add(list);
}
} catch (SQLException se) {
System.err.println("SQLException information");
System.err.println ("Error msg: " + se.getMessage());
System.err.println ("SQLSTATE: " + se.getSQLState());
System.err.println ("Error code: " + se.getErrorCode());
se.printStackTrace();
se = se.getNextException(); // For drivers that support chained exceptions
}finally {
try{
connection.close();
}catch (SQLException se){
se.printStackTrace();
}
}

return searchList;
}
}


********************************************************

package com.wipro.semsary.presentation;

import com.wipro.semsary.model.SearchList;
import com.wipro.semsary.model.bao.AdminClass;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.*;
import javax.servlet.http.*;

public class AdminServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=windows-1256";
AdminClass admin = new AdminClass();
SearchList list = new SearchList();
public void init(ServletConfig config) throws ServletException {
super.init(config);
}

public void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>AdminServlet</title></head>");
out.println("<body>");
out.println("<p>The servlet has received a GET. This is the reply.</p>");
out.println("</body></html>");
out.close();
}

public void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException,
IOException {
response.setContentType(CONTENT_TYPE);
String searchName = request.getParameter("searchname");
String searchValue = request.getParameter("value");
if (searchName == null || searchValue == null){
System.out.println("Null Values" + searchName + searchValue);
request.setAttribute("adminTable", admin.getSearchLists());
RequestDispatcher view = request.getRequestDispatcher("admin.jsp");
view.forward(request, response);
}else{
list.setId(00);
list.setSearchName(searchName);
list.setSearchValue(searchValue);
admin.addNewSearchList(list);
request.setAttribute("adminTable", admin.getSearchLists());
RequestDispatcher view = request.getRequestDispatcher("admin.jsp");
view.forward(request, response);
}

}
}



**************************************************

LoginServlet > admin

if (commonModule.login(username, password)) {
// Check the user if he is an admin or not
// Load admin page
user = commonModule.getUser(username);
request.getSession().setAttribute("username",user.getUsername());
if (user.getUserType() == 1) {
session.setAttribute("admin", user);
request.setAttribute("adminTable", admin.getSearchLists());
RequestDispatcher view = request.getRequestDispatcher("admin.jsp");
request.getSession().setAttribute("fullname",user.getFullname());
view.forward(request,response);
}


***************************************************

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page import="com.wipro.semsary.model.bao.TransactionClass" %>
<%@ page import="java.util.*" %>
<%@ page import="com.wipro.semsary.model.Property" %>
<%@ page import="com.wipro.semsary.model.User" %>
<html>
<head>
<!--Site Mesh Configuration -->
<meta name="selection" content="home">

<!--CSS Import -->
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<style type="text/css"></style>

<!--JAVASCRIPT Import -->
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<script type="text/javascript"></script>

</head>
<!--Body Start -->
<body>

<div id="page">
<div id="page-bgtop">
<div id="page-bgbtm">
<div id="sidebar1" class="sidebar" style="height: 75px">
<ul>
<li> Semsary is the biggest company in Selling buildings </li>
<li> -<a href="images/b1.jpg" rel="lightbox">Amoro Building: Buying property requires thinking about what
you want to have as a target property.</a></li>
<li> -<a href="images/b2.jpg" rel="lightbox">Testo Building: Buying property requires thinking about what
you want to have as a target property. </a> </li>
<li> -<a href="images/b3.jpg" rel="lightbox">Supuro Building: Buying property requires thinking about what
you want to have as a target property.</a><br />
</li>
<li> -<a href="images/b4.jpg" rel="lightbox">Thoughts Building: Buying property requires thinking about what
you want to have as a target property.</a></li>
</ul>
<p>&nbsp;</p>
</div>
<!-- start content -->
<div id="content" style="height: 90px">
<div class="post">
<h1 class="title"> Welcome <%= session.getAttribute("fullname")%> </h1>
<p>We are a leading conpany in selling and buying houses and buildings</p>
</div>
<form method="post" action="adminservlet">
<table class="auto-style12" style="width: 100%">
<tr>
<td class="auto-style9">Search Name</td>
<td class="auto-style9">
<select name="searchname" style="width: 132px; height: 23px">
<option value="Price">Price</option>
<option value="Location">Location</option>
<option value="Type">Type</option>
</select>
</td>
</tr>
<tr>
<td class="auto-style9">Search Value(*)</td>
<td class="auto-style9">
<input name="value" type="text" />
</td>
</tr>
<tr>
<td class="auto-style9">
<input name="Submit" type="submit" value="Add Search" />
</td>
<td class="auto-style9">&nbsp;</td>
</tr>
</table>
</form>
<p></p>
<div style="height:145px">
<table class="auto-style13" style="width: 100%; height: 140px; overflow:scroll" >
<tr>
<td class="auto-style9">Search Name</td>
<td class="auto-style9">Search Value</td>
<td class="auto-style9">Edit</td>
<td class="auto-style9">Delete</td>
</tr>
<c:forEach var="list" items="${requestScope.adminTable}">
<tr>
<td class="auto-style9">${list.searchName}</td>
<td class="auto-style9">${list.searchValue}</td>
<td class="auto-style9"><a href="#" >Edit</a></td>
<td class="auto-style9"><a href="#">Delete</a></td>
</tr>
</c:forEach>
</table>
</div>

</div>
<!-- end content -->

<!-- start sidebars -->
<div id="sidebar2" class="sidebar" style="height: 438px">
<ul>
<li>Welcome<a href="home.jsp"><%= session.getAttribute("fullname")%></a>
<br /><a href="changePassword.jsp">Change Password ?
</a><br />
<a href="#">Logout</a>
<br /><br />
<div class="auto-style2">
<a href="images/b1.jpg" rel="lightbox">
<input alt="Amoro" height="120" longdesc="Amoro" name="Image1" src="images/b1.jpg" type="image" width="160" /></a><br />
<a href="images/b2.jpg" rel="lightbox"><input alt="Testo" class="auto-style3" height="80" longdesc="Testo" name="Image2" src="images/b2.jpg" type="image" width="160" /></a></div>
</li>
</ul>
</div>
<!-- end sidebars -->
<div style="clear: both;">&nbsp;</div>
</div>
<!-- end page -->
</div>
</div>
</body>
</html>


***********************************************


Comment s
ConnectionString class
This class is responsible for connecting to the database through a property file(config.properties)
Connect() this method is used to make the connection string and connecting to the database
closeConnection() this method is used to close the connection from the database

AdminClass
This class is a data access object that access the database for adding , editing ,deleting the search list for the admin
addNewSearchList : this method add new search to the databass
edit Search : this method edit existing search list in the database
delete search : this method delete existing search list from the database
loadallSearchLists: this method get all existing search list from the database and return them in an arraylist of type SearchList.

CommonClass
This class is responsible for adding ,editing , getting and checking users business and logic
And managing user access
Login() :this method is for logging in the user it checks for the username and password in the database then return true or false as user existence
Register(): this method for registering the user



*********************************************

Hamzaaa

*********************************************

/******************Dao*********************************/
1-AdminRolesBAO

///////////////////////getListValue////////////////////
/**
* @param listName
* @return arraylist of lists
* this method is to get the lists that match the list name parmeter
*/
/////////////////////////////////addSearchCategory//////////////////////
/**
* @param category
* @return added_or_Not
* this method to add new search ctegory to the seach category table
* and return bolean variable that indicate if the recored added succesfuly or not
* if added succesfuly return true
* if not rturn false

*/
//////////////////////////////addValueOfSearchCategory///////////////////////////
/**
* @param CategoryName
* @param CategoryValue
* @return added_or_Not
* this method can ad value for the categoryname parameter
*/
///////////////////////////////////deleteSearchCategory/////////////////////////////
/**
* @param categoryIndex
* @return added_or_Not
* this method delete list from search category table which its index as category index parameter
*/
//////////////////////////////editSearchCategory///////////////
/**
* @param CategoryKey
* @param UpdatedValue
* @return saved_or_Not
* this method can edit in the value of specific list and return true if saved and false otherwise
*/
//////////////////loadSoldBuilding/////////////////
/**
* @param sold
* @return object of type building
* load all bought buildings
*/
////////////////////////loadBuyBuilding////////////////