Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.50 KB | None | 0 0
  1. I tried checking like a hundred times and seriously caan't find the error -.-
  2.  
  3. DBAO.java:
  4. package database;
  5.  
  6. import model.AddEvents;
  7.  
  8.  
  9. import java.sql.Connection;
  10. import java.sql.Date;
  11. import java.sql.DriverManager;
  12. import java.sql.PreparedStatement;
  13. import java.sql.ResultSet;
  14. import java.sql.SQLException;
  15. import java.sql.Timestamp;
  16. import java.util.ArrayList;
  17.  
  18.  
  19. public class DBAO {
  20. Connection con;
  21. //Database Conifguration
  22. public static String url ="jdbc:mysql://localhost/backup?autoReconnect=true&useSSL=false";
  23. public static String dbdriver="com.mysql.jdbc.Driver";
  24. public static String username= "root";
  25. public static String password= "mysql";
  26.  
  27.  
  28. public DBAO() throws Exception{
  29. try{
  30. //Class.forName("com.mysql.jdbc.Driver").newInstance();
  31. //Connection conn = DriverManager.getConnection(url,"username","password");
  32. Class.forName(dbdriver);
  33. con=DriverManager.getConnection(url,username,password);
  34. con.setAutoCommit(true);
  35.  
  36. }catch(Exception ex){
  37. System.out.println("Exception in DBAO" + ex);
  38. throw new Exception("Couldn't open connection to database:" +
  39.  
  40. ex.getMessage());
  41. }
  42. }
  43.  
  44. public ArrayList<AddEvents>getAddEvents() throws Exception
  45. {
  46. AddEvents myEvent=null;
  47. ArrayList<AddEvents> myEventList = new ArrayList<AddEvents>();;
  48.  
  49.  
  50. try
  51. {
  52.  
  53.  
  54. String selectStatement ="select * from backup.add_event";
  55. PreparedStatement prepStmt = con.prepareStatement(selectStatement);
  56. ResultSet rs = prepStmt.executeQuery();
  57.  
  58. while(rs.next())
  59. {
  60.  
  61. System.out.println("Record Found!");
  62.  
  63. myEvent= new AddEvents();
  64. myEvent.setTitle(rs.getString("title"));
  65. myEvent.setEventDesc(rs.getString("eventDesc"));
  66. myEvent.setStartTime(rs.getString("StartTime"));
  67. myEvent.setEndTime(rs.getString("EndTime"));
  68. myEvent.setBudget(rs.getDouble("Budget"));
  69. myEvent.setStartDate(rs.getDate("StartDate"));
  70. myEvent.setEndDate(rs.getDate("EndDate"));
  71. myEvent.setEnvironment(rs.getString("Environment"));
  72. myEventList.add(myEvent);
  73.  
  74. }
  75. }catch(Exception ex)
  76. {
  77. System.out.println("Error:" +ex.getMessage());
  78. throw new Exception("Error:" +ex.getMessage());
  79. }
  80. System.out.println("AddEventsList SIZE=" +myEventList.size());
  81. return myEventList;
  82. }
  83.  
  84.  
  85. public model.AddEvents AddEvents(AddEvents event) throws Exception {
  86. // TODO Auto-generated method stub
  87. try{
  88. String insertStatement ="Insert into backup.add_event (title,eventDesc,StartTime, EndTime,Budget,StartDate,EndDate,Environment)";
  89. insertStatement=insertStatement+ "values(?,?,?,?,?,?,?,?)";
  90. PreparedStatement prepStmt1 = con.prepareStatement(insertStatement);
  91. System.out.println(insertStatement);
  92.  
  93. prepStmt1.setString(1,event.getTitle());
  94. prepStmt1.setString(2,event.getEventDesc());
  95. prepStmt1.setString(3,event.getStartTime());
  96. prepStmt1.setString(4,event.getEndTime());
  97. prepStmt1.setDouble(5,event.getBudget());
  98. prepStmt1.setDate(6,(Date) event.getStartDate());
  99. prepStmt1.setDate(7,(Date) event.getEndDate());
  100. prepStmt1.setString(8,event.getEnvironment());
  101.  
  102. int status=prepStmt1.executeUpdate();
  103.  
  104. if(status!=0){
  105. System.out.println("Record Added");
  106. }
  107.  
  108. }catch(Exception ex)
  109. {
  110. throw new Exception("Error:" +ex.getMessage());
  111. }
  112. return event;
  113. }
  114.  
  115. public boolean updateEvent(AddEvents myEvent)throws Exception{
  116. try
  117. {
  118. String updateStatement= "update backup.add_event set title=?,eventDesc=?,StartTime=? EndTime=?,Budget=?";
  119. updateStatement = updateStatement+",StartDate=?,EndDate=?,Environment=?";
  120. PreparedStatement prepStmt = con.prepareStatement(updateStatement);
  121. prepStmt.setString(1,myEvent.getTitle());
  122. prepStmt.setString(2,myEvent.getEventDesc());
  123. prepStmt.setString(3,myEvent.getStartTime());
  124. prepStmt.setString(4,myEvent.getEndTime());
  125. prepStmt.setDouble(5,myEvent.getBudget());
  126. prepStmt.setDate(6,(Date) myEvent.getStartDate());
  127. prepStmt.setDate(7,(Date) myEvent.getEndDate());
  128. prepStmt.setString(8,myEvent.getEnvironment());
  129.  
  130.  
  131. System.out.println("sql=" +prepStmt.toString());
  132. int status = prepStmt.executeUpdate();
  133. if(status!=0)
  134. {
  135. System.out.println("Record updated");
  136. return true;
  137. }
  138. else
  139. {
  140. return false;
  141. }
  142.  
  143. }catch(Exception ex)
  144. {
  145. throw new Exception("Error:" +ex.getMessage());
  146. }
  147.  
  148. }
  149. }
  150. UpdateServlet:
  151. package servlet;
  152.  
  153. import java.io.IOException;
  154. import javax.servlet.ServletException;
  155. import javax.servlet.annotation.WebServlet;
  156. import javax.servlet.http.HttpServlet;
  157. import javax.servlet.http.HttpServletRequest;
  158. import javax.servlet.http.HttpServletResponse;
  159. import javax.servlet.http.HttpSession;
  160.  
  161. import database.DBAO;
  162. import model.AddEvents;
  163.  
  164. /**
  165. * Servlet implementation class UpdateServlet
  166. */
  167. @WebServlet("/UpdateServlet")
  168. public class UpdateServlet extends HttpServlet {
  169. private static final long serialVersionUID = 1L;
  170.  
  171. /**
  172. * @see HttpServlet#HttpServlet()
  173. */
  174. public UpdateServlet() {
  175. super();
  176. // TODO Auto-generated constructor stub
  177. }
  178.  
  179. /**
  180. * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  181. */
  182. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  183. // TODO Auto-generated method stub
  184. //response.getWriter().append("Served at: ").append(request.getContextPath());
  185. }
  186.  
  187. /**
  188. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  189. */
  190. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  191. // TODO Auto-generated method stub
  192. //doGet(request, response);
  193. AddEvents myEvent = new AddEvents();
  194.  
  195. myEvent.setTitle(request.getParameter("Title"));
  196. myEvent.setEventDesc(request.getParameter("EventDesc"));
  197. myEvent.setStartDate(java.sql.Date.valueOf(request.getParameter("StartDate")));
  198. myEvent.setEndDate(java.sql.Date.valueOf(request.getParameter("EndDate")));
  199. myEvent.setStartTime(request.getParameter("StartTime"));
  200. myEvent.setEndTime(request.getParameter("EndTime"));
  201. //myEvent.setBudget(request.getParameter("Budget"));
  202. myEvent.setBudget(Double.valueOf(request.getParameter("Budget")));
  203. myEvent.setEnvironment(request.getParameter(request.getParameter("Environment")));
  204. try
  205. {
  206. DBAO myDatabase = new DBAO();
  207. boolean status= myDatabase.updateEvent(myEvent);
  208. if(status)
  209. {
  210. HttpSession mysess = request.getSession(true);
  211. mysess.setAttribute("Event_Info", myEvent);
  212. request.getRequestDispatcher("Retrieve.jsp").forward(request, response);
  213.  
  214. }
  215. else{
  216. request.getRequestDispatcher("Update.jsp").forward(request,response);
  217. }
  218. }
  219. catch(Exception ex)
  220. {
  221. System.out.println("Error="+ex.getMessage());
  222. }
  223. }
  224.  
  225. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement