Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int checkUser(String email, String pass) {
- int st = -100;
- String qry="";
- try {
- System.out.println("====== 1 Acceso(Intento)");
- qry="select * from tmlogin where cmloginuser=? and cmloginpass=?";
- System.out.println("===================== "+qry+"==== "+email+" ===== "+pass);
- PreparedStatement ps = connection.prepareStatement(qry);
- ps.setString(1, email);
- ps.setString(2, pass);
- System.out.println("====== 2 Acceso(Intento) "+qry);
- ResultSet rs = ps.executeQuery();
- if (rs.next()){
- System.out.println("====== 3 Acceso(Concedido)");
- st=rs.getInt("imloginid");
- } else {
- System.out.println("====== 3 Acceso(DENEGADO)");
- }
- } catch (Exception e) {
- e.printStackTrace();
- System.out.println("=================================== "+qry);
- System.out.println(e.getMessage());
- }
- return st;
- }
- jak@zeus:/etc/mysql$ tail -f /opt/glassfish4/glassfish/domains/swItsol/logs/server.log
- at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)
- at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)
- at java.lang.Thread.run(Thread.java:745)]]
- [2016-02-22T14:06:50.963-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=19 _ThreadName=Thread-3] [timeMillis: 1456175210963] [levelValue: 800] [[
- =================================== select * from tmlogin where cmloginuser=? and cmloginpass=?]]
- [2016-02-22T14:06:50.964-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=19 _ThreadName=Thread-3] [timeMillis: 1456175210964] [levelValue: 800] [[
- null]]
- [2016-02-22T14:52:18.430-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938430] [levelValue: 800] [[
- ====== 1 Acceso(Intento)]]
- [2016-02-22T14:52:18.432-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938432] [levelValue: 800] [[
- ===================== select * from tmlogin where cmloginuser=? and cmloginpass=?==== jamiguel77@hotmail.com ===== 123]]
- [2016-02-22T14:52:18.432-0700] [glassfish 4.0] [SEVERE] [] [] [tid: _ThreadID=18 _ThreadName=Thread-4] [timeMillis: 1456177938432] [levelValue: 1000] [[
- java.lang.NullPointerException
- at classes.Validate.checkUser(Validate.java:55)
- at servlets.servletLogin.doPost(servletLogin.java:73)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
- at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
- at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
- at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
- at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
- at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:357)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:260)
- at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:188)
- at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:191)
- at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:168)
- at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:189)
- at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
- at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:288)
- at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:206)
- at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:136)
- at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:114)
- at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
- at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:838)
- at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:113)
- at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:115)
- at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:55)
- at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:135)
- at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:564)
- at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:544)
- at java.lang.Thread.run(Thread.java:745)]]
- [2016-02-22T14:52:18.434-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938434] [levelValue: 800] [[
- =================================== select * from tmlogin where cmloginuser=? and cmloginpass=?]]
- [2016-02-22T14:52:18.435-0700] [glassfish 4.0] [INFO] [] [] [tid: _ThreadID=18 _ThreadName=Thread-3] [timeMillis: 1456177938435] [levelValue: 800] [[
- null]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement