Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.59 KB | None | 0 0
  1. public int checkUser(String email, String pass) {
  2. int st = -100;
  3. String qry="";
  4. try {
  5. System.out.println("====== 1 Acceso(Intento)");
  6. qry="select * from tmlogin where cmloginuser=? and cmloginpass=?";
  7. System.out.println("===================== "+qry+"==== "+email+" ===== "+pass);
  8. PreparedStatement ps = connection.prepareStatement(qry);
  9. ps.setString(1, email);
  10. ps.setString(2, pass);
  11. System.out.println("====== 2 Acceso(Intento) "+qry);
  12. ResultSet rs = ps.executeQuery();
  13. if (rs.next()){
  14. System.out.println("====== 3 Acceso(Concedido)");
  15. st=rs.getInt("imloginid");
  16. } else {
  17. System.out.println("====== 3 Acceso(DENEGADO)");
  18. }
  19.  
  20. } catch (Exception e) {
  21. e.printStackTrace();
  22. System.out.println("=================================== "+qry);
  23. System.out.println(e.getMessage());
  24. }
  25. return st;
  26. }
  27.  
  28.  
  29.  
  30.  
  31.  
  32. jak@zeus:/etc/mysql$ tail -f /opt/glassfish4/glassfish/domains/swItsol/logs/server.log
  33. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)
  34. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)
  35. at java.lang.Thread.run(Thread.java:745)]]
  36.  
  37. [2016-02-22T14:06:50.963-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=19 _ThreadName=Thread-3] [timeMillis: 1456175210963] [levelValue: 800] [[
  38. =================================== select * from tmlogin where cmloginuser=? and cmloginpass=?]]
  39.  
  40. [2016-02-22T14:06:50.964-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=19 _ThreadName=Thread-3] [timeMillis: 1456175210964] [levelValue: 800] [[
  41. null]]
  42.  
  43. [2016-02-22T14:52:18.430-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938430] [levelValue: 800] [[
  44. ====== 1 Acceso(Intento)]]
  45.  
  46. [2016-02-22T14:52:18.432-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938432] [levelValue: 800] [[
  47. ===================== select * from tmlogin where cmloginuser=? and cmloginpass=?==== jamiguel77@hotmail.com ===== 123]]
  48.  
  49. [2016-02-22T14:52:18.432-0700] [glassfish 4.0] [SEVERE] [] [] [tid: _ThreadID=18 _ThreadName=Thread-4] [timeMillis: 1456177938432] [levelValue: 1000] [[
  50. java.lang.NullPointerException
  51. at classes.Validate.checkUser(Validate.java:55)
  52. at servlets.servletLogin.doPost(servletLogin.java:73)
  53. at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  54. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  55. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
  56. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
  57. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
  58. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
  59. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
  60. at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
  61. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
  62. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:357)
  63. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:260)
  64. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:188)
  65. at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:191)
  66. at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:168)
  67. at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:189)
  68. at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
  69. at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:288)
  70. at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:206)
  71. at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:136)
  72. at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:114)
  73. at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
  74. at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:838)
  75. at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:113)
  76. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:115)
  77. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:55)
  78. at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:135)
  79. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)
  80. at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)
  81. at java.lang.Thread.run(Thread.java:745)]]
  82.  
  83. [2016-02-22T14:52:18.434-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938434] [levelValue: 800] [[
  84. =================================== select * from tmlogin where cmloginuser=? and cmloginpass=?]]
  85.  
  86. [2016-02-22T14:52:18.435-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938435] [levelValue: 800] [[
  87. null]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement