emp.zip_javascript

import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import javax.sql.*; import java.sql.*; public class emp_event extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{ response.setContentType("text/html"); PrintWriter out = response.getWriter(); System.out.println("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "user_register"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "root"; Statement st; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url+dbName,userName,password); System.out.println("Connected to the database"); String date = request.getParameter("date"); String event_description = request.getParameter("event_description"); String strar[] = date.split("-"); String cdate = strar[2]+"-" + strar[0]+"-"+ strar[1]; String query = "insert into emp_event set date_of_event='"+cdate+"',event_description='"+event_description+"'"; System.out.println("query " + query); out.println("query " + query); st = conn.createStatement(); int i = st.executeUpdate(query); if(i>0) { response.sendRedirect("viewevent.jsp"); } else { response.sendRedirect("emp_event.jsp"); } out.println(query); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { e.printStackTrace(); } } }