Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package model;
- import java.sql.*;
- public final class DbManager {
- public DbManager() {
- dbUser = System.getenv("db_user");
- dbPass = System.getenv("db_pass");
- dbUrl = System.getenv("db_url");
- }
- public void inserisciRegistrazione(UtenteBean newUtente) {
- try {
- // Register JDBC driver
- Class.forName("com.mysql.cj.jdbc.Driver");
- // Open a connection with a try-with-resources: non c'e' bisogno di chiamare la funzione close su conn, verrà chiusa alla fine del body
- try (Connection conn = DriverManager.getConnection(this.dbUrl, this.dbUser, this.dbPass)) {
- // Execute SQL query
- try (Statement stmt = conn.createStatement()) {
- String sql;
- sql = "INSERT INTO USER(email,username,nome,cognome,nazione,eta,password)VALUES(" + newUtente.getEmail() + ',' + newUtente.getUsername() + ',' + newUtente.getNome() + ',' + newUtente.getCognome() + ',' + newUtente.getNazione() + ',' + newUtente.getEta() + ',' + newUtente.getPassword() + ")";
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- } catch (ClassNotFoundException e) {
- // Handle errors for JDBC
- e.printStackTrace();
- }
- }
- public UtenteBean userLogin(UtenteBean utente) {
- UtenteBean user = new UtenteBean();
- try {
- // Register JDBC driver
- Class.forName("com.mysql.cj.jdbc.Driver");
- // Open a connection with a try-with-resources: non c'e' bisogno di chiamare la funzione close su conn, verrà chiusa alla fine del body
- try (Connection conn = DriverManager.getConnection(this.dbUrl, this.dbUser, this.dbPass)) {
- // Execute SQL query
- try (Statement stmt = conn.createStatement()) {
- String sql;
- sql = "SELECT * FROM user WHERE username = '" + utente.getUsername() + "' AND password = '" + utente.getPassword() + "'";
- stmt.executeQuery(sql);
- ResultSet rs = stmt.getResultSet();
- if (rs.next()) {
- utente.setUsername(rs.getString("username"));
- utente.setPassword(rs.getString("password"));
- utente.setEmail(rs.getString("email"));
- utente.setNome(rs.getString("nome"));
- utente.setCognome(rs.getString("cognome"));
- utente.setEta(rs.getString("nazione"));
- utente.setNazione(rs.getString("eta"));
- }
- return user;
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- } catch (ClassNotFoundException e) {
- // Handle errors for JDBC
- e.printStackTrace();
- }
- return utente;
- }
- private final String dbUser;
- private final String dbPass;
- private final String dbUrl;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement