import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JOptionPane;

public class Registrazione {
	public static void main(String[] args) {
String usrDB = "root", pswDB = "admin";

		String driver = "com.mysql.jdbc.Driver";

		String url = "jdbc:mysql://localhost/almaviva";

		Connection connection;

		try {
			Class.forName(driver);
			String userIn = JOptionPane.showInputDialog("Inserire nome utente");
			String pswdIn = JOptionPane.showInputDialog("Inserire password");

			if(userIn != null && !userIn.equals("") && pswdIn != null
					&& !pswdIn.equals("")) {
				if(userIn.length()<=20 && pswdIn.length() <= 30) {
					System.out.println("Tentativo di connessione in corso...");

					connection = DriverManager.getConnection(url, usrDB, pswDB);

					Statement statement;

					statement = connection.createStatement();

					String sql = "insert into almaviva.user(USERNAME, PASSWORD) values ('"+userIn+"', '"+pswdIn+"')";
					System.out.println(sql);

					statement.executeUpdate(sql);

					connection.close();
				}else
					System.out.println("Parametri di registrazione non ammessi");
			}else
				System.out.println("Parametri non ammessi");

		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();

			System.out.println("Connessione non avvenuta, "
					+ "controllare driver o parametri di accesso");
		}
	}
}