private String cadenaconecion="jdbc:mysql://127.0.0.1/cafeteria";

private String usuario ="root";

private String contrasena="";

private Connection con =null;

public Connection getConnection() throws SQLException
{

        try {
            Class.forName("com.mysql.jdbc.Driver");
           con= (Connection) DriverManager.getConnection(usuario, cadenaconecion,contrasena);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(conexion.class.getName()).log(Level.SEVERE, null,ex);
        }


        return con;
    }