Project Report

LAB-8

Database Connectivity
package com.farm.utility;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBConnect {

public static Connection getConn() {

Connection con=null;

String loadDriver = "com.mysql.cj.jdbc.Driver"; // driver name for mysqlString

dbURL = "jdbc:mysql://localhost:3306/farmdb"; // url of the

// database

String dbUSERNAME = "root"; // username to coonect dbString

dbPASSWORD = "khan"; // password to connect db

try {

Class.forName(loadDriver); // load the driver

Con =DriverManager.getConnection(dbURLdbUSERNAME,dbPASSWORD);// get
// the connection
} catch (ClassNotFoundException e) {
 // TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}
return con;
}
}

Bean Classes
package com.farm.Bean;

public class CustomerBean {

private int id;

private String name;
private String username;
private String mobile;
private String password;
private String email;
private String city;
private String state;
private String address;
private int roleid;
private String newpassword;

public String getNewpassword() {

return newpassword;
}
public void setNewpassword(String newpassword) {
this.newpassword = newpassword;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
 public void setName(String name) {
this.name = name;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public int getRoleid() {
return roleid;
}
public void setRoleid(int roleid) {
this.roleid = roleid;
}
}
package com.farm.Bean;
import java.io.InputStream;
import javax.servlet.http.Part;
import com.mysql.cj.jdbc.Blob;

public class CropBean {

private int id;
private String crop_name;

private String crop_month;

private String crop_desc;

private String image;

public String getImage() {

return image;

public void setImage(String image) {

this.image = image;

public int getId() {

return id;

public void setId(int id) {

this.id = id;
 }

public String getCrop_name() {

return crop_name;

public void setCrop_name(String crop_name) {

this.crop_name = crop_name;

public String getCrop_month() {

return crop_month;

public void setCrop_month(String crop_month) {

this.crop_month = crop_month;

public String getCrop_desc() {

return crop_desc;

public void setCrop_desc(String crop_desc) {

this.crop_desc = crop_desc;

}package com.farm.Bean;
public class EquipmentBean {
private int id;
private String ename;
private String erange;
private String edesc;
private String image;
public int getId() {
return id;
 }
public void setId(int id) {
this.id = id;
}
public String getEname() {
return ename;
}
public void setEname(String ename) {
this.ename = ename;
}
public String getErange() {
return erange;
}
public void setErange(String erange) {
this.erange = erange;
}
public String getEdesc() {
return edesc;
}
public void setEdesc(String edesc) {
this.edesc = edesc;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}

}
package com.farm.Bean;

public class InsecticideBean {

private int id;

private String iname;
private String irange;
private String idesc;
private String image;

public String getImage() {

return image;
}
public void setImage(String image) {
this.image = image;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getIname() {
return iname;
}
public void setIname(String iname) {
this.iname = iname;
}
public String getIrange() {
return irange;
}
public void setIrange(String irange) {
this.irange = irange;
}
 public String getIdesc() {
return idesc;
}
public void setIdesc(String idesc) {
this.idesc = idesc;
}

}
package com.farm.Bean;

public class PesticideBean {

private int id;
private String pname;
private String prange;
private String pdesc;
private String image;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getPname() {
return pname;
}
public void setPname(String pname) {
this.pname = pname;
}
public String getPrange() {
return prange;
}
public void setPrange(String prange) {
this.prange = prange;
}
public String getPdesc() {
return pdesc;
}
public void setPdesc(String pdesc) {
this.pdesc = pdesc;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}

}
Controller Classes
package com.farm.Ctrl;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.SQLException;
import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.farm.Bean.CustomerBean;

import com.farm.Model.CustomerDAO;

import com.farm.utility.Validation;

/**

* Servlet implementation class CustomerCtrl

*/

@WebServlet("/CustomerCtrl")

public class CustomerCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public CustomerCtrl() {

super();

// TODO Auto-generated constructor stub

/**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

request.getRequestDispatcher("regcustomer.jsp").forward(request, response);

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

//doGet(request, response);

PrintWriter printWriter=response.getWriter();

printWriter.print("hi");

/* Take parameter from user*/

String name=request.getParameter("name");

String uname=request.getParameter("uname");

String mobile=request.getParameter("mobile");

String password=request.getParameter("pass");

String email=request.getParameter("email");

String city=request.getParameter("city");

String state=request.getParameter("state");

String address=request.getParameter("address");
/* SET parameter to Bean*/

CustomerBean bean=new CustomerBean();

bean.setName(name);

bean.setUsername(uname);

bean.setMobile(mobile);

bean.setPassword(password);

bean.setEmail(email);

bean.setCity(city);

bean.setState(state);

bean.setAddress(address);

bean.setRoleid(2); //for customer I have set role id to 2.

HttpSession httpSession=request.getSession();

/* Call DAO class with bean object*/

CustomerDAO customerDAO=new CustomerDAO();

try {

int i=customerDAO.registerCustomer(bean);

if(i>0)

System.out.println("registerd");

String msg="Registerd Successfully";

request.setAttribute("msg", msg);
 request.getRequestDispatcher("regcustomer.jsp").forward(request,
response);
}

else

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

System.out.println("in here");

httpSession.setAttribute("ERROR", "USERNAME ALREADY EXIST");

request.setAttribute("errmsg", "USERNAME ALREADY EXIST");

//response.sendRedirect("regcustomer.jsp");
request.getRequestDispatcher("regcustomer.jsp").forward(request,
response);
} //call for registering customer

package com.farm.Ctrl;

import java.io.File;

import java.io.FileInputStream;
import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.nio.file.Paths;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.farm.Bean.CropBean;

import com.farm.Model.CropDAO;

import com.mysql.cj.jdbc.Blob;

/**

* Servlet implementation class CropCtrl

*/

@WebServlet("/CropCtrl")

@MultipartConfig(maxFileSize = 16177215)

public class CropCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

 /**

* @see HttpServlet#HttpServlet()

*/

public CropCtrl() {

super();

// TODO Auto-generated constructor stub

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

request.getRequestDispatcher("addcrop.jsp").forward(request, response);

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected String SubImage(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String savePath = "D:\\Newproject\\Farm-management-

system\\src\\main\\webapp\\images\\crops" ;
 File fileSaveDir = new File(savePath);

if (!fileSaveDir.exists()) {

fileSaveDir.mkdir();

Part part = request.getPart("image");

String fileName = extractFileName(part);

part.write(savePath + File.separator + fileName);

String filePath = fileName;

System.out.println("Path --- " + savePath + File.separator + fileName);

return fileName;
}

private String extractFileName(Part part) {

String contentDisp = part.getHeader("content-disposition");

String[] items = contentDisp.split(";");

for (String s : items) {

if (s.trim().startsWith("filename")) {

return s.substring(s.indexOf("=") + 2, s.length() - 1);

return "";

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {
 // TODO Auto-generated method stub

//Location for uploding file

if(request.getParameter("Action").equals("Add"))

System.out.println("add");

CropBean bean=new CropBean();

String cname=request.getParameter("cname");

String cmonth=request.getParameter("range");

String desc=request.getParameter("desc");

//Part filePart = request.getPart("image");

bean.setCrop_name(cname);

bean.setCrop_month(cmonth);

bean.setCrop_desc(desc);

//bean.setImage(filePart);

bean.setImage(SubImage(request, response));

/*Part part=null;

part=request.getPart("image");*/

/* String imgName=Paths.get(part.getSubmittedFileName()).getFileName().toString();

bean.setImage(imgName);

String path=getServletContext().getRealPath("images")+ File.separator+ "crops"

+File.separator+part.getSubmittedFileName();*/

// String fileName = Paths.get(part.getSubmittedFileName()).getFileName().toString();

CropDAO cropDAO=new CropDAO();

try {
 int result=cropDAO.addCrop(bean);

if(result>0)

request.setAttribute("msg", "Added Successfully");

request.getRequestDispatcher("addcrop.jsp").forward(request,
response);
}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

if(request.getParameter("Action").equals("Edit"))

System.out.println("hello");

CropBean bean2=new CropBean();

bean2.setId(Integer.parseInt(request.getParameter("id")));

//bean2.setCrop_name(request.getParameter("cname"));

//bean2.setCrop_month(request.getParameter("cmonth"));

//bean2.setCrop_desc(request.getParameter("cdesc"));

bean2.setImage(SubImage(request, response));

/*Part part1=null;

part1=request.getPart("image");*/

CropDAO cropDAO2=new CropDAO();

try {

int result=cropDAO2.editCrops(bean2);

if(result>0)
 {
System.out.println("result is"+result);

String msg="Edited";

request.setAttribute("msg", msg);

request.getRequestDispatcher("editcrop.jsp").forward(request, response);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

request.getRequestDispatcher("error.jsp").forward(request,
response);
}

package com.farm.Ctrl;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;
import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.farm.Bean.CustomerBean;

import com.farm.utility.DBConnect;

import com.mysql.cj.protocol.Message;

/**

* Servlet implementation class ChangepasswordCtrl

*/

@WebServlet("/ChangepasswordCtrl")

public class ChangepasswordCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public ChangepasswordCtrl() {

super();

// TODO Auto-generated constructor stub

}
 /**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

System.out.println("inside change passwd");

// TODO Auto-generated method stub

PrintWriter p=response.getWriter();

HttpSession httpSession=request.getSession();

CustomerBean bean=new CustomerBean();

// int id=Integer.parseInt(request.getParameter("id"));

String user=request.getParameter("t2");

//String olpdpwd=request.getParameter("opwd");

String newpwd=request.getParameter("npwd");

String conpwd=request.getParameter("cpwd");
 Connection con=DBConnect.getConn();

String sql="UPDATE F_USER SET PASSWORD='"+newpwd+"' WHERE

USERNAME = '"+user+"'";

try {

PreparedStatement preparedStatement=con.prepareStatement(sql);

int i=preparedStatement.executeUpdate();

if(i>0)

String msg="Password Updated Successfully!!";

request.setAttribute("msg", msg);

request.getRequestDispatcher("Changepassword.jsp").forward(request,
response);
}else

{
response.sendRedirect("error.jsp");
}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

//dao.change("opwd","npwd","cpwd");

package com.farm.Ctrl;
import java.io.File;

import java.io.IOException;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.farm.Bean.EquipmentBean;

import com.farm.Bean.InsecticideBean;

import com.farm.Model.EquipDAO;

import com.farm.Model.InsecDAO;

/**

* Servlet implementation class EquipmentCtrl

*/

@WebServlet("/EquipmentCtrl")

@MultipartConfig(maxFileSize = 16177215)

public class EquipmentCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**
 * @see HttpServlet#HttpServlet()

*/

public EquipmentCtrl() {

super();

// TODO Auto-generated constructor stub

protected String SubImage(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String savePath = "D:\\Newproject\\Farm-management-

system\\src\\main\\webapp\\images\\equip" ;

File fileSaveDir = new File(savePath);

if (!fileSaveDir.exists()) {

fileSaveDir.mkdir();

Part part = request.getPart("image");

String fileName = extractFileName(part);

part.write(savePath + File.separator + fileName);

String filePath = fileName;

System.out.println("Path --- " + savePath + File.separator + fileName);

return fileName;
 }

private String extractFileName(Part part) {

String contentDisp = part.getHeader("content-disposition");

String[] items = contentDisp.split(";");

for (String s : items) {

if (s.trim().startsWith("filename")) {

return s.substring(s.indexOf("=") + 2, s.length() - 1);

return "";

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

 if(request.getParameter("Action").equals("Add"))

System.out.println("add");

EquipmentBean bean=new EquipmentBean();

String cname=request.getParameter("cname");

String crange=request.getParameter("range");

String desc=request.getParameter("desc");

//Part filePart = request.getPart("image");

bean.setEname(cname);

bean.setErange(crange);

bean.setEdesc(desc);

//bean.setImage(filePart);

bean.setImage(SubImage(request, response));

EquipDAO inDao=new EquipDAO();

try {

int result=inDao.addEquipment(bean);

if(result>0)

request.setAttribute("msg", "Added Successfully");

request.getRequestDispatcher("addEquip.jsp").forward(request,
response);
}

} catch (SQLException e) {
 // TODO Auto-generated catch block

e.printStackTrace();

if(request.getParameter("Action").equals("Edit"))
{
System.out.println("hello");

EquipmentBean bean2=new EquipmentBean();

bean2.setId(Integer.parseInt(request.getParameter("id")));

//bean2.setIname(request.getParameter("cname"));

bean2.setErange(request.getParameter("cmonth"));

//bean2.setIdesc(request.getParameter("cdesc"));

//bean2.setImage(SubImage(request, response));

/*Part part1=null;

part1=request.getPart("image");*/

EquipDAO insecDAO=new EquipDAO();

try {

int result=insecDAO.editEquip(bean2);

if(result>0)

System.out.println("result is"+result);

String msg="Edited";

request.setAttribute("msg", msg);

request.getRequestDispatcher("editequip.jsp").forward(request, response);

} catch (SQLException e) {
 // TODO Auto-generated catch block

e.printStackTrace();

request.getRequestDispatcher("error.jsp").forward(request,
response);
}

}
}

package com.farm.Ctrl;

import java.io.File;

import java.io.IOException;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.farm.Bean.CropBean;

import com.farm.Bean.InsecticideBean;
import com.farm.Model.CropDAO;

import com.farm.Model.InsecDAO;

/**

* Servlet implementation class InsecCtrl

*/

@WebServlet("/InsecCtrl")

@MultipartConfig(maxFileSize = 16177215)

public class InsecCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public InsecCtrl() {

super();

// TODO Auto-generated constructor stub

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

}
 protected String SubImage(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String savePath = "D:\\Newproject\\Farm-management-

system\\src\\main\\webapp\\images\\insecticide" ;

File fileSaveDir = new File(savePath);

if (!fileSaveDir.exists()) {

fileSaveDir.mkdir();

Part part = request.getPart("image");

String fileName = extractFileName(part);

part.write(savePath + File.separator + fileName);

String filePath = fileName;

System.out.println("Path --- " + savePath + File.separator + fileName);

return fileName;

private String extractFileName(Part part) {

String contentDisp = part.getHeader("content-disposition");

String[] items = contentDisp.split(";");

 for (String s : items) {

if (s.trim().startsWith("filename")) {

return s.substring(s.indexOf("=") + 2, s.length() - 1);

return "";
}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

if(request.getParameter("Action").equals("Add"))

System.out.println("add");

InsecticideBean bean=new InsecticideBean();

String cname=request.getParameter("cname");

String crange=request.getParameter("range");

String desc=request.getParameter("desc");

//Part filePart = request.getPart("image");

bean.setIname(cname);

bean.setIrange(crange);

bean.setIdesc(desc);
 //bean.setImage(filePart);

bean.setImage(SubImage(request, response));

InsecDAO inDao=new InsecDAO();

try {

int result=inDao.addInsecticide(bean);

if(result>0)

request.setAttribute("msg", "Added Successfully");

request.getRequestDispatcher("addinsectide.jsp").forward(request,
response);
}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

if(request.getParameter("Action").equals("Edit"))
{
System.out.println("hello");

InsecticideBean bean2=new InsecticideBean();

bean2.setId(Integer.parseInt(request.getParameter("id")));

//bean2.setIname(request.getParameter("cname"));

bean2.setIrange(request.getParameter("cmonth"));

//bean2.setIdesc(request.getParameter("cdesc"));

bean2.setImage(SubImage(request, response));
 /*Part part1=null;

part1=request.getPart("image");*/

InsecDAO insecDAO=new InsecDAO();

try {

int result=insecDAO.editInsec(bean2);

if(result>0)

System.out.println("result is"+result);

String msg="Edited";

request.setAttribute("msg", msg);

request.getRequestDispatcher("editinsect.jsp").forward(request, response);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

request.getRequestDispatcher("error.jsp").forward(request,
response);
}

}
}

package com.farm.Ctrl;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import com.farm.Bean.CustomerBean;

import com.farm.Model.LoginDAO;

/**

* Servlet implementation class LoginCtrl

*/

@WebServlet("/LoginCtrl")

public class LoginCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public LoginCtrl() {

super();

// TODO Auto-generated constructor stub

}
 /**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

//request.getRequestDispatcher("about.jsp").forward(request, response);

request.getRequestDispatcher("login.jsp").forward(request, response);

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

System.out.println("in login");

if(request.getParameter("Action").equals("Login"))

HttpSession httpSession=request.getSession();

CustomerBean bean=new CustomerBean();

String username=request.getParameter("uname");

String pass=request.getParameter("pass");

//bean.setId(Integer.parseInt(request.getParameter("id")));

bean.setUsername(username);

bean.setPassword(pass);

LoginDAO dao=new LoginDAO();

 try {
String result=dao.validateUser(bean);

if(result.equals("ADMIN_ROLE"))

httpSession.setAttribute("admin", username);

request.setAttribute("msg", "Welcome");

response.sendRedirect("adminhome.jsp");

else if(result.equals("CUSTOMER_ROLE"))

System.out.println("inside customer role");

httpSession.setAttribute("user", username);

request.setAttribute("msg", "Welcome");

response.sendRedirect("userhome.jsp");

if(result.equals("INVALID")){

request.setAttribute("msg","Incorrect Login or password");

request.getRequestDispatcher("login.jsp").forward(request,
response);
}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}
 }

package com.farm.Ctrl;

import java.io.IOException;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

/**

* Servlet implementation class LogoutCtrl

*/

@WebServlet("/LogoutCtrl")

public class LogoutCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/
 public LogoutCtrl() {

super();

// TODO Auto-generated constructor stub

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

HttpSession session = request.getSession(false);

if (session != null) {

session.removeAttribute("admin");

request.setAttribute("ermsg", "You Have Logout");

RequestDispatcher dispatcher = request.getRequestDispatcher("login.jsp");

dispatcher.forward(request, response);

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

 }

package com.farm.Ctrl;

import java.io.File;

import java.io.IOException;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.annotation.MultipartConfig;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.Part;

import com.farm.Bean.InsecticideBean;

import com.farm.Bean.PesticideBean;

import com.farm.Model.InsecDAO;

import com.farm.Model.PesticideDAO;

/**

* Servlet implementation class PesticideCtrl

*/

@WebServlet("/PesticideCtrl")

@MultipartConfig(maxFileSize = 16177215)
public class PesticideCtrl extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public PesticideCtrl() {

super();

// TODO Auto-generated constructor stub

protected String SubImage(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String savePath = "D:\\Newproject\\Farm-management-

system\\src\\main\\webapp\\images\\Pesticide" ;

File fileSaveDir = new File(savePath);

if (!fileSaveDir.exists()) {

fileSaveDir.mkdir();

Part part = request.getPart("image");

String fileName = extractFileName(part);

part.write(savePath + File.separator + fileName);

String filePath = fileName;

System.out.println("Path --- " + savePath + File.separator + fileName);

 return fileName;

private String extractFileName(Part part) {

String contentDisp = part.getHeader("content-disposition");

String[] items = contentDisp.split(";");

for (String s : items) {

if (s.trim().startsWith("filename")) {

return s.substring(s.indexOf("=") + 2, s.length() - 1);

return "";

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

/**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws

ServletException, IOException {

// TODO Auto-generated method stub

if(request.getParameter("Action").equals("Add"))

System.out.println("add");

PesticideBean bean=new PesticideBean();

String cname=request.getParameter("cname");

String crange=request.getParameter("range");

String desc=request.getParameter("desc");

//Part filePart = request.getPart("image");

bean.setPname(cname);

bean.setPrange(crange);

bean.setPdesc(desc);

//bean.setImage(filePart);

bean.setImage(SubImage(request, response));

PesticideDAO inDao=new PesticideDAO();

try {

int result=inDao.addPesticide(bean);

if(result>0)

{
 request.setAttribute("msg", "Added Successfully");
request.getRequestDispatcher("addpesticide.jsp").forward(request,
response);
}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

if(request.getParameter("Action").equals("Edit"))
{
System.out.println("hello");

PesticideBean bean2=new PesticideBean();

bean2.setId(Integer.parseInt(request.getParameter("id")));

//bean2.setIname(request.getParameter("cname"));

bean2.setPrange(request.getParameter("cmonth"));

//bean2.setIdesc(request.getParameter("cdesc"));

bean2.setImage(SubImage(request, response));

/*Part part1=null;

part1=request.getPart("image");*/

PesticideDAO insecDAO=new PesticideDAO();

try {

int result=insecDAO.editPesticide(bean2);

if(result>0)

System.out.println("result is"+result);

String msg="Edited";
 request.setAttribute("msg", msg);

request.getRequestDispatcher("editPesticide.jsp").forward(request, response);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

request.getRequestDispatcher("error.jsp").forward(request,
response);
}

}
}

Model Classes
package com.farm.Model;

import java.sql.Blob;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.farm.Bean.CropBean;

import com.farm.utility.DBConnect;
public class CropDAO {

public int addCrop(CropBean bean) throws SQLException {

// TODO Auto-generated method stub

Connection con=DBConnect.getConn();

String sql="INSERT INTO F_CROPS (CNAME,CMONTH,CIMAGE,CDESC)

VALUES (?,?,?,?)";

PreparedStatement preparedStatement=con.prepareStatement(sql);

preparedStatement.setString(1, bean.getCrop_name());

preparedStatement.setString(2, bean.getCrop_month());

preparedStatement.setString(3, bean.getImage());

preparedStatement.setString(4, bean.getCrop_desc());

int i=preparedStatement.executeUpdate();

if(i>0)

return i;

return i;

public static CropBean getRecordById(int id) throws SQLException

CropBean bean=new CropBean();

Connection con = DBConnect.getConn();

String sql = "SELECT * FROM F_CROPS where ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setInt(1, id);
 ResultSet rs = preparedStatement.executeQuery();

while(rs.next())

bean.setId(rs.getInt(1));

bean.setCrop_name(rs.getString(2));

bean.setCrop_month(rs.getString(3));

bean.setImage(rs.getString(4));

bean.setCrop_desc(rs.getString(5));

return bean;

public int editCrops(CropBean bean2) throws SQLException {

System.out.println("hello");

Connection con = DBConnect.getConn();

String sql = "UPDATE F_CROPS SET CIMAGE=? WHERE ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setString(1, bean2.getImage());

preparedStatement.setInt(2, bean2.getId());

int status=preparedStatement.executeUpdate();

if(status>0)

return 1;

}
 return 0;

// TODO Auto-generated method stub

package com.farm.Model;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import com.farm.Bean.CustomerBean;

import com.farm.utility.DBConnect;

public class CustomerDAO {

public int registerCustomer(CustomerBean bean) throws SQLException {

// TODO Auto-generated method stub

Connection conn=DBConnect.getConn();

String sql="INSERT INTO F_USER

(NAME,USERNAME,MOBILE,PASSWORD,EMAIL,CITY,STATE,ADDRESS,ROLEID)
VALUES (?,?,?,?,?,?,?,?,?)";

PreparedStatement preparedStatement=conn.prepareStatement(sql);

preparedStatement.setString(1,bean.getName());

preparedStatement.setString(2, bean.getUsername());

preparedStatement.setString(3, bean.getMobile());
 preparedStatement.setString(4, bean.getPassword());

preparedStatement.setString(5, bean.getEmail());

preparedStatement.setString(6, bean.getCity());

preparedStatement.setString(7, bean.getState());

preparedStatement.setString(8, bean.getAddress());

preparedStatement.setInt(9, bean.getRoleid());

int result=preparedStatement.executeUpdate();

System.out.println("statement executed "+result);

if(result>0)

return result;

return result;

package com.farm.Model;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.farm.Bean.EquipmentBean;

import com.farm.utility.DBConnect;
public class EquipDAO {

public int addEquipment(EquipmentBean bean) throws SQLException {

// TODO Auto-generated method stub

Connection con=DBConnect.getConn();

String sql="INSERT INTO F_EQUIPMENT (ENAME,ERANGE,IMAGE,EDESC)

VALUES (?,?,?,?)";

PreparedStatement preparedStatement=con.prepareStatement(sql);

preparedStatement.setString(1, bean.getEname());

preparedStatement.setString(2, bean.getErange());

preparedStatement.setString(3, bean.getImage());

preparedStatement.setString(4, bean.getEdesc());

int i=preparedStatement.executeUpdate();

if(i>0)

return i;

return i;

public static EquipmentBean getRecordById(int id) throws SQLException

EquipmentBean bean=new EquipmentBean();

Connection con = DBConnect.getConn();

String sql = "SELECT * FROM F_EQUIPMENT where ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setInt(1, id);
 ResultSet rs = preparedStatement.executeQuery();

while(rs.next())

bean.setId(rs.getInt(1));

bean.setEname(rs.getString(2));

bean.setErange(rs.getString(3));

bean.setEdesc(rs.getString(4));

bean.setImage(rs.getString(5));

return bean;

public int editEquip(EquipmentBean bean2) throws SQLException {

// TODO Auto-generated method stub

System.out.println("hello");

Connection con = DBConnect.getConn();

String sql = "UPDATE f_EQUIPMENT SET ERANGE=? WHERE ID=?";

// String sql = "UPDATE f_EQUIPMENT SET ERANGE=?,IMAGE=? WHERE
ID=?";
PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setString(1, bean2.getErange());

//preparedStatement.setString(2, bean2.getImage());
 preparedStatement.setInt(2, bean2.getId());

int status=preparedStatement.executeUpdate();

if(status>0)

return 1;

return 0;

// TODO Auto-generated method stub

}
}

package com.farm.Model;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.farm.Bean.InsecticideBean;

import com.farm.utility.DBConnect;

public class InsecDAO {

public int addInsecticide(InsecticideBean bean) throws SQLException {

// TODO Auto-generated method stub

Connection con=DBConnect.getConn();
 String sql="INSERT INTO F_INSECTICIDE (INAME,IRANGE,IMAGE,IDESC)
VALUES (?,?,?,?)";

PreparedStatement preparedStatement=con.prepareStatement(sql);

preparedStatement.setString(1, bean.getIname());

preparedStatement.setString(2, bean.getIrange());

preparedStatement.setString(3, bean.getImage());

preparedStatement.setString(4, bean.getIdesc());

int i=preparedStatement.executeUpdate();

if(i>0)

return i;

return i;

public static InsecticideBean getRecordById(int id) throws SQLException

InsecticideBean bean=new InsecticideBean();

Connection con = DBConnect.getConn();

String sql = "SELECT * FROM F_INSECTICIDE where ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setInt(1, id);

ResultSet rs = preparedStatement.executeQuery();

while(rs.next())

bean.setId(rs.getInt(1));

bean.setIname(rs.getString(2));
 bean.setIrange(rs.getString(3));

bean.setIdesc(rs.getString(4));

bean.setImage(rs.getString(5));

return bean;

public int editInsec(InsecticideBean bean2) throws SQLException {

// TODO Auto-generated method stub

System.out.println("hello");

Connection con = DBConnect.getConn();

String sql = "UPDATE f_insecticide SET IRANGE=?,IMAGE=? WHERE ID=?";

//String sql = "UPDATE f_insecticide SET IRANGE=?,IMAGE=? WHERE ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setString(1, bean2.getIrange());

//preparedStatement.setString(2, bean2.getImage());

preparedStatement.setInt(2, bean2.getId());

int status=preparedStatement.executeUpdate();

if(status>0)

return 1;

}
 return 0;

// TODO Auto-generated method stub

}

package com.farm.Model;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.farm.Bean.CustomerBean;

import com.farm.utility.DBConnect;

public class LoginDAO {

public String validateUser(CustomerBean bean) throws SQLException {

String username=bean.getUsername();

String password=bean.getPassword();

int id=bean.getId();

System.out.println("username" +username+"password "+password+ "id is "+id);

 Connection con=DBConnect.getConn();

Statement statement=con.createStatement();

ResultSet rs=statement.executeQuery("SELECT * FROM F_USER WHERE

USERNAME='"+username+"' AND PASSWORD='"+password+"'");

while(rs.next())

String usernamedb=rs.getString("username");

String passdb=rs.getString("password");

int roledb=rs.getInt("roleid");

System.out.println("usernamedb "+usernamedb+"passdb "+passdb);

if(username.equals(usernamedb) && password.equals(passdb) &&
roledb==1)
return "ADMIN_ROLE";

else if (username.equals(usernamedb) && password.equals(passdb) &&

roledb==2)
return "CUSTOMER_ROLE";
}

return "INVALID";

// TODO Auto-generated method stub

}
package com.farm.Model;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import com.farm.Bean.InsecticideBean;

import com.farm.Bean.PesticideBean;

import com.farm.utility.DBConnect;

public class PesticideDAO {

public int addPesticide(PesticideBean bean) throws SQLException {

// TODO Auto-generated method stub

Connection con=DBConnect.getConn();

String sql="INSERT INTO F_PESTICIDE (PNAME,PRANGE,IMAGE,PDESC)

VALUES (?,?,?,?)";

PreparedStatement preparedStatement=con.prepareStatement(sql);

preparedStatement.setString(1, bean.getPname());

preparedStatement.setString(2, bean.getPrange());

preparedStatement.setString(3, bean.getImage());

preparedStatement.setString(4, bean.getPdesc());

int i=preparedStatement.executeUpdate();

if(i>0)

return i;

}
 return i;
}

public static PesticideBean getRecordById(int id) throws SQLException

PesticideBean bean=new PesticideBean();

Connection con = DBConnect.getConn();

String sql = "SELECT * FROM F_PESTICIDE where ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setInt(1, id);

ResultSet rs = preparedStatement.executeQuery();

while(rs.next())

bean.setId(rs.getInt(1));

bean.setPname(rs.getString(2));

bean.setPrange(rs.getString(3));

bean.setPdesc(rs.getString(4));

bean.setImage(rs.getString(5));

return bean;

public int editPesticide(PesticideBean bean2) throws SQLException {

// TODO Auto-generated method stub

 System.out.println("hello");

Connection con = DBConnect.getConn();

String sql = "UPDATE f_pesticide SET PRANGE=?,IMAGE=? WHERE ID=?";

//String sql = "UPDATE f_insecticide SET IRANGE=?,IMAGE=? WHERE ID=?";

PreparedStatement preparedStatement = con.prepareStatement(sql);

preparedStatement.setString(1, bean2.getPrange());

//preparedStatement.setString(2, bean2.getImage());

preparedStatement.setInt(2, bean2.getId());

int status=preparedStatement.executeUpdate();

if(status>0)

return 1;

return 0;

// TODO Auto-generated method stub

}
}

OUTPUT:
Screen Snapshot