Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within Servlets
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Jeanne Boyarsky
Ron McLeod
Paul Clapham
Liutauras Vilda
Sheriffs:
paul wheaton
Rob Spoor
Devaka Cooray
Saloon Keepers:
Stephan van Hulst
Tim Holloway
Carey Brown
Frits Walraven
Tim Moores
Bartenders:
Mikalai Zaikin
Forum:
Servlets
datas storing twice from servlet to mysql database
preethi Ayyappan
Ranch Hand
Posts: 518
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Hi,
I am storing some datas like username,logintime,logout time from my
servlet
program to mysql database.but when i login once ,the datas are getting stored twice.I cant find why this problem occurs?
my code follows:
package com.example.servlets; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.ServletContext; import javax.servlet.http.*; import java.sql.*; import javax.servlet.RequestDispatcher; import javax.servlet.http.HttpSession; /** * Servlet implementation class for Servlet: HelloServlet * */ public class RefServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet { Statement st; ResultSet rs=null; ResultSet rs1=null; Connection conn = null; public RefServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out=response.getWriter(); String USER = request.getParameter("USER_NAME"); //out.print(USER); String PASSWORD = request.getParameter("PASSWORD"); HttpSession session = request.getSession(); session.putValue("username",USER); //int interval=86400; //session.setMaxInactiveInterval(interval) ; try { Class.forName ("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/inboundcrm", "meetme", "meetme"); st = conn.createStatement(); rs=st.executeQuery("select * from users where username='"+ USER +"' and password='"+ PASSWORD +"'"); if(rs.next()) { String Extension=rs.getString("exten"); st.executeUpdate("update queue set loginflag=1,logintime=sysdate(),userstatus=1,statustime=sysdate() where user='"+ USER +"'"); st.executeUpdate("INSERT INTO logtime (`user` , `userlogintime` , `datetime`)VALUES('"+ USER +"' , sysdate(),sysdate())"); st.executeUpdate("delete from temp_time"); st.executeUpdate("Insert INTO temp_time(`usr_name` , `usr_login_time` , `extension`)VALUES('"+ USER +"' , sysdate(),'"+ Extension +"')"); try { Class.forName ("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/inboundcrm", "meetme", "meetme"); st = conn.createStatement(); //rs1=st.executeQuery("select * from time where usr_name='"+ USER +"'"); rs1=st.executeQuery("select * from temp_time where usr_name='"+ USER +"'"); if(rs1.next()) { String usrlogintime=rs1.getString("usr_login_time"); session.putValue("userlogintime",usrlogintime); } } catch(Exception e1) { e1.printStackTrace(); } response.sendRedirect("Crmpopupmain.html"); } else { response.sendRedirect("http://localhost:8080/NewWebProject/login.jsp"); } } catch(Exception e) { e.printStackTrace(); } } }
Thanks.
David O'Meara
Rancher
Posts: 13459
I like...
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Can we see the login form? Try to cut it down to just he important bits.
preethi Ayyappan
Ranch Hand
Posts: 518
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Thanks.Here is the login form
<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script language="JavaScript"> function validate () { if (document.order.USER_NAME.value == "") { alert("Please enter your Username.") document.order.USER_NAME.focus(); return false; } if (document.order.PASSWORD.value == "") { alert("Please enter your Password.") document.order.PASSWORD.focus(); return false; } document.order.submit(); } </script> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Login Details</title> </head> <body > <center> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr> <td height="210"><table width="100%" bgcolor="#1A4695"> <tr> <td><font face="arial,verdana" size="5" color="#ffffff"><b>LOGIN SCREEN</b></font></td> </tr> </table></td> </tr> <tr><td><form name="order" method="get" action="/NewWebProject/RefServlet" onsubmit="return validate();"> <div align="center"> <table cellpadding="1" cellspacing="0" border="0" bgcolor="#0296EC"> <tr> <td><table cellpadding="5" cellspacing="0" border="0" bgcolor="#F1F9FF"> <tr bgcolor="#0296EC"> <br /> <td colspan="2" align="left"><font size="2" face="arial,verdana" color="#ffffff"><b>Login</b></font></td> </tr> <tr> <td><font size="2" face="arial,verdana" color="#000000">Username</font></td> <td><input type="textfield" size="21" name="USER_NAME" ></td> </tr> <tr> <td><font size="2" face="arial,verdana" color="#000000">Password</font></td> <td><input type="password" size="22" name="PASSWORD"></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="Submit" value="Submit"></td> </tr> </table></td> </tr> </table></div></form></td></tr> <tr> <td><table cellpadding="5" cellspacing="0" border="0" bgcolor="#F1F9FF"></table></td></tr> <tr> <td><table cellpadding="5" cellspacing="0" border="0" bgcolor="#F1F9FF"> <tr bgcolor="#0296EC"> </tr> <tr><td>DONOTCLOSETHEBROWSERWITHOUTLOGGINGOUT</td></tr> <tr> <td><table width="100%" bgcolor="#1A4695"> </table></td> </tr> </table> </body> </html>
David O'Meara
Rancher
Posts: 13459
I like...
posted 15 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Thought so, your form is submitting twice. Your javascript should return true after validation rather than calling submit() again
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
Error on threads
page refresh problem
how to upload xls file
calling java inside a servlet
cookies problem
More...