{"action":"created","issue":{"url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/6","repository_url":"https://api.github.com/repos/urobdc/Consultorio_Medico","labels_url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/6/comments","events_url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/6/events","html_url":"https://github.com/urobdc/Consultorio_Medico/issues/6","id":192661900,"number":6,"title":"Tela Login","user":{"login":"urobdc","id":20849247,"avatar_url":"https://avatars.githubusercontent.com/u/20849247?v=3","gravatar_id":"","url":"https://api.github.com/users/urobdc","html_url":"https://github.com/urobdc","followers_url":"https://api.github.com/users/urobdc/followers","following_url":"https://api.github.com/users/urobdc/following{/other_user}","gists_url":"https://api.github.com/users/urobdc/gists{/gist_id}","starred_url":"https://api.github.com/users/urobdc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/urobdc/subscriptions","organizations_url":"https://api.github.com/users/urobdc/orgs","repos_url":"https://api.github.com/users/urobdc/repos","events_url":"https://api.github.com/users/urobdc/events{/privacy}","received_events_url":"https://api.github.com/users/urobdc/received_events","type":"User","site_admin":false},"labels":[{"id":491343266,"url":"https://api.github.com/repos/urobdc/Consultorio_Medico/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-11-30T19:51:29Z","updated_at":"2016-12-01T01:47:20Z","closed_at":null,"body":"Implementar tela Login com validação de usuário."},"comment":{"url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/comments/264054459","html_url":"https://github.com/urobdc/Consultorio_Medico/issues/6#issuecomment-264054459","issue_url":"https://api.github.com/repos/urobdc/Consultorio_Medico/issues/6","id":264054459,"user":{"login":"urobdc","id":20849247,"avatar_url":"https://avatars.githubusercontent.com/u/20849247?v=3","gravatar_id":"","url":"https://api.github.com/users/urobdc","html_url":"https://github.com/urobdc","followers_url":"https://api.github.com/users/urobdc/followers","following_url":"https://api.github.com/users/urobdc/following{/other_user}","gists_url":"https://api.github.com/users/urobdc/gists{/gist_id}","starred_url":"https://api.github.com/users/urobdc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/urobdc/subscriptions","organizations_url":"https://api.github.com/users/urobdc/orgs","repos_url":"https://api.github.com/users/urobdc/repos","events_url":"https://api.github.com/users/urobdc/events{/privacy}","received_events_url":"https://api.github.com/users/urobdc/received_events","type":"User","site_admin":false},"created_at":"2016-12-01T01:47:20Z","updated_at":"2016-12-01T01:47:20Z","body":"<%@page import=\"conexao.ConexaoMySQL\"%>\r\n<%@page import=\"java.sql.Statement\"%>\r\n<%@page import=\"java.sql.ResultSet\"%>\r\n\r\n\r\n<%\r\n    ConexaoMySQL.getConexaoMySQL();\r\n\r\n    ResultSet rs;\r\n    String login = request.getParameter(\"login\");\r\n    String password = request.getParameter(\"senha\");\r\n\r\n    String sqlStr = \"\";    \r\n    String login_existente = \"\";\r\n    String pass_existente = \"\";\r\n\r\n    \r\n\r\n    if (request.getParameter(\"login\") != \"\" && request.getParameter(\"password\") != \"\") {\r\n\r\n        sqlStr = (\"select usuario,senha from Consultorio_Login where USUARIO='\" + login + \"' and senha ='\" + password + \"';\");\r\n      \r\n        out.println(sqlStr);\r\n        rs = ConexaoMySQL.stmConection().executeQuery(sqlStr);\r\n\r\n        while (rs.next()) {\r\n            login_existente = rs.getString(\"usuario\");\r\n            pass_existente = rs.getString(\"senha\");            \r\n        }\r\n\r\n        if (login_existente.equals(login)) {\r\n            out.println(\"Cadastro Encontrado\");            \r\n            session.setAttribute(\"login: \", login_existente);\r\n            request.getRequestDispatcher(\"Main.jsp\").forward(request, response);\r\n        }\r\n        else\r\n            out.println(\"Usuario/Senha Incorreto\");\r\n        ConexaoMySQL.FecharConexao();\r\n    }\r\n\r\n%>\r\n\r\n<body>\r\n    \r\n    <form method=\"get\" action=\"Login.jsp\">\r\n    <center><br><br> Login <input type='login' name='login'>\r\n   Password <input type='password' value='' name=\"senha\">\r\n\r\n        <br><br><input type='submit' name='botao' value='Entrar'>\r\n        </body>\r\n        </html>\r\n"}}
{"actor":{"display_login":"urobdc"}}