login_acc_processing
unknown
java
5 months ago
3.4 kB
6
Indexable
<%-- Document : login_acc_processing Created on : Nov 20, 2024, 12:20:58 AM Author : etchu --%> <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@page import="java.util.*, playermanagement.*, java.sql.*" %> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Account processing</title> </head> <body> <jsp:useBean id="rec" class="playermanagement.player_record" scope="session" /> <form action="player.html"> <% int player_id = 0; int acc_bal = 0; //out.println() lines are for debugging String v_player_name = request.getParameter("player_name"); out.println("Received player_name: " + v_player_name + ", "); rec.player_name = v_player_name; out.println("Assigning player name as: " + rec.player_name + ", "); int status = 0; System.out.print("login player function reached"); String query = "SELECT COUNT(*) FROM player_record WHERE player_name = ?"; try{ Class.forName("com.mysql.cj.jdbc.Driver"); Connection conn; //change the last param in getConnection() to your MySQL password 🙂 conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/gacha", "root", "root"); System.out.print("Connection Successful!"); PreparedStatement pstmt = conn.prepareStatement(query); pstmt.setString(1, v_player_name); rec.loadPlayers(); player_id = rec.getPlayerID(rec.player_name); System.out.println("player_id: " + player_id); acc_bal = rec.getAccBal(rec.player_name); System.out.println("acc_bal: " + acc_bal); ResultSet rst = pstmt.executeQuery(); if (rst.next() && rst.getInt(1) > 0){ System.out.println("There is a line"); pstmt.close(); conn.close(); status= 1; } else { System.out.println("There is no line"); pstmt.close(); conn.close(); status= 0; } }catch (SQLException e) { System.out.println(e.getMessage()); e.printStackTrace(); status= -1; } catch (Exception e) { System.out.println(e.getMessage()); e.printStackTrace(); status= -1; } out.println("Status: "+ status); if (status == 1) { session.setAttribute("player_id", player_id); session.setAttribute("acc_bal", acc_bal); //response.sendRedirect("play_page.jsp"); response.sendRedirect("play_test.jsp"); } else { %> <h1>login: Account Does not Exist</h1> <% } %> <input type="submit" value="Return to Player Menu"> </form> </body> </html>
Editor is loading...
Leave a Comment