Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @POST
- @Path("/login")
- @Consumes({"text/plain,application/json"})
- @Produces(MediaType.APPLICATION_JSON)
- public Response login(String data) throws Exception
- {
- JSONObject inc = new JSONObject(data);
- JSONObject inc2 = new JSONObject();
- System.out.println("WS"+inc.toString());
- Connection conn = null;
- String login = inc.getString("login");
- String password = inc.getString("password");
- System.out.println (login + " " + password);
- try {
- String dbURL = "jdbc:sqlserver://localhost:49581";
- String user = "admin";
- String pass = "admin";
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- conn = DriverManager.getConnection(dbURL, user, pass);
- if (conn != null) {
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT login,haslo FROM gracz WHERE login='" + login +"' AND haslo='" + password + "'");
- //System.out.println(rs);
- String login_pobrany = "admin";
- String pass_pobrany = "admin";
- while (rs.next()) {
- login_pobrany = rs.getString("login").trim();
- pass_pobrany = rs.getString("haslo").trim();
- }
- if (login_pobrany.equals(login) && pass_pobrany.equals(password))
- {
- inc2.put("status", "success");
- System.out.println("Pomyślne logowanie użytkownika: " + login);
- }
- else
- {
- inc2.put("status", "retry");
- System.out.println("Niepoprawne logowanie: " + login);
- }
- rs.close();
- stmt.close();
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- } finally {
- try {
- if (conn != null && !conn.isClosed()) {
- conn.close();
- }
- } catch (SQLException ex) {
- ex.printStackTrace();
- }
- }
- return Response.status(200).entity(inc2.toString()).build();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement