Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- I tried checking like a hundred times and seriously caan't find the error -.-
- DBAO.java:
- package database;
- import model.AddEvents;
- import java.sql.Connection;
- import java.sql.Date;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Timestamp;
- import java.util.ArrayList;
- public class DBAO {
- Connection con;
- //Database Conifguration
- public static String url ="jdbc:mysql://localhost/backup?autoReconnect=true&useSSL=false";
- public static String dbdriver="com.mysql.jdbc.Driver";
- public static String username= "root";
- public static String password= "mysql";
- public DBAO() throws Exception{
- try{
- //Class.forName("com.mysql.jdbc.Driver").newInstance();
- //Connection conn = DriverManager.getConnection(url,"username","password");
- Class.forName(dbdriver);
- con=DriverManager.getConnection(url,username,password);
- con.setAutoCommit(true);
- }catch(Exception ex){
- System.out.println("Exception in DBAO" + ex);
- throw new Exception("Couldn't open connection to database:" +
- ex.getMessage());
- }
- }
- public ArrayList<AddEvents>getAddEvents() throws Exception
- {
- AddEvents myEvent=null;
- ArrayList<AddEvents> myEventList = new ArrayList<AddEvents>();;
- try
- {
- String selectStatement ="select * from backup.add_event";
- PreparedStatement prepStmt = con.prepareStatement(selectStatement);
- ResultSet rs = prepStmt.executeQuery();
- while(rs.next())
- {
- System.out.println("Record Found!");
- myEvent= new AddEvents();
- myEvent.setTitle(rs.getString("title"));
- myEvent.setEventDesc(rs.getString("eventDesc"));
- myEvent.setStartTime(rs.getString("StartTime"));
- myEvent.setEndTime(rs.getString("EndTime"));
- myEvent.setBudget(rs.getDouble("Budget"));
- myEvent.setStartDate(rs.getDate("StartDate"));
- myEvent.setEndDate(rs.getDate("EndDate"));
- myEvent.setEnvironment(rs.getString("Environment"));
- myEventList.add(myEvent);
- }
- }catch(Exception ex)
- {
- System.out.println("Error:" +ex.getMessage());
- throw new Exception("Error:" +ex.getMessage());
- }
- System.out.println("AddEventsList SIZE=" +myEventList.size());
- return myEventList;
- }
- public model.AddEvents AddEvents(AddEvents event) throws Exception {
- // TODO Auto-generated method stub
- try{
- String insertStatement ="Insert into backup.add_event (title,eventDesc,StartTime, EndTime,Budget,StartDate,EndDate,Environment)";
- insertStatement=insertStatement+ "values(?,?,?,?,?,?,?,?)";
- PreparedStatement prepStmt1 = con.prepareStatement(insertStatement);
- System.out.println(insertStatement);
- prepStmt1.setString(1,event.getTitle());
- prepStmt1.setString(2,event.getEventDesc());
- prepStmt1.setString(3,event.getStartTime());
- prepStmt1.setString(4,event.getEndTime());
- prepStmt1.setDouble(5,event.getBudget());
- prepStmt1.setDate(6,(Date) event.getStartDate());
- prepStmt1.setDate(7,(Date) event.getEndDate());
- prepStmt1.setString(8,event.getEnvironment());
- int status=prepStmt1.executeUpdate();
- if(status!=0){
- System.out.println("Record Added");
- }
- }catch(Exception ex)
- {
- throw new Exception("Error:" +ex.getMessage());
- }
- return event;
- }
- public boolean updateEvent(AddEvents myEvent)throws Exception{
- try
- {
- String updateStatement= "update backup.add_event set title=?,eventDesc=?,StartTime=? EndTime=?,Budget=?";
- updateStatement = updateStatement+",StartDate=?,EndDate=?,Environment=?";
- PreparedStatement prepStmt = con.prepareStatement(updateStatement);
- prepStmt.setString(1,myEvent.getTitle());
- prepStmt.setString(2,myEvent.getEventDesc());
- prepStmt.setString(3,myEvent.getStartTime());
- prepStmt.setString(4,myEvent.getEndTime());
- prepStmt.setDouble(5,myEvent.getBudget());
- prepStmt.setDate(6,(Date) myEvent.getStartDate());
- prepStmt.setDate(7,(Date) myEvent.getEndDate());
- prepStmt.setString(8,myEvent.getEnvironment());
- System.out.println("sql=" +prepStmt.toString());
- int status = prepStmt.executeUpdate();
- if(status!=0)
- {
- System.out.println("Record updated");
- return true;
- }
- else
- {
- return false;
- }
- }catch(Exception ex)
- {
- throw new Exception("Error:" +ex.getMessage());
- }
- }
- }
- UpdateServlet:
- package servlet;
- import java.io.IOException;
- 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 database.DBAO;
- import model.AddEvents;
- /**
- * Servlet implementation class UpdateServlet
- */
- @WebServlet("/UpdateServlet")
- public class UpdateServlet extends HttpServlet {
- private static final long serialVersionUID = 1L;
- /**
- * @see HttpServlet#HttpServlet()
- */
- public UpdateServlet() {
- 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 {
- // TODO Auto-generated method stub
- //doGet(request, response);
- AddEvents myEvent = new AddEvents();
- myEvent.setTitle(request.getParameter("Title"));
- myEvent.setEventDesc(request.getParameter("EventDesc"));
- myEvent.setStartDate(java.sql.Date.valueOf(request.getParameter("StartDate")));
- myEvent.setEndDate(java.sql.Date.valueOf(request.getParameter("EndDate")));
- myEvent.setStartTime(request.getParameter("StartTime"));
- myEvent.setEndTime(request.getParameter("EndTime"));
- //myEvent.setBudget(request.getParameter("Budget"));
- myEvent.setBudget(Double.valueOf(request.getParameter("Budget")));
- myEvent.setEnvironment(request.getParameter(request.getParameter("Environment")));
- try
- {
- DBAO myDatabase = new DBAO();
- boolean status= myDatabase.updateEvent(myEvent);
- if(status)
- {
- HttpSession mysess = request.getSession(true);
- mysess.setAttribute("Event_Info", myEvent);
- request.getRequestDispatcher("Retrieve.jsp").forward(request, response);
- }
- else{
- request.getRequestDispatcher("Update.jsp").forward(request,response);
- }
- }
- catch(Exception ex)
- {
- System.out.println("Error="+ex.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement